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.

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