Been told this isnt a enough info when I asked this question intially, this is not the case as Im showing you the entire answer. If you don't know how to do it, simply ignore it, do not waste my questions.

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. Inventory Report Supplier Number 101 livery Qty Item NO Dept No Item Name Item Type Item Color Supplier Nome Delivery No Sweatshop 58 59 60 106 10 11 25 10 8 8 8 8 Brown Geo Positio N Map Meas N Map Case Sextant N Pith Helmec Compass N 61 217 71 Khaki 1 12 503 57 8 102 Nepalese 84 8 Brown 5 10 29 94 11 93 25 11 92 10 9 2 91 105 59 90 2 8 8 89 55 88 Khaki Khaki 87 Map Case How to WiB Exploring in B How to WB Exploring in B How to WIB Exploring in Tent - 8 Per F Tent2 Per Compass N Map Meas N Geo Position Compass N Pocket Knif Pith Helmec Sextant N Pocket Knif E 2 22 521 53 10 11 85 2 83 82 16 8 8 81 BO Brown Khaki 22 3 10 14 1 12 5 17 5 13 67 11 86 Brown Answer the following questions on paper, scan and upload a file containing your answer (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) A->B