Study notes
No notes have been generated for this topic yet. Open the topic page online and click Generate notes first.
Past exam questions (12)
2024 · Part A · Q15(c)(ii) · p.20
Another stage in a typical analytics project is data cleaning. Name and describe two types of data errors that can be removed using data cleaning.
Marking scheme
For each type of error correctly identified 1 mark For each description: Very good description - clear understanding demonstrated 2 marks Fair description – limited understanding 1 mark
2024 · Part A · Q15(c)(i) · p.20
Suggest two possible hypotheses Alex could use her data analytics project to test.
Marking scheme
For each hypothesis: Very good explanation - clear understanding demonstrated 2 marks Fair explanation – limited understanding 1 mark
2024 · Part A · Q15(b)(iv) · p.20
Relational databases reduce the amount of data redundancy. Explain the term 'data redundancy'.
Marking scheme
Very good explanation - clear understanding demonstrated 3 marks Fair explanation – limited understanding 2 mark
2024 · Part A · Q15(b)(iii) · p.20
Explain how the design shown in Figure 7 removes the need for the on_loan field from the BOOKS table.
Marking scheme
Very good explanation - clear understanding demonstrated 3 marks Fair explanation – limited understanding 2 mark
2024 · Part A · Q15(b)(ii) · p.19
Identify and explain the use of one foreign key from the design shown in Figure 7.
Marking scheme
Foreign Key correctly identified 1 mark Very good explanation - clear understanding demonstrated 3 marks Fair explanation – limited understanding 2 mark
2024 · Part A · Q15(b)(i) · p.19
Use the information provided below to fill in the six empty cells with the correct values. • Amy borrowed How the Grinch Stole Christmas! on 1st May 2024. • Bill borrowed The Cat in the Hat on 18th May 2024. • Chloe borrowed Horton Hears a Who! 7 days ago. [Table: MEMBERS. Columns: member_id, member_name. Rows: 1, Amy; [empty], [empty]; 3, Chloe.] [Table: LOANS. Columns: member_id, book_id, date_borrowed. Rows: 3, 2, 20/05/2024; [empty], 4, 01/05/24; 2, 1, [empty].]
Marking scheme
Each correct response 1 mark
2024 · Part A · Q15(a)(iv) · p.19
Assuming all data inconsistencies are fixed, enter the names of three fields from the BOOKS table in Column B that correspond to the data types shown in Column A. [Table: Column A Data Type, Column B Field Name. Row 1: Boolean, [empty]. Row 2: String, [empty]. Row 3: Real, [empty].]
Marking scheme
Each correct response 1 mark
2022 · Part A · Q13(a)(iii) · p.12
(iii) Identify two key stakeholders and their respective roles in relation to the new system. Stakeholder 1: Role: Stakeholder 2: Role:
2022 · Part A · Q13(a)(ii) · p.12
(ii) Provide two examples of how an information system could benefit K-9 Kennels. 1. 2.
2022 · Part A · Q13(a)(i) · p.12
K-9 Kennels is a small dog boarding business whose aim is to meet the needs of dog owners who often have difficulty in finding a safe and reliable place to leave their pets. Since it was established, owners John and Mary Chewit have worked tirelessly to grow the business, and in addition to boarding it now offers a range of other services including grooming, massage and training. (a) Mary and John realise that they need an information system and have appointed the software company you work for to design and develop the system. An initial meeting has been arranged and your manager has asked you to attend. (i) What is an information system? [Blank space for answer] [Visual aid: [Image: A woman and man with several dogs in an outdoor kennel area.]]
2021 · Part A · Q12(b) · p.12
One owner can own many dogs. Explain how a foreign key could be introduced to improve the design of this database. [Visual aid: Table showing owner and dog data, with owner_id linking them]
2021 · Part A · Q12(a) · p.12
State why each of the following fields would not be good candidates for a primary key in the table shown above. dog_name: breed: