Draw a star schema, in the form of an ER diagram, using the data contained in Figure 1.  
Include fact table, dimension tables, characteristics, key figures
Hint: The dimension tables should be - Customer, Store, Department, SKU, Time, TransactionInfo, Unit
Show the relationships
Show the keys
Suppress the datatypes.

     

Transcribed Image Text:

Figure 1 Below is the list of tables in this database, and the number of records in each table: TABLE NAME CUSTOMER Nitin Kal & Nancy Jones 2021 Star Schema DEPARTMENT SKU SKUSTORE STORE TRANSACT CUSTOMER TABLE: Column name CUST_ID CITY STATE ZIP CODE ZIP SECSEG DISTANCE_TO_NEAR EST_STORE Column name NUMBER OF RECORDS 75,544,740 DEPT DEPT_DESC 580 DEPTDEC 6,784,378 164,178,473 313 PREFERRED_STORE Foreign Key (References STORE table) 107,572,906 DEPARTMENT TABLE: Key specifications Primary key Key specifications Primary key Datatype Integer (not null) Varchar (28) Char(2) Char(5) Char(4) Decimal(8,3) Small Int Datatype Varchar (10), not null Varchar (25) Char(4) -2- Short description Long description Unique identifier representing a customer instance City where the customer lives. State where the Customer Identifier City State Zip code Sector segment code Distance to nearest store for customer Customer Preferred Store Location Short description Department Number Department Description Department Decade code code. Customer's geographic segment customer lives. Customer's 5-digit zip 72701 84770 code Miles from the customer's house to Custo the closest Dillard's store. Dillard's store number the customer prefers to shop at regardless of distance to the customer's home address. The name for a department collection of merchandise within a store format. The first three digits of a department code, a way to Sample values 219948527 219930818 HOUSTON COOS BAY FL TX 5052 6474 0.687 6.149 910 774 Long description/ Additional Details The Dillard's unique identifier for a collection of merchandise within a store format 6689 EPISTEMY PRESS 0471 0029 Sample values 047X 002X "Christian Dior" "REBA" Figure 1 Below is the list of tables in this database, and the number of records in each table: TABLE NAME CUSTOMER Nitin Kal & Nancy Jones 2021 Star Schema DEPARTMENT SKU SKUSTORE STORE TRANSACT CUSTOMER TABLE: Column name CUST_ID CITY STATE ZIP CODE ZIP SECSEG DISTANCE_TO_NEAR EST_STORE Column name NUMBER OF RECORDS 75,544,740 DEPT DEPT_DESC 580 DEPTDEC 6,784,378 164,178,473 313 PREFERRED_STORE Foreign Key (References STORE table) 107,572,906 DEPARTMENT TABLE: Key specifications Primary key Key specifications Primary key Datatype Integer (not null) Varchar (28) Char(2) Char(5) Char(4) Decimal(8,3) Small Int Datatype Varchar (10), not null Varchar (25) Char(4) -2- Short description Long description Unique identifier representing a customer instance City where the customer lives. State where the Customer Identifier City State Zip code Sector segment code Distance to nearest store for customer Customer Preferred Store Location Short description Department Number Department Description Department Decade code code. Customer's geographic segment customer lives. Customer's 5-digit zip 72701 84770 code Miles from the customer's house to Custo the closest Dillard's store. Dillard's store number the customer prefers to shop at regardless of distance to the customer's home address. The name for a department collection of merchandise within a store format. The first three digits of a department code, a way to Sample values 219948527 219930818 HOUSTON COOS BAY FL TX 5052 6474 0.687 6.149 910 774 Long description/ Additional Details The Dillard's unique identifier for a collection of merchandise within a store format 6689 EPISTEMY PRESS 0471 0029 Sample values 047X 002X "Christian Dior" "REBA"