8.2 Database Management Systems (DBMS)

2 of 2 objectives have lessons · 0 studied · 0 secure

Lessons

Why file-based data storage breaks downStoring data in separate files works until the same student, customer or product appears in several of them. Then the copies drift apart, and a DBMS is the fix. 8 min, not started
The tools inside a DBMSA DBMS is not just storage. It ships with tools for designing tables, writing queries, building data-entry screens and reports, setting permissions and taking backups. 8 min, not started

Syllabus objectives

2 objectives

What Cambridge says you should be able to do, in our words. Codes are the topic number plus the objective’s position.

8.2.1

Understand the features provided by a Database Management System (DBMS) that address the issues of a file-based approach.

Including: data management, including maintaining a data dictionary; data modelling; logical schema; data integrity; data security, including backup procedures and the use of access rights for individuals / groups of users.

Taught in: Why file-based data storage breaks down · 6 questions

8.2.2

Understand how the software tools found within a DBMS are used in practice.

Including the use and purpose of the developer interface and the query processor.

Taught in: The tools inside a DBMS · 6 questions