Consider supporting us on Patreon. Help us keep revisedeck free.
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 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
Questions Discovered
52