Q1. Design a blank database 'RESOURCES' with the following tables: (i) STAFF AND (ii) DIVISION. Add the following fields in the table ‘STAFF': STAFF_ID, STAFF_NAME, STAFF_AGE, STAFF_ADDRESS and DIVISION_ID. Add 15 records in the table 'AUTHORS'.
- The 'RESOURCES' database is created as the primary data container.
- The 'DIVISION' table is designed with `DIVISION_ID` as its auto-incrementing primary key.
- The 'STAFF' table includes `STAFF_ID` (primary key), `NAME`, `AGE`, `ADDRESS`, and `DIVISION_ID`.
- `DIVISION_ID` in 'STAFF' serves as a foreign key, referencing the 'DIVISION' table.
Answer: Information systems, as studied in MLI-003, are pivotal for efficient management and retrieval of data within any organization, including libraries and information centers. A relational database system offers a structured approach to store and organize vast amounts of interconnected information, ensuring data integrity and accessibility. Designing a database involves defining its schema, including tables, fields, and relationships, using Data Definition Language (DDL) commands. For this exerci...