A database system consists of software, hardware, and personnel used to store and manage data. It includes a database, which organizes information into tables containing rows and columns. There are different types of database users like single-user, multi-user, and administrator. Popular database management systems include Microsoft Access, Microsoft SQL Server, MySQL, and Oracle. Key concepts in databases include entities, attributes, primary keys, foreign keys, and one-to-many relationships used to link tables.