Consider the sales transactions come from the following tables:1. Product (Product ID (PK), Product Name, Product Category (FK), Product Price)2. Employee (Employee ID (PK), Employee Name, Department Code (FK))3. Department (Department Code (PK), Department Location, Region)4. Customer (Customer ID (PK), Customer Name, Customer Address, City Code (FK))5. City (City Code (PK), City Postcode, City State)6. Sales (Sales ID (PK), Date Sales, Product ID (FK), Employee ID (FK), Customer ID (FK), Quantity,Cost Sales)Draw the dimension modeling for producing the reporting. An electronic gadget distibutor company Low Yatt Seng is based in Alor Setar, Kedah sells itsproducts in north, north-west, and western region of Malaysia. They have sales units at Penang,Kuala Lumpur, and Johor Bahru. The CEO of the company wants the latest sales information tomeasure the sales performance and to take corrective actions if required. He has requested thereport as follows:JanuaryFebruaryMarchUnitsRMUnitsRMUnitsRMPenangDigital Camera525003500Mobiles Phones315001680003000Pen Drives4800168001000Kuala Lumpur_ Digital CameraMobiles Phones350031500Pen Drives4450945015750Johor BahruDigital Camera3500Mobiles Phones31500Pen Drives445045015750ТОTAL266500502100406500

Here given two question according to our policy we can solve first one:…

Answered: Consider the sales transactions come…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Consider the sales transactions come from the following tables:
1. Product (Product ID (PK), Product Name, Product Category (FK), Product Price)
2. Employee (Employee ID (PK), Employee Name, Department Code (FK))
3. Department (Department Code (PK), Department Location, Region)
4. Customer (Customer ID (PK), Customer Name, Customer Address, City Code (FK))
5. City (City Code (PK), City Postcode, City State)
6. Sales (Sales ID (PK), Date Sales, Product ID (FK), Employee ID (FK), Customer ID (FK), Quantity,
Cost Sales)
Draw the dimension modeling for producing the reporting.