Database Past Paper Questions
Database Past Paper Questions
[pic]
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.
_________________________________________________________
______________________________________________________ [2]
(b) Relational databases help maintain data integrity and reduce data redundancy. Explain the terms data integrity and data redundancy.
Data integrity: ____________________________________________
______________________________________________________ [1]
Data redundancy: _________________________________________
______________________________________________________ [1]
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?
___________________________________________________ [1]
(ii) Say why you chose this field.
______________________________________________________
___________________________________________________ [1]
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?
___________________________________________________ [1]
(ii) Why is a key fi eld necessary in a database?
______________________________________________________
___________________________________________________ [1]
(iii) Give one situation when it would be necessary to add a record to the database.
___________________________________________________ [1]
(b) What other feature of the database would be useful for presenting information?
______________________________________________________ [1]
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.
[pic]
(a) How many fields would they need to store all the data shown?
_______________________________________________________ [1]
(b) The family decide to add BookingId as a key field. What is a key field?
__________________________________________________________
_______________________________________________________ [2]
(c) Why should Surname not be used as a key field?
__________________________________________________________
_______________________________________________________ [2]
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
____________________________________________________ [1]
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?
______________________________________________________ [1]
(b) Explain the difference between a relational and a flat file database.
_________________________________________________________
_________________________________________________________
______________________________________________________ [3]
Relational databases help maintain data integrity.
(c) What is data integrity?
_________________________________________________________
______________________________________________________ [2]
Validation is used to ensure that data is correctly entered.
(d) List two types of validation checks.
1. _______________________________________________________
2. ____________________________________________________ [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.
______________________________________________________ [1]
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.
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- past paper annual year 6
- mathematics past paper 2018
- mathematics past paper 2018 pdf
- grade 10 past paper 2017
- cxc geography past paper 2018
- past paper form four necta
- csec spanish past paper 2018
- maths past paper 2019 january
- math past paper pdf download
- past paper 12 class english
- cambridge primary checkpoint past paper pdf
- physics past paper 2