chapter 2 fundamental concepts

1 A database management system (DBMS) is a collection of programs that enables users to create and maintain databases and control all access to them.

2 The properties of a DBSM are:

  • It is a representation of some aspect of the real world or a collection of data elements (facts) representing real-world information.
  • A database is logical, coherent and internally consistent.
  • A database is designed, built and populated with data for a specific purpose.
  • Each data item is stored in a field.
  • A combination of fields makes up a table. For example, each field in an employee table contains data about an individual employee.

3.1 A bank has a data-base of its clients. like are they in dept or do they have any loans

3.2 A school has a data-base of the students. like are they attending classes or are their grades good

3.3 A prison has a data-base for its inmates. like how lang have they been there and what did they do