Below is a sample inventory management Report that ABC Company uses. Your task is to begin the process of creating a set of normalized relations based on this report.

(a) What is this report grouped by? (2)

(b) 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

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

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

(e) Draw a dependency diagram (12)

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

A-> B

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

Inventory Report Supplier Number 101 livery Qty Item No Dept No Item Name Item Type Item Color 106 Supplier Nome Delivery No Sweatshop 58 59 60 61 71 Brown 10 11 25 10 217 112 503 Geo Position Map Meas N Map Case Sextant N Pith Helmec Compass N Khaki 57 102 Nepalese 84 8 Brown 11 93 92 5 10 29 25 109 105 59 55 91 2 2 8 90 89 88 2 22 Khaki 87 11 11 2 Map Case How to WB Exploring in B How to WIB Exploring in B How to WIB Exploring in B Tent - 8 Per F Tent-2 Per F Compass N Map Meas N Geo Position Compass N Pocket Knife Pith Helmec Sextant N Pocket Knife 85 83 8 521 53 10 11 16 13 10 14 1 12 517 82 81 80 Brown Khaki 72 3 67 86 5 13 Brown