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

  1. Create a Database order Information, or any suitable name.
  2. 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:
    1. there are at least 3 restaurants and each restaurant have at least serve 2 foods
    2. each customer can makes one or more order and the order can be have more than one foods
    3. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!