Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Archer Solutions needs to store the following data about customers and sales in a relational database: Product ID Order date Customer ID Customer address

Archer Solutions needs to store the following data about customers and sales in a relational database: Product ID Order date Customer ID Customer address Customer name Customer phone Selling price (per unit) Quantity sold Purchase order number Product Description Salesperson ID Salesperson name Salesperson commission rate You are an intern at a local CPA firm. You have been asked by your supervisor to draw a physical ERD for Archer Solutions to illustrate relationships and field names for these tables in a relational database. You must also identify the primary keys and foreign keys that relate to the tables. You may add additional field names, as necessary. For example, the salesperson would have a first name and a last name.

Step by Step Solution

3.42 Rating (171 Votes )

There are 3 Steps involved in it

Step: 1

Heres a physical ERD for Archer Solutions In this diagram Salesperson Product and Customer are three ... 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_2

Step: 3

blur-text-image_3

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

Accounting Information Systems

Authors: Marshall B. Romney, Paul J. Steinbart

13th edition

133428532, 978-0133428537

More Books

Students also viewed these Mathematics questions

Question

4.1 Describe listening problems and their possible solutions

Answered: 1 week ago