Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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).
NOTE: Here we need the 0NF, 1NF, 2NF, and 3NF with tables not how to create this table in SQL or mySql, etc.
ZYX Market Invoice Date: 02/05/2019 123 Sheridan St. Pasadena, CA 93321 Due Date: 03/05/2019 Phone: 805-332-6547 Bill To: Lola Express Phone: 888-302-5476 Address: 258 Bowman St. Fax: Winsor, CT 05278 Email: lolaexpress@shipping.com USA Contact: Susan Smith Item Code Item Description Unit Price QTY Flat Fee Discount Total A1002 Coffee 3 oz. $112.00 1 $112.00 A209-1 Coffee Mate $20.00 1 $20.00 F302-2 Coffee Filters $5.00 3 $15.00 Invoice $147.00 Subtotal Deposit Amount Tax $3.00 Total $150.00 ZYX Market Invoice Date: 02/05/2019 123 Sheridan St. Pasadena, CA 93321 Due Date: 03/05/2019 Phone: 805-332-6547 Bill To: Lola Express Phone: 888-302-5476 Address: 258 Bowman St. Fax: Winsor, CT 05278 Email: lolaexpress@shipping.com USA Contact: Susan Smith Item Code Item Description Unit Price QTY Flat Fee Discount Total A1002 Coffee 3 oz. $112.00 1 $112.00 A209-1 Coffee Mate $20.00 1 $20.00 F302-2 Coffee Filters $5.00 3 $15.00 Invoice $147.00 Subtotal Deposit Amount Tax $3.00 Total $150.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started