Below is a sample inventory management Reports that ABC Company started to use. Your task is to begin the process of creating a set of normalized relations based on this form.

Answer the following questions on paper and upload a file containing your answer

1. What is this report grouped by? (2)

(a) What is the repeating group or redundant data (write it out) (3)

Imagine that this report is produced from one table containing all the above attributes. Write out the relational schema for this table using the following format

(b) TABLE NAME ( ATTRIBUTE 1, ATTRIBUTE 2,..) and identify the PK using appropriate notation. (10)

(c) What is the primary key for this table? (3)

(d) Draw a dependency diagram (12)

(e) Are there any partial dependencies? Write them out using the following notation:-(10)

A-> B

(f) Are there any transitive dependencies? Write them out using the following notation (5)

A-> B

Before submitting the answer, in the picture please label the question # clearly and please answer the question in the order above.