Question: Create a Database order Information, or any suitable name. Produce sample records for each table that observes the Referential Integrity Constraint. FIVE records per table

- Create a Database order Information, or any suitable name.
- Produce sample records for each table that observes the Referential Integrity Constraint. FIVE records per table are enough. The data inserted must satisfy the following constraint:
- there are at least 3 restaurants and each restaurant have at least serve 2 foods
- each customer can makes one or more order and the order can be have more than one foods
- make sure you create the relationships between tables
REQUIREMENT A Food Delivery System allows customer to place food order online and will be delivered by the restaurant via dispatch services. The schema of the database is provided below: CUSTOMER CustID, CustName, CustAddress, CustPhone, CustEmail RESTAURANT RestID, RestName, RestAddress, RestPhone, RestEmail, RestPIC FOOD FoodID, FoodName, FoodType, Food Menutype, FoodExpiry Hour, FoodPrice, RestID ORDERLIST Order_ID, Order Date, OrderQty, Order Amount, FoodID, CustID [Primary key is underlined, foreign key is dotted underlined] Take note: Food type refers to the food main ingredient such as chicken. Food menu type refers to the style of cooking such as western
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
