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!
P.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
Get step-by-step solutions from verified subject matter experts
