Question
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started