Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are the manager of a company that sells telephones online. You can purchase different products from the same supplier, but you dont buy the

image text in transcribed

You are the manager of a company that sells telephones online. You can purchase different products from the same supplier, but you dont buy the same product from different suppliers. You have ONE supplier in each country. Some products may be produced in many countries, and a given country may produce many products. Your customers may buy different products, and any product can be purchased by many customers. You record accounting related data for each product in the accounting table once. And the orders table contains the history of your orders.

QUESTION:

THIS EXCEL TABLE NAME IS "ORDERS" TABLE, WHAT IS THE ROLE OF ORDERS TABLE?

A B D E F G 1 2 3 2 4 5 6 6 7 Quantity sold 12 2 3 6 5 5 7 4 2 11 5 8 9 10 ON ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 11 Model Galaxy A60 Galaxy M30 Galaxy M40 Galaxy S10 Galaxy S10+ Galaxy A30s Galaxy A10s Galaxy A20s GalaxyM10s Galaxy S8 Galaxy Note 10+ Galaxy S9 Galaxy Note 9 Galaxy Fold P30 lite P30 Pro Y5 Y6 Y9 Y9 Prime Mate 20 Date sold Delivery Country Customer ID 11-Dec-18 Austria AA3245 08-Aug-18 Algeria ZA9867 13-Nov-18 Abu Dhabi AK8765 06-Nov-18 Morocco AK4356 18-Mar-19 Turkey AM7865 05-Feb-19 Albania AA3245 06-Nov-18 American Samoa JM4546 27-Nov-18 Angola FY7676 18-Feb-19 Austral Oceania FG6548 08-Oct-18 Argentina FB6543 14-Aug-18 Saint Barthelemy HS7865 16-Aug-18 Zambia AO8675 21-Dec-18 Christmas Is AI8765 30-Oct-19 Botswana AH6754 17-Jun-19 Russia ZA9867 11-Dec-18 France YM9647 26-Dec-18 Saint Barthelemy SH9876 07-Feb-19 Botswana AM3657 10-Apr-19 Nicaragua AK8765 04-Jun-19 American Samoa NS5647 12-Mar-19 Kazakhstan KA5678 Order Number 7845-9309-0678 5468-6754-3435 4564-8987-6765 9086-9875-4834 8374-6589-0478 0398-7654-6875 5623-4750-9867 2342-5678-9000 8864-5786-9853 6738-4903-5567 8475-3443-5678 2384-7956-7895 8912-3456-7987 4567-8987-6543 9877-6723-4567 4568-7991-0897 4675-8649-8765 7568-7859-4736 6453-7489-6875 5678-0987-6352 3567-8896-7764 12 13 S 14 15 16 4 17 18 8 9 4 2 2 11 5 3 8 19 20 21 22 Sales + A B D E F G 1 2 3 2 4 5 6 6 7 Quantity sold 12 2 3 6 5 5 7 4 2 11 5 8 9 10 ON ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 11 Model Galaxy A60 Galaxy M30 Galaxy M40 Galaxy S10 Galaxy S10+ Galaxy A30s Galaxy A10s Galaxy A20s GalaxyM10s Galaxy S8 Galaxy Note 10+ Galaxy S9 Galaxy Note 9 Galaxy Fold P30 lite P30 Pro Y5 Y6 Y9 Y9 Prime Mate 20 Date sold Delivery Country Customer ID 11-Dec-18 Austria AA3245 08-Aug-18 Algeria ZA9867 13-Nov-18 Abu Dhabi AK8765 06-Nov-18 Morocco AK4356 18-Mar-19 Turkey AM7865 05-Feb-19 Albania AA3245 06-Nov-18 American Samoa JM4546 27-Nov-18 Angola FY7676 18-Feb-19 Austral Oceania FG6548 08-Oct-18 Argentina FB6543 14-Aug-18 Saint Barthelemy HS7865 16-Aug-18 Zambia AO8675 21-Dec-18 Christmas Is AI8765 30-Oct-19 Botswana AH6754 17-Jun-19 Russia ZA9867 11-Dec-18 France YM9647 26-Dec-18 Saint Barthelemy SH9876 07-Feb-19 Botswana AM3657 10-Apr-19 Nicaragua AK8765 04-Jun-19 American Samoa NS5647 12-Mar-19 Kazakhstan KA5678 Order Number 7845-9309-0678 5468-6754-3435 4564-8987-6765 9086-9875-4834 8374-6589-0478 0398-7654-6875 5623-4750-9867 2342-5678-9000 8864-5786-9853 6738-4903-5567 8475-3443-5678 2384-7956-7895 8912-3456-7987 4567-8987-6543 9877-6723-4567 4568-7991-0897 4675-8649-8765 7568-7859-4736 6453-7489-6875 5678-0987-6352 3567-8896-7764 12 13 S 14 15 16 4 17 18 8 9 4 2 2 11 5 3 8 19 20 21 22 Sales +

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

Database Processing

Authors: David M. Kroenke

12th Edition International Edition

1292023422, 978-1292023427

More Books

Students also viewed these Databases questions

Question

Understand the roles of signs, symbols, and artifacts.

Answered: 1 week ago

Question

Discuss the key ambient conditions and their effects on customers.

Answered: 1 week ago

Question

Be familiar with the integrative servicescape model.

Answered: 1 week ago