A specialty cake bakery uses a legacy flat file system to store all of its information. The owner of the company, Mavis Baker, wants to implement a Web based database system. This would enable the bakery branches to enter data for designing, purchasing, etc. Currently, the file containing all the data has these fields:

Bakery Branch Name, Cake Name, Cake Description, PriceCustomer Pays, Cost to Create the Cake, Designer Name, Design Time (in days), Date of First Design of this Cake, Date of Most Recent Delivery, Date of Most Recent Purchase, Delivery Date 1, Delivery Date 2, Delivery Date 3, Delivery Date 4, Purchase Date 1, Purchase Date 2, Purchase Date 3, Purchase Date 4, Most Recent Customer Name and address, Customer Name and Address 1, Customer Name and Address 2, Customer Name and Address 3, Customer Name and Address 4

Assume you want to track all purchase and design data, such as who bought the cake, the date that it was purchased, the date that it was delivered, and so on. The present file format only allows for the tracking of the most recent purchase as well as 4 prior purchases and delivery dates. You can assume that a particular type of cake (one inventory item) is only designed by one designer.

Design a normalized data model for this information showing all table names, field names, primary keys, and foreign keys. Be sure it is in 3NF. Add any fields that you may need.

Draw your work neatly on a separate sheet.