TMA MT264 04 Cut-off date 7 May 2013 The questions below, on Block 4, form tutor-marked assignment MT264 04. Your overall grade will be based on the sum of your marks for all these questions. Note that you should submit your answers to all the questions of TMA 04 to the eTMA system together. Your attention is drawn to the following University rule: ‘So that scores can be recorded and documentation prepared at the end of each module, no extension to the cut-off date will normally be allowed for a module’s final assignment.’ Question 1 (20 marks) This question is based on Unit 10. It assesses your progress towards achieving the following module learning outcome: I After studying the module you should be able to use a commercial IDE, use simple graphical tools in applications, and access simple databases from applications. An existing database records details of chocolate items and chocolate suppliers for a chocolate shop. The database contains two tables, Supplier and Chocolate. Supplier gives basic details of chocolate suppliers used. Chocolate gives details of chocolate items in the current stock. The fields and primary keys are as follows. Supplier has fields SuppCode, Name, and Address. The primary key consists of the first field. Chocolate has fields ChocCode, SuppCode, Name and Stock. The primary key consists of the first field. SuppCode is a foreign key in Chocolate. Supplier SuppCode Name Address H1 HandMadeChocs Derby M1 MassChocs Slough B1 BelgianChocs Brussels S1 SpecialistChocs Durness Chocolate ChocCode SuppCode Name Stock DarkBox H1 Special dark assortment 10 MilkBox M1 Milk selection 20 Shells B1 Shell chocolates 5 DarkBar1 H1 Mint chocolate bar 20 DarkBar2 H1 Orange chocolate bar 10 NutBox S1 Dark nut chocolates 5 CandyBar1 M1 Toffee chocolate bar 30 (a) The field SuppCode is shared by the two tables (it is a foreign key in Chocolate). Using this fact and the sample data shown above, or otherwise, illustrate why the relationship between the two tables…