An electronic gadget distibutor company Low Yatt Seng is based in Alor Setar, Kedah sells its products 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 to measure the sales performance and to take corrective actions if required. He has requested the report as follows: January February March Units RM Units RM Units RM Penang Digital Camera 5 2500 3 500 Mobiles Phones 3 1500 16 8000 6 3000 Pen Drives 4 800 16 800 6 1000 Kuala Lumpur Digital Camera 3 500 Mobiles Phones 3 1500 Pen Drives 4 450 9 450 15 750 Johor Bahru Digital Camera 3 500 Mobiles Phones 3 1500 Pen Drives 4 450 9 450 15 750 TOTAL 26 6500 50 2100 40 6500 Consider the sales transactions come from the following tables: Product (Product ID (PK), Product Name, Product Category (FK), Product Price) Employee (Employee ID (PK), Employee Name, Department Code (FK)) Department (Department Code (PK), Department Location, Region) Customer (Customer ID (PK), Customer Name, Customer Address, City Code (FK)) City (City Code (PK), City Postcode, City State) 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.

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

An electronic gadget distibutor company Low Yatt Seng is based in Alor Setar, Kedah sells its products 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 to measure the sales performance and to take corrective actions if required. He has requested the report as follows:

		January		February		March
		Units	RM	Units	RM	Units	RM
Penang	Digital Camera	5	2500			3	500
	Mobiles Phones	3	1500	16	8000	6	3000
	Pen Drives	4	800	16	800	6	1000
Kuala Lumpur	Digital Camera					3	500
	Mobiles Phones	3	1500
	Pen Drives	4	450	9	450	15	750
Johor Bahru	Digital Camera					3	500
	Mobiles Phones	3	1500
	Pen Drives	4	450	9	450	15	750
TOTAL		26	6500	50	2100	40	6500

Consider the sales transactions come from the following tables:

Product (Product ID (PK), Product Name, Product Category (FK), Product Price)
Employee (Employee ID (PK), Employee Name, Department Code (FK))
Department (Department Code (PK), Department Location, Region)
Customer (Customer ID (PK), Customer Name, Customer Address, City Code (FK))
City (City Code (PK), City Postcode, City State)
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.