(Solved): Consider the following data. Arrows show the functional dependency. The arrows in this question in ...

Consider the following data. Arrows show the functional dependency. The arrows in this question indicated the determination of two attributes. For example, the arrow that goes ProductID to ProductDescription indicates that ProductID determines the ProductDescription. This in turn means that ProductId can be considered as primary key for ProductDescription. a) Write the tables b) Place the tables in $$3^{\text{rd }}$$ normal form (if necessary) c) Create ERD based on the normalized tables d) Write a script to create a database. Your script should create the tables and ensures that all constraints are set properly. Here is some information to create your tables