10.1. Creating a database
A subsection of Information Technology, 9626, through 10. Database and file concepts
Listing 10 of 49 questions
Louisa, a teacher with limited IT knowledge, has created a simple database of her students. The database contains the names of her students and the results of their latest test. She prints out the names of the students who have passed the latest test by gaining a mark of 40 or more. When she created the database, she considered creating a dynamic parameter query to produce her printout. However, she decided to create a static parameter query. Explain why this was a good decision.
9626_w23_qp_12
THEORY
2023
Paper 1, Variant 2
View
A car salesroom has a relational database which stores details of the cars and the customers who have purchased a car. The manager uses it to search for information about the cars and the customers. She also produces reports based on these searches. Tables Queries Forms Customers second names beginning with Customers Reports All cars in stock Price less than $20000 Price of car She wants to have an easier way of accessing the queries, forms and reports. Design a switchboard for her which will allow her to go to any of the reports, forms or queries already set up as shown in the image above. Referring to any four interactive items on your switchboard explain what will happen if they are selected. Item 1 Item 2 Item 3 Item 4 Below is a diagram showing the tables in the database. Cars Car–Code Make Model Price Orders ID Order–No Customer–code Car–Code Customers Customer–code First Name Second Name Address–1 Address–1 The car salesroom manager wanted a list of cars made by Frod as well as, in the same list, any cars ordered by customers whose second name begins with B. The printout shows the makes and models of cars, first and second customer names who have ordered them and the order number. Make Model First Name Second Name Order_No Frod Deomon Alan Sutton Frod Deomon Bruce Silversmith Frod Deomon Johann Schmidt Frod Deomon Brian Biggins Olap Azum George Babak Yatoya Yangtse Kulvir Bains
9626_s18_qp_12
THEORY
2018
Paper 1, Variant 2
View
Joanne owns a store which sells films as DVD and blu-ray discs. Each disc has a six-character code number and each customer has an eight-character customer number. She has developed a database system which contains information about the films. Each record contains the following data: Film title, director, code_number, DVD (Y/N), date_of_sale, customer_number. Describe the features of an appropriate online data entry form for one film which would, where appropriate, allow the user to enter data by clicking the mouse rather than entering text. Do not draw the screen and data entry form in your description.
9626_s20_qp_13
THEORY
2020
Paper 1, Variant 3
View
Questions Discovered
49