Big Yellow Supermarket uses a single table SUPPLIER to store its data. For each supplier, the table SUPPLIER lists the store location that the supplier ships products to. Each record also lists the store size and manager name. The table SUPPLIER has the following columns:

SupplierID	Supplier's identifier, a unique value for each supplier
SupplierName	Supplier's name
StatusID	Supplier's status identifier. Each supplier has only one status. Examples of StatusID are G1, G2, etc.
StatusName	Supplier's status description. Examples of StatusName are Grade1, Grade2, etc.
SupplierStreetAddress	Supplier's street address
SupplierSuburb	Supplier's suburb
SupplierCity	Supplier's city
StoreID	Big Yellow Supermarket store that the supplier ships products to. A supplier can supply products to multiple stores and the same store can have more than one supplier.
StoreSize	Store size in square metres
StoreManager	Store's manager name
NoOfProducts	Number of products a particular supplier supplies for a particular store

Make sure you clearly write down a., b., c. followed by your answers.

1. [4 marks] Draw the dependency diagrams or write down the dependencies based on the information given in the question.
2. [2 marks] If you do not make any changes to the structure of this table, this table is in which normal form? Why?
3. [5 marks] Based on the dependency diagrams that you created, change the data structure and create tables that are in 3NF, if possible.