(1500U40-1) Turn over. 5 © WJEC CBAC Ltd. 10. A kitchen equipment shop uses a database to record information about products and orders. Two tables with example records are shown: Product ProductID Description Model Price 108 Cooker Ultrachef 342.80 112 Dishwasher Speedclean 291.50 134 Freezer IceKing 188.80 196 Cooker MasterKitchen 405.60 Order OrderID Customer ProductID OrderDate Delivered 6291 R. Kelling 108 23 Mar 2020 True 7821 G. Hambleton 112 07 Apr 2020 False 9215 P. Yang 108 19 May 2020 False 9851 S. West 196 22 May 2020 True (a) Write an SQL command to list only the description and price for each Product record where the price is less than 300. [2] (b) Write an SQL command to list the customer and order date for all orders with a product description ‘Cooker’. [3] (c) Write an SQL command to add the following record to the Product table: A refrigerator with the model name ‘Coolstore 2000’. This has been allocated Product ID 288 and has a price of 150.60. [2] 11. A large company has many departments, each of which has different responsibilities. When a major project is carried out, employees from the departments need to work together. (a) The company currently uses a single flat file to store all details of the projects. They have discovered that the data structure has several shortcomings. Describe two disadvantages for the company of using a flat file to store its data. [4] (b) The company has decided to develop a relational database to store details of the projects. Each project will have a title and a project budget. Project teams will be made up of employees from various departments. Each time an employee joins the company they will be allocated to the department that matches their skills. An employee may be a member of more than one project team. Design a database system in third normal form for this situation. [5]