Convert this FORM into a Normalized Database

1- Prepare a database named ‘Invoice’ in ‘raw form/0NF’ and add all the fields as columns and fill up the table with given data (line items, name etc.).

2-Perform the Normalization process of 1NF, 2NF, 3NF and normalize the Invoice table. Show all your steps in an organized way. Highlight (in any color) the Primary Key, Composite key, Foreign Key(s) of the Table(s).

 

Transcribed Image Text:

ZYX Market 123 Sheridan St. Pasadena, CA 93321 Phone: 805-332-6547 Bill To: Lola Express Address: 258 Bowman St. Winsor, CT 05278 USA Item Code Item Description A1002 Coffee 3 oz. Coffee Mate Coffee Filters A209-1 F302-2 Phone: 888-302-5476 Fax: Email: lolaexpress@shipping.com Contact: Susan Smith Unit Price $112.00 $20.00 $5.00 QTY 1 1 3 Invoice Date: 02/05/2019 Due Date: 03/05/2019 Flat Fee Discount Invoice Subtotal Deposit Amount Tax Total Total $112.00 $20.00 $15.00 $147.00 $3.00 $150.00 ZYX Market 123 Sheridan St. Pasadena, CA 93321 Phone: 805-332-6547 Bill To: Lola Express Address: 258 Bowman St. Winsor, CT 05278 USA Item Code Item Description A1002 Coffee 3 oz. Coffee Mate Coffee Filters A209-1 F302-2 Phone: 888-302-5476 Fax: Email: lolaexpress@shipping.com Contact: Susan Smith Unit Price $112.00 $20.00 $5.00 QTY 1 1 3 Invoice Date: 02/05/2019 Due Date: 03/05/2019 Flat Fee Discount Invoice Subtotal Deposit Amount Tax Total Total $112.00 $20.00 $15.00 $147.00 $3.00 $150.00

Answer rating: 100% (QA)

To convert the provided invoice form into a normalized database we first need to consider the elements present in the form and then organize them into database tables that adhere to each normal form R... View the full answer