Sheeny Kleen is a home cleaning agency operating in Putrajaya. The business is owned by two...

 

Transcribed Image Text:

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 mumber of regular customers who requested home eleaning 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 cach date. The spreadsheet for appointments on 23 October 2021 is shown below: Appointment date: 26 October 2021 Customer Time Customer address Employee 1 Employee 2 name 09:00 - 10:00 12:00 - 13:00 13:00 - 14:00 16:00 - 17:00 Mary Munn Jen Axel Jen Axel Rony Vee Carl Ross 87, Jalan Ayer Mata 23. Jalan Makmur 1 Carl Ross Нamma Hamis 23. Jalan Makmur 1 2F, Eagle Apartment 9D, Eagle Apartment Hanna Harris Carl Ross Tom Jay Doty Lang Ron Perl 16:00 - 17:00 Hanna Harris Continued... Required: (a) Construct a relational table to store the customers' data. Create a proper primary key for the table. (4 marks) (b) Recommend two additional attributes, with justifications, that you think should be included in the customer table. (4 marks) (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 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 mumber of regular customers who requested home eleaning 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 cach date. The spreadsheet for appointments on 23 October 2021 is shown below: Appointment date: 26 October 2021 Customer Time Customer address Employee 1 Employee 2 name 09:00 - 10:00 12:00 - 13:00 13:00 - 14:00 16:00 - 17:00 Mary Munn Jen Axel Jen Axel Rony Vee Carl Ross 87, Jalan Ayer Mata 23. Jalan Makmur 1 Carl Ross Нamma Hamis 23. Jalan Makmur 1 2F, Eagle Apartment 9D, Eagle Apartment Hanna Harris Carl Ross Tom Jay Doty Lang Ron Perl 16:00 - 17:00 Hanna Harris Continued... Required: (a) Construct a relational table to store the customers' data. Create a proper primary key for the table. (4 marks) (b) Recommend two additional attributes, with justifications, that you think should be included in the customer table. (4 marks) (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

Answer rating: 100% (QA)

Question 1 Primary key of the table is CustomerNo Table design view Field Name Data Type Description CustomerNo Auto Number Primary key Customername S... View the full answer