Database tables and apply the requirements below. Primary keys Eliminate duplicate data Eliminate unnecessary dependancies Apply 3
Fantastic news! We've Found the answer you've been seeking!
Question:
- Database tables and apply the requirements below.
- Primary keys
- Eliminate duplicate data
- Eliminate unnecessary dependancies
- Apply 3 rules of normalization 1NF - 2 NF - 3NF
For the following table:
Given a Table named “Invoices”, where the following data is stored:
- Invoice_Num
- Customer_Name
- Invoice_Date
- Package_Number
- Shipping_Cost
- Total_Before_Taxes
- Total_Taxes = Calculation of taxes
- Total_Invoice = Sum of Total_Before_Taxes and Total_Taxes
- Customer_Address_1
- Customer_Address_2
- Customer_Phone_1
- Customer_Phone_2
- Customer_Email_1
- Customer_Email_2
- Invoice_Registry_Date
- Registry_Username = Username that registered the invoice.
- Current_State_Invoice
Related Book For
Accounting Information Systems basic concepts and current issues
ISBN: 978-0078025334
3rd edition
Authors: Robert Hurt
Posted Date: