9626_w17_qp_13
A paper of Information Technology, 9626
Questions:
13
Year:
2017
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
Tick the four most accurate statements about relational databases. P Duplication of data is avoided saving storage space. Every individual mistake in the database has to be manually corrected in all tables. It is easier to produce cross-tabular reports in relational databases than with flat file databases. The only two possible relationships are one-to-one and many-to-one. It is impossible to make mistakes when entering data into a relational database. Tables can be linked using a key field. There must be at least three tables in a relational database. Primary keys are unnecessary whereas you must have them with flat file databases. Relational databases cannot store as much information as flat file databases. Referential integrity helps to prevent database users entering inconsistent data.
10. Database and file concepts  →  10.1. Creating a database
Open
2
Tick the four statements referring to the use of the internet and the World Wide Web which are true. P The internet is fully policed and safe. Information on the World Wide Web tends to be up to date. The World Wide Web has vast amounts of information. All information on the World Wide Web is unbiased. All websites are accurate. Lack of expertise in using search engines can lead to inefficient searching. It is more difficult to plagiarise information using the World Wide Web than copying out of a hard copy book. There is a danger of accessing inappropriate websites. The internet is smaller than an intranet. The World Wide Web and the internet are the same thing.
1. Data processing and information  →  1.1. Data and information
5. eSecurity  →  5.1. Personal data
Open
6
Below is part of a spreadsheet Xia has created to model his personal finances. 1 2600 3 1000 4 120 5 50 6 100 7 80 8 550 9 100 10 150 11 75 12 30 13 40 14 160 15 100 17 =SUM(A3:A15) 18 =MAX(A3:A15) 20 =A1-A17 Wages/salary Mortgage/rent Utilities Phone Satellite/TV Internet Groceries Clothing Eating out Hair/beauty Pet food Cinema Car/travel Insurance Total outgoings =VLOOKUP(A18,$A$3:$B$15,2,FALSE) Balance A B Identify the value which would appear in cell B18 explaining how you arrived at your answer. Xia is not sure whether the spreadsheet would work if some of the values were changed. Describe the test plan you would use to help Xia make sure there are no errors in his spreadsheet.
8. Spreadsheets  →  8.1. Creating a spreadsheet
8. Spreadsheets  →  8.2. Testing a spreadsheet
Open
7
Fig. 1 below shows a small extract from a school database. All students shown are in year groups 9, 10 or 11 depending on their year of birth. Each student’s year group, which is not part of the database, is shown in Fig. 2. student_ID student_name Marian Griffith Manjit Dupay Ho Chan Johan Schmidt Paul Dugarry Li Cho option _1 Geography Sociology History Geography History History option_2 Art Design Tech Spanish Art German Latin year of birth Fig. 1 Name year_group Marian Griffith Manjit Dupay Ho Chan Johan Schmidt Paul Dugarry Li Cho Fig. 2 The year_group field needs to be added to the database and will be a calculated field. Explain how you would set up the calculated year_group field. You have been asked to produce a well-formatted report showing the year 10 students studying History. The report will contain a list of these students showing only each student’s name, identity number and the total number of students involved. Explain how you would produce such a report.
10. Database and file concepts  →  10.1. Creating a database
8. Spreadsheets  →  8.3. Using a spreadsheet
17. Data Analysis and Visualisation  →  17.1. Data Analysis and Visualisation
Open