Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Database system question Based on the ERD, design and explain the data warehouse (star scheme and architecture). Then specify the DBMS which you will choose

Database system question

Based on the ERD, design and explain the data warehouse (star scheme and architecture). Then specify the DBMS which you will choose to be the data warehousing,

image text in transcribed 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions