Task 4: You have been given a spreadsheet that contains details of invoices. The column headers for the spreadsheet are: date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep number, salesrep first name, salesrep last name, salesrep district, district name, and district size. Create a high fidelity data model. In other words, list the set of tables (=entities) with their respective column headers. If easier, and alternatively, you can draw an ERD diagram. (Optional: Add some sample data).
Task 4: You have been given a spreadsheet that contains details of invoices. The column headers for the spreadsheet are: date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep number, salesrep first name, salesrep last name, salesrep district, district name, and district size. Create a high fidelity data model. In other words, list the set of tables (=entities) with their respective column headers. If easier, and alternatively, you can draw an ERD diagram. (Optional: Add some sample data).
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers
Section: Chapter Questions
Problem 8EYW
Related questions
Question
Task 4:
You have been given a spreadsheet that contains details of invoices. The column headers for the
spreadsheet are:
date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust
city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep
number, salesrep first name, salesrep last name, salesrep district, district name, and district size.
Create a high fidelity data model. In other words, list the set of tables (=entities) with their respective
column headers. If easier, and alternatively, you can draw an ERD diagram. (Optional: Add some sample
data).
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage