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 Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter3: The Relational Database Model
Section: Chapter Questions
Problem 25P: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many...
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 ?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning