Data Base course, please answer this Assignment according to the Requirement questions.

Assignment 2: First Normal Form Introduction First Normal Form (1NF) represents the minimum amount of organization necessary for the efficient processing of data in a computer. Tabular data must conform the rules of a relation. This assignment asks students to reorganize data from a semi-structured format to that of a relation By the end of this assignment, students will have improved their ability to: Reorganize data to meet the standard of 1NF; .Assign appropriate metadata to attributes in the relational model: Recognize the limitations of 1NF for large data stores. Instructions Download assignment2.xlsx from the Blackboard course site. Review the data in the TABLE tab to understand the problem Reorganize the data in RELATION tab to conform to the requirements of a relation (1NF). This is the same data as that in the TABLE tab. If you make a mistake, you can copy the TABLE tab as many times as you need. Complete the metadata definitions for the relation in the METADATA tab. Please use the data types defined for MS Access since we will soon be implementing database in this RDBMS In Cell A1 of the tab labeled REFLECTION, write a short paragraph detailing the shortcomings of the 1NF solution in your RELATION tab. Why is this model (1NF) insufficient for large datasets? 1. 2. 3. 4. 5. J16 1 CLIENT CLIENT NO ICLIENT EMAIL CLIENT PHONE 2 Acme, Inc 1orders@acme.com 340-867-5309 4 ITEM ID ITEM NAME A47 B59 PRICE Widget Fard $1.0010 52.50 4 QTY ORDER_NO ORDER_DATE 98 1/1/2019 98 1/1/2019 orders@bell.com, 2 support@bell.com 725-867-5309 8 Bell, LLC. 10 ITEM ID ITEM NAME PRICE QTY ORDER_NO ORDER_DATE 1002/2/2019 A47 Widget $1.0015 12 13 15 16 17 18 19 21 TABLE RELATION | METADATA | REFLECTION 1 CLIENT CLIENT NO ICLIENT EMAIL CLIENT PHONE 2 Acme, Inc. 1 orders@acme.com 340-867-5309 4 ITEM ID ITEM NAME A47 B59 PRICE QTY ORDER_NO ORDER_DATE 981/1/2019 981/1/2019 Widget $1.0010 52.50 4 Fard orders@bell.com, 2 support@bell.com 725-867-5309 8 Bell, LLC. ITEM ID ITEM NAME PRICE QTY ORDER_NO ORDER_DATE 1002/2/2019 A47 Widget $1.0015 12 17 18 19 21 | TABLE RELATION METADATA | REFLECTION TABLE I RELATION | METADATA REFLECTION Field Name Data Type Field Length Required Notes 2 4 10 12 13 1ei 17 18 19 20 21 2 TABLE | RELATION METADATA REFLECTION