Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Evaluating The Effectiveness On Internal Audit Departments

Authors: Dereje Ferede Asrat, Sewale Abate Ayalew

1st Edition

3659298387, 978-3659298387

More Books

Students also viewed these Accounting questions