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 library has a file for storing details of the books it has and a file for storing details of its borrowers. The two files are linked using a common field. Book File Years 10 and 11 Borrower File How many records are there in the book file? How many fields are there in the borrower file? What type of database do these two files form? Give two reasons why this type of database system is used rather than having two flat files. Code Title Author Published Number in stock Cost 1857028898 The Code Book Simon Singh £10.99 0747591054 The Deathly Hallows J K Rowling £17.99 0748791167 Sepulchre Kate Mosse £18.99 0563371218 Full Circle Michael Palin £19.99 Number Name Form Book Borrowed Due Back Me Te Loan 11A 14/06/2010 Gurvinder Moore 10C 12/06/2010 Akhtar Aftab 10B 06/06/2010 Graham Reeves 10D 08/06/2010 For Examiner's Use Which field is the primary key in the Book file? Which field is the foreign key? Which field has the data type currency? What data type would be most appropriate for the Due Back field? Name the most appropriate validation check for the Number in stock field. Name the most appropriate validation check for the Form field.
0417_s10_qp_12
THEORY
2010
Paper 1, Variant 2
View
The Staywell Community Centre has created a new database which stores the details of each of its members. Each member can choose either swimming or tennis as an activity. The fields in the database are name, address, contact number, gender and activity. When new members arrive at the centre they need to complete a paper-based form. Design a suitable paper-based form to collect the member’s details and the activity they wish to book for. [ 1 3 Describe four changes which could be made to this paper-based form to make it into an online screen form.
0417_s17_qp_11
THEORY
2017
Paper 1, Variant 1
View
A sports club uses a computer database to keep records of members in one file and records of the sport bookings in another file. Here is a record in the sport bookings file. Sport Venue Sport code Member number Football Sports Hall SHF10 The members file and the sport bookings file will be saved as separate tables. Describe other steps which would be required in order to create a relational database. Give two advantages of creating and using a relational database compared to using two flat files. Explain why a hard disk is used to store the data files. The member number varies between 500000 and 549999. All sport codes consist of three letters followed by two numbers. Name an appropriate validation check for each of the member number and the sport code. Do not use the same check twice. Member number Sport code When members make a booking, they will show their membership card which holds their details electronically. Name the device which will be used to input their details from the card. Give two reasons why this method is better than typing the number in. When the system was implemented the systems analyst gave some documentation to the sports club owner. Name three different items found in the user documentation. Name three different items in the technical documentation which are not present in the user documentation.
0417_w14_qp_13
THEORY
2014
Paper 1, Variant 3
View
Questions Discovered
52