Lorilari Corp, is a logistics and transportation company. Below is a table containing data stored by...

Transcribed Image Text:

Lorilari Corp, is a logistics and transportation company. Below is a table containing data stored by the company. Vehicle registration cle number type MEN3456 Van AK01 MEN3456 Van AK01 BCC9320 Vehi Trip ID Driver ID BCC9320 Car Car MUM2304 Van AK02 AKO2 BM01 SD32342 SD32342 SD23245 SD23245 SD23424 MUM2304 Van BM02 SD23443 Date of delivery 13 July 2020 13 July 2020 13 July 2020 13 July 2020 14 July 2020 14 July 2020 Driver's name Bon Jovi Bon Jovi Ronni Vee Ronni Vee Tom Tom Dopi, Marie Time of Tracking delivery number 10:40 11:30 9:15 10:20 14:32 15:21 AW4245 AW4323 AM2354 AT9423 AT4923 AM4325 Recipient's name Mickey Johnny Donald Mary Popeye Minnie Recipient's address Ayer Keroh Heights Taman Mudzaffar Cheng Perdana Paya tumput Banda Hili Banda Kaba Required: (a) Create relational tables that solve the update, insert, and delete anomalies in the table below. (b) Recommend three other data that Lorilari Corp should collect about their drivers. (c) Recommend three other data that Lorolari Corp should collect about Lorilari Corp, is a logistics and transportation company. Below is a table containing data stored by the company. Vehicle registration cle number type MEN3456 Van AK01 MEN3456 Van AK01 BCC9320 Vehi Trip ID Driver ID BCC9320 Car Car MUM2304 Van AK02 AKO2 BM01 SD32342 SD32342 SD23245 SD23245 SD23424 MUM2304 Van BM02 SD23443 Date of delivery 13 July 2020 13 July 2020 13 July 2020 13 July 2020 14 July 2020 14 July 2020 Driver's name Bon Jovi Bon Jovi Ronni Vee Ronni Vee Tom Tom Dopi, Marie Time of Tracking delivery number 10:40 11:30 9:15 10:20 14:32 15:21 AW4245 AW4323 AM2354 AT9423 AT4923 AM4325 Recipient's name Mickey Johnny Donald Mary Popeye Minnie Recipient's address Ayer Keroh Heights Taman Mudzaffar Cheng Perdana Paya tumput Banda Hili Banda Kaba Required: (a) Create relational tables that solve the update, insert, and delete anomalies in the table below. (b) Recommend three other data that Lorilari Corp should collect about their drivers. (c) Recommend three other data that Lorolari Corp should collect about

Answer rating: 100% (QA)

ChatGPT To address the update insert and delete anomalies in the table provided we can normalize the data into separate relational tables Normalizatio... View the full answer