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,

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