1. Using Microsoft SQL Server, for the implemented of the database design and schemas that I provided. You must use SQL syntax to create tables.
a. For each relational table, insert at least 10 records. The records can be fictitious.
You must use SQL syntax to insert data into the relational database.
2. Write at least ten queries that are relevant to your project scenario.
a. There should be at least one query using INNER JOIN.
b. There should be at least one query using OUTER JOIN.
c. There should be at least one query using sub-query.
d. There should be at least one query joining three or more tables.
RELATIONSHIP SUMMARIZE: Relationshi Cardinalit MA Parent Type Nonidentifvin Nonidentifyin Nonidentifvin Nonidentifying Nonidentifying 1:N O-o Nonidentifyin Child RESTAURANT MENU 2 RESTAURANT ORDER 3 CUSTOMER 4 CUSTOMER 1:N M-O 1:N M-O 1:N M-0 I:N M-O ORDER CARD DELIVERYGORDER 6 ORDER 7MENU 8 ORDER COMMENT MENU ORDEIdentifying 1:1 M-O MENU ORDE Identifying 1:N M-0 Schemas: RESTAURANT(Restaurant ID, Name, Address, PhoneNumber, FoodType, Description, GetMethod, OpenTime, EndTime) MENU(Item ID, Restaurant ID,Name, Price, Type, Image, Description) CUSTOMER Customer ID, Email, FirstName, LastName, PhoneNumber, Address) CARD CardNumber, Customer ID, Expire Year, ExpireMonth, CardType, FirstName, ID, Restaurant LastName) DELIVERYGUY(DeliveryGuy ID, FirstName, LastName, Email, PhoneNumber) ORDER(Order ID, Restaurant ID, Customer ID, DeliveryGuy ID, Note, GetMethod, Time, TotalPrice, Coupon) PICKUP(Order ID, Statu, ScheduledTime, RealTime) DELIVERY (Order ID Statu, EstimateTime, RealTime) COMMENT Comment ID, Order ID, Star, Text, Time) MENU ORDER(Item ID Order ID SQL create Statements create table Restaurant ( Restaurant ID int primary key Name varchar, Address varchar, PhoneNumber varchar, FoodType varchar, Description varchar, GetMethod varchar, Opentime date, EndTime date create table Menu ( Item ID int primary key, Restaurant_ID int, Name varchar, Price int, MType varchar, Image varchar, Description varchar, foreign key (Restaurant ID) references Restaurant (Restaurant _ID) create table Customer ( Customer ID int primary Email varchar, FirstName varchar LastName varchar, Phonenumber varchar Address varchar key, create table Card ( CardNumber int primary key, Customer ID int, ExpireYear int, ExpireMonth int, CardType varchar, FirstName varchar, LastName varchar, foreign key (Customer ID) references Customer (Customer ID) create table DeliveryGuy( DeliveryGuy ID int primary key, FirstName varchar, LastName varchar, Email varchar, Phonenumber varchar create table Oorder( Order ID int primary key Restaurant ID int, Customer_ID int, DeliveryGuy ID int, Note varchar, GetMethod varchar, Time date TotalPrice int, Coupon varchar, foreign key (Restaurant ID) references Restaurant (Restaurant ID), foreign key (Customer_ID) references Customer Customer_ID) foreign key (DeliveryGuy_ID) references DeliveryGuy (DeliveryGuy ID) create table Pickup ( Order_ID int primary key Status varchar, ScheduledTime date, RealTime date, foreign key (Order_ID) references Oorder (Order_ID) create table Delivery( Order_ID int primary key Status varchar, EstimateTime date, RealTime date, foreign key (Order_ID) references Oorder (Order_ID) create table Comment Comment ID int primary key, Order ID int, Star varchar, Text varchar, Time date, foreign key (Order ID) references Oorder (Order_ID) create table Menu Order ( Item ID int primary key, Order ID int, foreign key (Order ID) references Oorder (Order ID)