Please create the table in SQL for this data warehouse and 10 SQL queries.
The given schema is represented by implementing Star Schema to design a Data Warehouse for it as shown below:
Dimension: Customer
- UserName
- FullName
- Email
- Contact
- Address
- Password
Dimension: Restaurant
- RestaurantID
- Email
- Contact
- Address
- Name
Dimension: Menu
- FoodID
- Name
- Price
- Description
- SoupDo
- ImagesPath
- RestaurantID (FK)
- ManagerID (FK)
Dimension: OrderPizzaNet
- OrderID
- UserName
- FoodID
- PaymentID
- RestaurantID
- ManagerID
Dimension: Manager
- ManagerID
- Contact
- Address
- Password
- FullName
- Email
Dimension: Payment
- PaymentID
- SumOfPrices
- OrderID
The above star schema consists of six dimension tables: OrdersPizzaNet, Payment, Menu/Food, Customer, Restaurant, and Manager. Also, their attributes are shown within dimension tables with primary keys and foreign keys. The star schema consists of one fact table: 'Sales' in the middle, which gives facts about the sales of food items.