18. Databases
A section of Information and Communication Technology, 0417
Listing 10 of 59 questions
For Examiner's Use There is a public library in New York. The librarian uses a computer to keep records of borrowers as well as records of the books in the library. The borrower file is stored on a hard disc. State the type of access needed to retrieve a single record quickly. When a borrower comes in for a book they show their membership card. Give a method of data input which could be used instead of typing in the borrower’s membership number. Give two reasons why your method in is better than typing in the membership number. Describe how the librarian could create a relational database using the data already held in the borrower file and the book file.
0417_w13_qp_12
THEORY
2013
Paper 1, Variant 2
View
The manager of a computer shop uses a database to store data about the computers he sells. This is part of the database. Makers_name Computer_ type Processor_type RAM (Gb) Hard disk (Tb) Never-never Laptop G4000 0.5 Johnsang PC L5000 1.0 Rany PC E3000 1.0 Hello-John PC F3500 2.0 Never-never PC A1000 1.0 Johnsang Laptop C2000 0.5 Hello-John Laptop D2500 1.0 Rany Laptop B1500 0.5 Write down the number of records shown in this part of the database. Write down the number of fields shown in this part of the database. The records shown are to be sorted in ascending order of Makers_name then ascending order of Processor_type. Give the Processor_type of the last record in the database after it has been sorted. Give the field that could be amended to contain Boolean data. Name and describe the most appropriate validation check other than a length check which would be carried out on the Processor_type field. Data in RAM is accessed more quickly than from a fixed hard disk. Give two reasons why fixed hard disks are still necessary.
0417_w15_qp_11
THEORY
2015
Paper 1, Variant 1
View
A computer system is being created to calculate the scores in a diving competition. Every dive by an athlete is awarded a score out of 10 by each judge. The system is being tested using live data. An athlete completes his dive with a difficulty of 3.4 and achieves the following scores, which are displayed in a spreadsheet. Before the overall score is calculated the judges’ scores need to be sorted into ascending order. Describe the steps that would be carried out to sort the data into ascending order. 1 10 Cell B12 contains the formula, ROUND((SUM(B5:B9)*D1),1). Explain what the formula in cell B12 does. The judges’ score column will be tested using normal, abnormal and extreme data. Explain, giving examples of test data which would be used, what is meant by: Abnormal test data Extreme test data [ 1 10
0417_m21_qp_12
THEORY
2021
Paper 1, Variant 2
View
Questions Discovered
59