CCEA. GCSE ICT Higher Tier 2006/2007 1) 'Mobiles 4 Many' cannot decide between a flat-file and a relational database system to keep track of customers and their ...
Database Past Paper Questions
CCEA GCSE ICT Higher Tier 2006/2007 1) “Mobiles 4 Many” cannot decide between a flat-file and a relational database system to keep track of customers and their mobile phone orders.
(a) Explain to the company why data held in a relational database is generally more secure than in a flat file database. _________________________________________________________
(b) Relational databases help maintain data integrity and reduce data redundancy. Explain the terms data integrity and data redundancy.
Data integrity: ____________________________________________
Data redundancy: _________________________________________
2) The company have decided to use a relational database. They have created the following two tables, but cannot decide which field to use to link them together.
[pic]Examiner Only Marks Remark (i) Which of the above fields would you use to link the two tables together?
(ii) Say why you chose this field.
9 A basketball club stores information about members in a database table. A small section of the database is shown below. [pic]
(a) (i) What is the name of the key field in this database?
(ii) Why is a key fi eld necessary in a database?
(iii) Give one situation when it would be necessary to add a record to the database.
(b) What other feature of the database would be useful for presenting information?
3) Chris’s family rent houses to holidaymakers in Portrush. The following Data Capture form is used to record bookings. The family want to use a database to store details of bookings.
(a) How many fields would they need to store all the data shown?
(b) The family decide to add BookingId as a key field. What is a key field?
(c) Why should Surname not be used as a key field?
Schools are becoming more used to the use of technology. Academy High School uses technology in the school office.
(a) List one way each of the following applications would be used in a school office: (i) Database
4) A new scooter and moped rental business has opened in Newcastle. The owner creates a database to hold the information shown in the two tables below. [pic]
(a) Which field is used to link the two tables?
(b) Explain the difference between a relational and a flat file database.
Relational databases help maintain data integrity.
(c) What is data integrity?
Validation is used to ensure that data is correctly entered.
(d) List two types of validation checks.
2. ____________________________________________________ 
(e) Suggest one field that should be added to the Rental Table that would help the owner calculate the total owed by the customer.
The owner wants to set up a new table that will help keep track of staff pay details.
(f ) Complete this staff table to suggest three more fields that might help the owner do this.