Computer Science · Oct / Nov 2018 · Paper 2 SL · Question 3
IBCS
As printed in the paper
The question as text
3. A shop sells only fruits and vegetables. Data about the products sold is held in the relation Greengrocer as follows: GREENGROCER Prod_ID Prod_Name Prod_Price Supp_Name Supp_Contact Supp_Phone P211 Apples 5.00 Fruit and Veggie Ines Bond 542 9800 P118 Celery 11.00 Veggy Co. Mia Abiss 234 7654 P121 Onions 3.00 Fruit and Veggie Ines Bond 542 9800 P122 Onions 2.45 Veggy Co. Mike Oberst 235 7656 P219 Pears 8.50 Fruit and Veggie Kim Ng 542 9801 P220 Pears 9.00 Veggy Co. Mike Oberst 235 7656 P111 Pumpkin 6.00 Fruit and Veggie Mia Abiss 542 9802 P265 Tomatoes 7.45 New Fruits John Smith 677 7895 Prod_ID is the primary key. The relation above would be represented using the following notation: Greengrocer (Prod_ID, Prod_Name, Prod_Price, Supp_Name, Supp_Contact, Supp_Phone)
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
3(a)(i)[1]
3(a)(ii)[3]
3(b)[2]
3(c)(i)[2]
3(c)(ii)[2]
3(c)(iii)[2]
3(d)[8]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.