Data Base Manager System

A database is composed of several data tables related to each other by a key field.

Table: The set of rows (records) and columns (fields).

Records: A set of fields for a particular entity.

Fields: Information items contained in each record.

1. CREATE THE TABLES FOR A LIBRARY DATABASE

Tables to create:

• books
• authors
• students
• loans

Perform data entry: 20 records in books table, 10 records in the authors table, and 30 entries in the table students and 15 records in the table loans.