Here is a table of data about individuals and their families which is being converted into a database. Family_name First_name C D E F Gustoffsson Gunnar 18/05/1957 M Divorced Sandhu Jasvinder 09/08/1988 F Single Otieno Peter 27/12/2001 M Single Qabbani Nizar 01/01/1990 M Married Wanjeku Jane 22/05/1994 F Married Garcia Francesca 12/11/1986 F Married Potter James 17/10/1992 M Married Suggest suitable field names for C, D, E and F. For each field, state an appropriate data type and give a reason for your choice. For each field, state, with a reason, the number of bytes the database would need to allocate for the data to be stored. C D E F

9626_s17_qp_11

THEORY

2017

Paper 1, Variant 1

View

Imran has developed a simple library database system which contains information about the books. Each record contains the following data: Book title, author, ISBN, borrowed (Y/N), date borrowed, borrower number. Design an appropriate online data entry form for one book, clearly indicating the amount of space required for each field. Your design must represent a computer screen and, where appropriate, allow the user to enter data by clicking the mouse rather than entering text.

9626_s17_qp_11

THEORY

2017

Paper 1, Variant 1

View

Here is a table of data about individuals and their families which is being converted into a database. Family_name First_name C D E F Gustoffsson Gunnar 18/05/1957 M Divorced Sandhu Jasvinder 09/08/1988 F Single Otieno Peter 27/12/2001 M Single Qabbani Nizar 01/01/1990 M Married Wanjeku Jane 22/05/1994 F Married Garcia Francesca 12/11/1986 F Married Potter James 17/10/1992 M Married Suggest suitable field names for C, D, E and F. For each field, state an appropriate data type and give a reason for your choice. For each field, state, with a reason, the number of bytes the database would need to allocate for the data to be stored. C D E F

9626_s17_qp_12

THEORY

2017

Paper 1, Variant 2

View

Imran has developed a simple library database system which contains information about the books. Each record contains the following data: Book title, author, ISBN, borrowed (Y/N), date borrowed, borrower number. Design an appropriate online data entry form for one book, clearly indicating the amount of space required for each field. Your design must represent a computer screen and, where appropriate, allow the user to enter data by clicking the mouse rather than entering text.

9626_s17_qp_12

THEORY

2017

Paper 1, Variant 2

View

A large school is creating a relational database to store details of pupils and teachers. Examples of the data to be stored are shown: Pupils: Orlando Albert Sockett Teachers: Christopher Wallace Born: 22 October 1999 Based in Room 27 Studies: English, Mathematics, Science Teaches English Using the information given, create a data dictionary in the table to list the entities and attributes of the new database: Entity Attribute Data type Field size

9626_s18_qp_31

THEORY

2018

Paper 3, Variant 1

View

Kelvin was given the task of creating a relational database to combine all his company’s customer records and sales records . The tables that were created are shown here. Customer table M3764A N3201B N5789A L2345A Q4012A L3896C M4698B M2589D M4013B P4352D P3156C Burke Charles Floyd Hall Jones Li Norfolk Rhodes Sun Wu Watson Williams Linda Lauren Joe John Laura Kurtis Kate Lotte Li Karla Joanne €1,980 €2,650 €1,850 €2,700 €3,400 €2,130 €1,250 €3,400 €2,240 €2,130 €1,870 Customer_id Family_name First_name Credit_limit Loyalty_number Invoices table €12.45 €17.30 €38.50 €152.20 €38.20 €17.50 P4352D N5789A M4698B L3896C N3201B M2589D Invoice_number Number_of_items Item_cost Customer_ref Delivered You can assume that all values shown include the maximum and minimum allowed in each field. Complete the data dictionary below for the Invoices table. You can assume that all values shown are typical. All field sizes should be appropriate. Attribute Data type Field size Format Type of key Kelvin wishes to add a calculated field showing the total cost for each customer. Describe the steps he would need to follow in order to create this calculated field using a query without using a wizard. The following data was typed in error. For each item explain how validation could have prevented the error and explain what would be allowed. 321789 in the Invoice_number field. 12500 in the Credit_limit field. L21789 in the Customer_id field. 679814325678 in the Loyalty_number field for John Hall.

9626_w19_qp_12

THEORY

2019

Paper 1, Variant 2

View

Select the most appropriate data type for each of the following examples, giving a reason why alternative data types would not be suitable. If the data type is numeric, specify the type of numeric data that would be most appropriate and give a reason. The reasons must be different for each example. A phone number, such as 028 9649 6437 A number used to show the fraction of students who like IT, such as 0.125. The number of children in a family, such as 4. A person’s state of employment, such as employed or not employed. The amount of money a person earns, such as $100.50.

9626_w20_qp_12

THEORY

2020

Paper 1, Variant 2

View

A furniture company uses databases in its warehouse to help with stock control. The company has a Product database which contains the fields shown in the table. Field Name Data Type Example of Data Number_in_Stock 199 (Number_in_Stock can vary between a minimum of 0 and a maximum of 250.) Location 07.44.03 Reorder_Level Price $203.50 Supplier_Telephone_No. Complete the Data Type column in the table by writing the most appropriate data type for each field. For any numeric fields, specify the numeric data type. State and describe appropriate validation checks that could be carried out on data as it is entered into the Product database. You can describe different validation checks for the same field. As well as the Product database, the company has a Customer database. Describe how the two databases can be combined into one relational database.

9626_w24_qp_12

THEORY

2024

Paper 1, Variant 2

View

Below are two tables from a college database. A relationship links the two tables. Studentid F1278 F3794 F4921 F9153 Phone First_name Ravinder Avtar Shokat Ravinder Coursecode P301 F402 B115 B115 Coursecode Courses Students P301 E402 B115 M301 Course_Title Physics English Biology Maths Explain which fields would be set for primary keys, a compound key and a foreign key, giving reasons for each choice. A list is required of all the students studying Biology. Write down the steps you would need to take to produce this list using the Students table only. You may assume the database is already open.

9626_m18_qp_12

THEORY

2018

Paper 1, Variant 2

View

The manager of a small shop is creating a new relational database that will store details of the goods sold by the shop. It will also store details of the suppliers of these goods. The manager collects the details that are shown on the labels attached to the goods. He gathers the details of the suppliers from a notebook that he keeps. Five examples of labels are shown: Item Quantity/pkt Price Sell by date Rice 5 ½ kg sack 440 cents 07 June 2029 Item Quantity in pkt Price Sell by date Cost per 1000 g Beans 100 g tin $2 N/A $20 Item Quantity in pkt Price Sell by date Sugar 2 kg bag $3 March 2020 Item Quantity/pkt Price Sell by date Flour 2 kg sack $3 Dec 2019 Item Amount in pkt Price Cost per 1000 g Sell by date Soya 1000 g bag $5.46 $5.46 20 Nov 2019 The shop can obtain all of its goods from any of these four suppliers: Shop Suppliers Inc PO Box 2300 Pennsylvania Av Washington DC Sugar Suppliers plc Bury St Edmunds Suffolk IP66 7ES General Shop Wholesalers 2500 Newmarket Rd Cambridge CB6 5PE United Kingdom Cash & Carry Goods 65a Board View Milford Haven Dyfed UK SA85 2NX

9626_m19_qp_32

THEORY

2019

Paper 3, Variant 2

View

---