Harry runs an automobile dealership company, which has offices in three locations across Queensland. Harry decided to create an ERP system to manage the operations in three branches. ERP works with the support of a database. The data fields that exist for the table cars inside the database include stock number, car type, model number, car identification number, year, colour, description and unit price.

A. Show the table car in 3NF and identify the primary key and foreign key for the table. (5 marks)

B. Suggest any three typical business situations where referential integrity avoids data problems. (5 marks)