18.1. Create a database structure
A subsection of Information and Communication Technology, 0417, through 18. Databases
Listing 10 of 52 questions
For Examiner's Use 11 A school has a computer system for monitoring student records. It has a file for storing personal details and a file for storing test results. Here is part of the test results file. Unique ID number Name History result Geography result Maths result Me Won Li John Brown Javir Sidhu How many records are shown in the file above? How many fields are shown? Describe how the two files could be combined to form a relational database. Give two reasons why a relational database system would be used rather than having two flat files.
0417_w11_qp_12
THEORY
2011
Paper 1, Variant 2
View
For Examiner's Use 12 Chi has asked Toby, a systems analyst, to create a new database system for his property agency in France. He only deals with apartments and houses. Here are some of the questions customers ask: Have you got a house for less than €500 000? Have you got an apartment with three bedrooms? Have you got a house with more than 160 square metres floor space? Complete the design table below filling in the field names and the most appropriate data types to create a database which would answer these questions. Field name Data type Integer Price Compare and contrast parallel running and direct changeover as ways of implementing the new database system.
0417_s12_qp_13
THEORY
2012
Paper 1, Variant 3
View
Ahmed has asked Anna, a systems analyst, to create a new database system for his video rental business. He rents out films in DVD and Blu-ray formats only. Here are some of the questions customers ask: 1. Do you have the film ‘Muppets most wanted’ in Blu-ray format? 2. Do you have any films which I can rent for less than $3? 3. Do you have any films directed by Stephen Spielberg? Complete the design table below by filling in the field names and data types. Use the most appropriate data type to create a database which would answer the questions shown above. Do not use spaces in field names. Data type Field name Film_title Name_of_director Describe how Ahmed would use the finished database to produce a report, without using word processing software, to answer the second question above. 1 14
0417_s15_qp_11
THEORY
2015
Paper 1, Variant 1
View
An airline company allows customers to book flights online. Here is an example of the data a customer is asked to type in when they search for a suitable flight, together with a typical entry. There are three types of class: Economy, Business and First. LHR Departure airport DXB Arrival airport 21/9/2016 Date of departure 8/10/2016 Date of return Economy Class Number of adults Number of children Number of infants Below is an input screen designed to help this data to be entered. Departure airport Arrival airport Date of departure Date of return Class Number of adults Number of children Number of infants 1 17 Evaluate this form regarding the ease of entering data Explain why it would not be appropriate for a format check to be used on the dates as given in the example data.
0417_s16_qp_11
THEORY
2016
Paper 1, Variant 1
View
A school’s examinations officer has decided to develop a database to store pupil details and the examinations they are due to sit next summer. They are going to use a relational database. Describe the steps involved in creating the database. [ 1 2 Some of the records stored in the database are given below. Date_of_exam Examination_level Name_of_subject Examination_ID 12/04/2018 IGCSE ICT 11/06/2018 IGCSE Computer Science 01/06/2018 O Level Design and Technology 28/06/2018 O Level French Based only on the examination details above, complete the table below, stating the most appropriate data type for each field. Data type Field name Examination_ID Name_of_subject Examination_level Date_of_exam Write the search criteria to search for all examinations which will be sat after 26/06/2018, using at least one of the following operators >, >=, Apart from presence check, name and describe a suitable validation check for each of the following fields in the database, based on the data shown in part . Examination_ID Date_of_exam 1 2
0417_s17_qp_12
THEORY
2017
Paper 1, Variant 2
View
A club is setting up a database to store details of its members. Complete the data dictionary of the database, adding the most appropriate data type for each field. Data type Field name Number Membership_number Member_name Boolean Membership_fee_paid Telephone_number Expiry_date_of_membership Membership_fee_amount The club secretary wishes to find all the junior members who have paid their membership fee which would be less than $100. He searches for these members by typing in the following search criteria. Membership_fee_amount 1 1 Discuss the benefits and drawbacks of storing membership details on a computer database.
0417_s17_qp_13
THEORY
2017
Paper 1, Variant 3
View
A hospital is creating a database to store blood donors’ medical details. The fields in the database include Health_number, Date_of_birth, Gender and Blood_group. When a new blood donor wishes to give blood they need to fill in a form. Each blood donor has a unique health number which uses a 10-digit number, for example 9434765919. Blood group can be A, B, AB or O. Part of the form is shown below. Blood donor 1. What is your health number? 2. What is your date of birth? 3. What is your gender? 4. What is your blood group? M / F / / Name a suitable data type for the answers given to each of the questions in the form. For any numeric field, specify the type of number. Question 1 Question 2 Question 3 Question 4 1 13 In the Blood_group field the only data that can be entered is A, B, AB or O. Tick (✓) whether each of the following blood groups is an example of abnormal or normal data. normal (✓) abnormal (✓) Blood group AB C B AO The administrator needs a list of all the blood donors in the database with blood group A as well as in the same list all the blood donors with blood group AB. This list will only include female blood donors. To find the blood donor with the health number 9434765919 he will need to type in the following query. Health_number = 9434765919 Write a query to find all the female blood group donors with the blood group A as well as those with AB. [ 1 13 When the details of a new donor are added to the database the person’s date of birth is entered. Explain why the administrator would prefer their date of birth to be stored rather than their age. Name the most appropriate validation check for the Health_number. 1 13
0417_s20_qp_11
THEORY
2020
Paper 1, Variant 1
View
Questions Discovered
52