10. Database and file concepts
A section of Information Technology, 9626
Listing 10 of 87 questions
Below is an excerpt from a database showing some holiday bookings. Egypt Malaysia Thailand Costa Rica Sri Lanka Bahamas Indonesia Indonesia Costa Rica Egypt Sri Lanka Egypt Thailand Costa Rica Costa Rica Indonesia Malaysia Thailand Sri Lanka Thailand Egypt Malaysia Indonesia Malaysia Bahamas Costa Rica Thailand Sri Lanka Thailand Thailand Egypt Egypt Country Group size Code Discount Duration EGY MAL THA COZ SRI BAH IND IND COZ EGY SRI EGY THA COZ COZ IND MAL THA SRI THA EGY MAL IND MAL BAH COZ THA SRI THA THA EGY EGY Describe the steps that need to be followed to set up a dynamic query to allow you to search on the Group size and Code fields. All fields are to be printed except Discount. You run the query and type in the Group size as 4 and the Code as EGY. Write down the Durations that will be printed out. The Duration field has only the values shown in the database excerpt. The database needs to be set up to allow you to enter the data in this field without using the keyboard to type in the value each time. Describe how this would be done and explain how you would now enter the data. When the database was initially set up it did not have the Country field. Data was exported to a spreadsheet and a formula created, using the Code field, to add the names of the countries with the layout exactly as shown in the database excerpt. Without specifying the formula precisely, explain how this could be achieved.
9626_s18_qp_11
THEORY
2018
Paper 1, Variant 1
View
Fig. 1 below shows a small extract from a school database. All students shown are in year groups 9, 10 or 11 depending on their year of birth. Each student’s year group, which is not part of the database, is shown in Fig. 2. student_ID student_name Marian Griffith Manjit Dupay Ho Chan Johan Schmidt Paul Dugarry Li Cho option _1 Geography Sociology History Geography History History option_2 Art Design Tech Spanish Art German Latin year of birth Fig. 1 Name year_group Marian Griffith Manjit Dupay Ho Chan Johan Schmidt Paul Dugarry Li Cho Fig. 2 The year_group field needs to be added to the database and will be a calculated field. Explain how you would set up the calculated year_group field. You have been asked to produce a well-formatted report showing the year 10 students studying History. The report will contain a list of these students showing only each student’s name, identity number and the total number of students involved. Explain how you would produce such a report.
9626_w17_qp_13
THEORY
2017
Paper 1, Variant 3
View
Questions Discovered
87