8.2 Database Management Systems (DBMS) (3)

Resources | Revision Questions | Computer Science

Login to see all questions

Click on a question to view the answer

1.

Describe the limitations of a file-based approach to data management. Then, explain how a Database Management System (DBMS) addresses these limitations, specifically highlighting the benefits of data integrity and data consistency.

2.

Explain the purpose of a relational model in a DBMS. Illustrate your answer using a simple example of a database for a library, including the tables involved and the relationships between them. Show how the relational model helps to avoid data redundancy.

3.

Compare and contrast the advantages and disadvantages of using an hierarchical database model and a network database model in a DBMS. How do these models differ from the more flexible relational model?