Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
stores dimension store id store name products dimension store street product name sales fact store postcode product type product cost product price product id store city store provinnce market id payment code date life expect city gender birth store employee dimension marketing dimension marketing name marketing start employee id employee first name employee customer store id employee last name discount employee id employee gender marketing end customer name customer contect information customers dmiension payment dimension employee name employee gender customer id age lifeexpect life id patment method id customer first name payment method name payment method amount customer last name customergender customer contect information date dimension demografic groups date group age id city population city population id city age begin age end week defintion month year id day table name names provance time coments id names description gender population namerank

stores dimension store id store name products dimension store street product name sales fact store postcode product type product cost product price product id store city store provinnce market id payment code date life expect city gender birth store employee dimension marketing dimension marketing name marketing start employee id employee first name employee customer store id employee last name discount employee id employee gender marketing end customer name customer contect information customers dmiension payment dimension employee name employee gender customer id age lifeexpect life id patment method id customer first name payment method name payment method amount customer last name customergender customer contect information date dimension demografic groups date group age id city population city population id city age begin age end week defintion month year id day table name names provance time coments id names description gender population namerank

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
100%

i am making a  of a data ware house for a shop .

this is the draft I made .

how could I draw this  into a star schema .

 

what will it looks like batter ? include all the primary key / foreign key relationships it ?

stores dimension store id store name products dimension store street product name product type sales fact store postcode product id store city product cost market id store provinnce product price payment code date life expect city gender employee dimension employee id employee first name employee last name employee gender store marketing dimension employee marketing name marketing start customer store id discount employee id marketing end customer name birth customer contect information customers dmiension employee name employee gender payment dimension customer id age lifeexpect life id patment method id customer first name payment method name customer last name customergender customer contect information payment method amount date dimension demografic groups group age id age begin date city population city population city week defintion month age end year id day table name names provance time coments id names description gender population namerank
Transcribed Image Text:stores dimension store id store name products dimension store street product name product type sales fact store postcode product id store city product cost market id store provinnce product price payment code date life expect city gender employee dimension employee id employee first name employee last name employee gender store marketing dimension employee marketing name marketing start customer store id discount employee id marketing end customer name birth customer contect information customers dmiension employee name employee gender payment dimension customer id age lifeexpect life id patment method id customer first name payment method name customer last name customergender customer contect information payment method amount date dimension demografic groups group age id age begin date city population city population city week defintion month age end year id day table name names provance time coments id names description gender population namerank
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Principles of Designing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS