Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Customer Customer Customer Name - 1000 Smith 1001 Jones 2002 Jeffries 1003 Gilkey 1004 Lankford 1005 Zeile 1006 Pagnozzi 1007 Arocha o City Phoenix St.

image text in transcribed
image text in transcribed
Customer Customer Customer Name - 1000 Smith 1001 Jones 2002 Jeffries 1003 Gilkey 1004 Lankford 1005 Zeile 1006 Pagnozzi 1007 Arocha o City Phoenix St. Louis Atlanta Phoenix Phoenix Chicago Salt Lake City Chicago State AZ MO GA AZ AZ IL UT IL Inventory Item Description - Unit Cost Unit Price 1010 Blender $14.00 $29.95 1015 Toaster $12.00 $19.95 1020 Mixer $23.00 $33.95 1025 Television $499.00 $699.95 1030 Freezer $799.00 $999.95 1035 Refrigerator $699.00 $$49.95 1040 Radio $45.00 $79.95 1045 Clock $79.00 $99.95 Sales-Inventory Invoice Number Item Number - Quantity 101 1025 101 1035 102 1045 103 1010 103 1015 103 1025 104 1025 1046 1045 1 105 1035 106 1045 107 1030 107 1035 107 10-10 107 1045 108 1025 108 10-15 Sales tric Nurnbet 101 102 103 104 Dale - Salon - Custom Numb 10/3/2018 Wilson 1000 10/5/2018 Mahomet 1003 10/5/2018 Jackson 1002 10/15/2018 Drexen 1000 10/15/2018 Martinez UUS 10/16/2018 Martinez 1007 10/29/2018 Mahomet 1002 11/3/2018 Martinez 1000 106 107 108 Requirement: 1. Create the four tables (3 marks) 2. Edit all the necessary relationships (2 marks) 3. Create the following queries: (5 marks) a. What are sales invoice numbers, salesperson for the customer Smith? b. What are items number, description, quantity and price sold to customer Jeffries? c. Who are salespersons, invoices date and number, for customer number 1000? d. What are sales invoice numbers, the name, city and state for customer number 1005? e. Who are customers (name and number) who bought item number 1025

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

Bank Strategy, Governance And Ratings

Authors: P. Molyneux

3rd Edition

0230313345, 9780230313347

More Books

Students also viewed these Accounting questions

Question

Evaluate the integral. ( + ) J zp

Answered: 1 week ago

Question

1. What physical and mental tasks does the worker accomplish?

Answered: 1 week ago

Question

5. Why is the job done?

Answered: 1 week ago

Question

4. How does the worker do the job?

Answered: 1 week ago