The table below presents data of clients and cars. Each client may rent a car from...

 

Transcribed Image Text:

The table below presents data of clients and cars. Each client may rent a car from different branches throughout Ontario. The car is registered at a particular branch and can rented by any client on a given date. [Total: 100 Marks] CAR NO WD1023 PE9930 SS3923 PE9930 SS9110 JH3023 MAKE Proton Toyota Honda Toyota Proton Perodua MODEL Persona Yaris City Yaris Preve Myvi CUST_ID C5001 C5004 C5006 C5004 C5010 C5004 CUST_NAME Liam S. William Noah A. Lucas Emma J. Henry Noah A. Lucas Elijah L. James Noah A. Lucas CUST_EMAIL Isw@xyz.com nal@xyz.com ejh@xyz.com nal@xyz.com elj@xyz.com nal@xyz.com HIRE_DATE BRANCH_ID 11/11/2022 18/11/2022 20/11/2022 24/11/2022 30/11/2022 02/12/2022 110 111 112 111 114 110 BRANCH_LOC Toronto Mississauga Brampton Mississauga Oakville Toronto Answer the following sub-questions: 1) The data in the table is susceptible to update anomalies. Explain how insertion, deletion, and modification anomalies could occur on this table by providing examples. [15 Marks] Answer Isto t The table below presents data of clients and cars. Each client may rent a car from different branches throughout Ontario. The car is registered at a particular branch and can rented by any client on a given date. [Total: 100 Marks] CAR NO WD1023 PE9930 SS3923 PE9930 SS9110 JH3023 MAKE Proton Toyota Honda Toyota Proton Perodua MODEL Persona Yaris City Yaris Preve Myvi CUST_ID C5001 C5004 C5006 C5004 C5010 C5004 CUST_NAME Liam S. William Noah A. Lucas Emma J. Henry Noah A. Lucas Elijah L. James Noah A. Lucas CUST_EMAIL Isw@xyz.com nal@xyz.com ejh@xyz.com nal@xyz.com elj@xyz.com nal@xyz.com HIRE_DATE BRANCH_ID 11/11/2022 18/11/2022 20/11/2022 24/11/2022 30/11/2022 02/12/2022 110 111 112 111 114 110 BRANCH_LOC Toronto Mississauga Brampton Mississauga Oakville Toronto Answer the following sub-questions: 1) The data in the table is susceptible to update anomalies. Explain how insertion, deletion, and modification anomalies could occur on this table by providing examples. [15 Marks] Answer Isto t