Please answer in Word format. TQ

QUESTION 2 Sheeny Kleen is a home cleaning agency operating in Putrajaya. The business is owned by two best friends, Jack and Jill. Most of the cleaners hired by the business are part-time workers, who are available on specific days and time only. Sheeny Kleen has quite a number of regular customers who requested home cleaning services on a weekly basis. The numbers of cleaners assigned for each appointment depends on the customer's request. Customers are charged RM80 per hour per employee At the moment, Sheeny Kleen keeps all cleaning appointment data in spreadsheets. Separate spreadsheets are created to record the appointments on each date. The spreadsheet for appointments on 23 October 2021 is shown below: Time 09:00 - 10:00 12:00 - 13:00 13:00 - 14:00 16:00 - 17:00 16:00 - 17:00 Appointment date: 26 October 2021 Customer Customer address Employee 1 name Mary Munn 87, Jalan Ayer Mata Carl Ross Jen Axel 23, Jalan Makmur 1 Hanna Harris Jen Axel 23. Jalan Makmur 1 Hanna Harris Tom Jay 2F. Eagle Apartment Ron Perl Doty Lang 9D. Eagle Apartment Hanna Harris Employee 2 Rony Vec Carl Ross Carl Ross Continued... Required: (a) Construct a relational table to store the customers' data. Create a proper primary key for the table. (4 marks) (6) Recommend two additional attributes, with justifications, that you think should be included in the customer table. (4 marks) a (e) Hanna Harris, Rony Vee and Ron Perl are part-time cleaners. The others are hired by the business on a permanent basis. Create a table to store the employees' data, with a suitable primary key for the table. (3 marks) (d) Construct a cleaning appointment table to store all appointment data shown in the spreadsheet above. Identify the appropriate primary key for the table. (8 marks) (6) Data integration, task-data independence, data sharing, minimal data redundancy, and ability for cross functional data analysis are the advantages of database systems. Explain how a database system will assist Sheeny Kleen in enhancing its operational efficiency. (6 marks) (Total: 25 marks) QUESTION 2 Sheeny Kleen is a home cleaning agency operating in Putrajaya. The business is owned by two best friends, Jack and Jill. Most of the cleaners hired by the business are part-time workers, who are available on specific days and time only. Sheeny Kleen has quite a number of regular customers who requested home cleaning services on a weekly basis. The numbers of cleaners assigned for each appointment depends on the customer's request. Customers are charged RM80 per hour per employee At the moment, Sheeny Kleen keeps all cleaning appointment data in spreadsheets. Separate spreadsheets are created to record the appointments on each date. The spreadsheet for appointments on 23 October 2021 is shown below: Time 09:00 - 10:00 12:00 - 13:00 13:00 - 14:00 16:00 - 17:00 16:00 - 17:00 Appointment date: 26 October 2021 Customer Customer address Employee 1 name Mary Munn 87, Jalan Ayer Mata Carl Ross Jen Axel 23, Jalan Makmur 1 Hanna Harris Jen Axel 23. Jalan Makmur 1 Hanna Harris Tom Jay 2F. Eagle Apartment Ron Perl Doty Lang 9D. Eagle Apartment Hanna Harris Employee 2 Rony Vec Carl Ross Carl Ross Continued... Required: (a) Construct a relational table to store the customers' data. Create a proper primary key for the table. (4 marks) (6) Recommend two additional attributes, with justifications, that you think should be included in the customer table. (4 marks) a (e) Hanna Harris, Rony Vee and Ron Perl are part-time cleaners. The others are hired by the business on a permanent basis. Create a table to store the employees' data, with a suitable primary key for the table. (3 marks) (d) Construct a cleaning appointment table to store all appointment data shown in the spreadsheet above. Identify the appropriate primary key for the table. (8 marks) (6) Data integration, task-data independence, data sharing, minimal data redundancy, and ability for cross functional data analysis are the advantages of database systems. Explain how a database system will assist Sheeny Kleen in enhancing its operational efficiency. (6 marks) (Total: 25 marks)