18. Databases
A section of Information and Communication Technology, 0417
Listing 10 of 59 questions
The 2020 Olympic Games committee is producing a database to show the medal winners in the cycling events. It is important that the correct data type is used in each of the fields. Tick (✓) the most appropriate data type for each of the following fields. Text (✓) Numeric (✓) Boolean (✓) Athlete_name Gold_medal (Y/N) Age Name_of_country 1 15 A report has been produced that shows the male gold medal winners from the past three Olympic Games. Write down six of the formatting features that have been used in the report. [ 1 15
0417_s20_qp_12
THEORY
2020
Paper 1, Variant 2
View
The secretary of the Tawara Rowing Club is organising a presentation evening for its members. A systems analyst is creating a database for the club to store the details of the members. She is also creating a spreadsheet to show who is attending the presentation evening. The systems analyst has set up the following fields for the database. Gender Year _joined Contact_phone_no Contact_email Membership _type Date_of_birth Name_of_person F 03 2453 5673 n.kwa@rockict.com Social 2/4/2005 Nor Kwa M 082 25 4689 AdamM@abc.co.my Social 23/5/2003 Adam Mazian M 01223 432678 AOthman@cie.org Junior 12/03/2006 Ahmed Othman F 123 3267 9999 Zara@cbc.cn Senior 1/12/1997 Zara Png For the following fields write down the most appropriate data type. Each data type must be different. For any numeric field, specify the type of number. Gender Membership_type Year_joined 1 13 Design an online data entry form which could be used to enter the details of one member, using all the fields shown in the table. In your design include appropriate spacing for each field and navigational aids. Do not include data in the form. [ 1 13 A spreadsheet has been created to show which members are attending the presentation evening and who has paid. Part of the spreadsheet is shown. K J I H G F E D C B A Tawara Rowing Club $ Cost Paid Total owed Number attending Attending Type of member Full name Family name Name Junior Y Y Social Nor Kwa Kwa Nor Senior Y Y Junior Ahmed Othman Othman Ahmed Social N Y Senior Zara Png Png Zara N N Social Adam Mazian Mazian Adam Write down three of the formatting features that have been used in the part of the spreadsheet shown. 1 13 A formula has been created and placed in cell G3. The formula is: IF(E3=''Y'',VLOOKUP(D3,J$3:K$5,2)*F3,0) Explain what the formula does. The secretary needs to identify different types of members in the club. Describe the steps he would take to sort the data by type of member so that Junior members are at the top of the list. [ 1 13
0417_s20_qp_13
THEORY
2020
Paper 1, Variant 3
View
Aimi works for a shop that sells toys. She is setting up a relational database of the stock in the shop. She has started designing the database. Aimi has written down the questions that are asked about each toy and needs to produce appropriate field names from them. An example of the type of data that is to be stored is shown. What is the toy? Tawara Doll Who manufactured the toy? Tinky What year was it manufactured? 2020 What price was it bought for? $12.99 Complete the design table below by filling in an appropriate field name for each question. Each field name must be different. Field names must not include spaces. Field name Question What is the toy? Who manufactured the toy? What year was it manufactured? What price was it bought for? [ 1 7 When Aimi created the whole database one of the fields was set as integer. However, as data is entered Aimi realises that the field should have been set to two decimal places. Describe the steps that need to be taken, by Aimi, to change the field from an integer to a decimal. This field will be set to two decimal places. Aimi created a relational database but could have created a flat file database. Discuss the advantages and disadvantages of using a relational database rather than a flat file database. 1 7
0417_s21_qp_13
THEORY
2021
Paper 1, Variant 3
View
For Examiner's Use 14 Mario has asked Louise, a systems analyst, to create a new database system for keeping records of books he sells in his bookshop. Louise will collect information about the existing system. Describe three methods she would use to do this. After collecting information, Louise noticed that Mario sells both non-fiction and fiction books in hardback and paperback. She also discovered that no books cost more than $20. She wrote down some of the questions that customers ask, such as: Have you got any non-fiction books by Arthur C Clarke? Have you got the hardback version of ‘Harry Potter and the Philosopher’s Stone’? Have you got any books for less than $10? Complete the design table below filling in the field names and most appropriate validation checks to create a database which would answer these questions. Field name Validation Check none none Price For Examiner's Use Identify three items of test data which could be used with the Price field giving reasons for your choice. Item 1 Reason Item 2 Reason Item 3 Reason
0417_w12_qp_11
THEORY
2012
Paper 1, Variant 1
View
For Examiner's Use 13 Anya has employed Raymond, a systems analyst, to create a new database system for sports day at her school. Here are some of the questions teachers and students might ask about the results of the athletics competition: What position did Peter Njoka come in the 100 metres? Who won the 1500 metres? The winner of the 800 metres was wearing which Race ID? Each athlete wore a Race ID consisting of one letter followed by three digits. The longest race is the 1500 metres. Complete the design table below filling in the field names and the most appropriate data types to create a database which would answer these questions. Field name Data type Race_ID Name and describe the most appropriate validation check which would be carried out on the Race_ID field. Name Description For Examiner's Use Anya wants to have a system which will make it easy to enter data. Describe five features of a well designed input screen.
0417_w12_qp_13
THEORY
2012
Paper 1, Variant 3
View
For Examiner's Use 13 Abdul owns a large factory. He has asked Imran, a systems analyst, to create a new database system for keeping records of his workers and their pay. Imran will collect information about the existing system. Identify three methods he would use to do this. After collecting information, Imran found that each worker has an ID which consists of one letter followed by five digits. He also found that no worker earns more than $500. He wrote down two of the questions that Abdul might ask when using the database, such as: What is the phone number of the worker whose ID is L67123? How much does Sunil Kapoor earn? Complete the data dictionary table below giving the field names which would be used in the database in order to answer these questions. State the data types which would be used for each field. Field name Data type First_name Text Phone_number Worker_ID For Examiner's Use Identify three items of test data which could be used to test the Worker_ID field, giving a reason for each choice. Item 1 Reason Item 2 Reason Item 3 Reason
0417_w13_qp_12
THEORY
2013
Paper 1, Variant 2
View
Questions Discovered
59