A pet store currently uses a legacy flat file system to store all of its information. The owner of the store, Peter Corona, wants to implement a Web-enabled database application. This would enable branch stores to enter data regarding inventory levels, ordering, and so on. Presently, the data for inventory and sales tracking are stored in one file that has the following format:
a. Show all functional dependencies.
b. What normal form is this table in?
c. Design a normalized data model for these data. Show that it is in 3NF.