Question: Database system question Based on the ERD, DESIGN the data warehouse (CREATE a star or snowflake scheme and architecture). Then specify the DBMS which you

Database system question

Based on the ERD, DESIGN the data warehouse (CREATE a star or snowflake scheme and architecture). Then specify the DBMS which you will choose to be the data warehousing. Please answer properly based on what I asked!

Database system question Based on the ERD, DESIGN the data warehouse (CREATEP.S: - Please answer in a proper format - Please answer in a typed format - Please don't do it with pen or pencil, do it with software or tools - If you want to ask any question, ask it in the comment section, I will try to answer it Thanks!

customers carts PK lid uuid PK lid uuid carts_details FK cart_id uuid FK Jitem_id uuid quantity int FK customer_id uuid name varchar gender varchar bod date phone_number varchar address varchar shipments_details FK shipment_id uuid FK order_id uuid PK id shipments uuid datetime date staffs PK id uuid orders name varchar uuid uuid orders_details FK order_id uuid FK item_id uuid quantity int PK id customer_id staff_id date gender varchar bod date phone number varchar address varchar salary numeric uuid datetime items items_categories uuid PK id PK Jid uuid varchar name varchar name price numeric uuid FK category_id customers carts PK lid uuid PK lid uuid carts_details FK cart_id uuid FK Jitem_id uuid quantity int FK customer_id uuid name varchar gender varchar bod date phone_number varchar address varchar shipments_details FK shipment_id uuid FK order_id uuid PK id shipments uuid datetime date staffs PK id uuid orders name varchar uuid uuid orders_details FK order_id uuid FK item_id uuid quantity int PK id customer_id staff_id date gender varchar bod date phone number varchar address varchar salary numeric uuid datetime items items_categories uuid PK id PK Jid uuid varchar name varchar name price numeric uuid FK category_id

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!