Exam code: 9618
The company is using a Database Management System (DBMS) to set up the database.
Describe what is meant by the following DBMS features:
Data dictionary ......................................................................................................
Logical schema .......................................................................................................
How did you do?
Was this exam question helpful?
A shipping company stores its data in a relational database. The database is created and managed using a Database Management System (DBMS).
One of the features provided by the DBMS is data security.
State two ways in which the DBMS provides data security.
How did you do?
Was this exam question helpful?
A college stores information about its students in a relational database. Part of the table STUDENT is shown with some sample data.
StudentID | FamilyName | DateOfBirth |
|---|---|---|
S1041 | Okonkwo | 02/09/2008 |
S1042 | Haddad | 17/01/2009 |
The Database Management System (DBMS) maintains a data dictionary for this database.
Complete the table by giving three different items of data that the data dictionary stores about the field FamilyName.
Number | Item of data the data dictionary stores about the field FamilyName |
|---|---|
1 | |
2 | |
3 |
How did you do?
Was this exam question helpful?
A chain of language schools operates in six countries. The chain asks a designer to produce one new database that all six countries will use.
Before any tables are created, the designer produces a logical schema for the database.
Explain why the designer produces a logical schema before the database is built.
How did you do?
Was this exam question helpful?
A Database Management System (DBMS) contains a software tool called the query processor.
State the purpose of the query processor.
How did you do?
Was this exam question helpful?
A travel company uses a Database Management System (DBMS) to hold data about its bookings.
A member of staff at the company uses the developer interface of the DBMS.
Describe three tasks that the member of staff can carry out using the developer interface.
How did you do?
Was this exam question helpful?
An online bookshop uses a Database Management System (DBMS).
Two members of staff work with the database on the same day.
Anika is a database developer. She needs to add a new table to the database and build a screen that other staff will use to type in new stock.
Ben works in the warehouse. He needs a list of every order that was placed in March.
For each member of staff, identify the DBMS software tool they use and explain why that tool is the correct one.
How did you do?
Was this exam question helpful?