List foreign key constraints that this database should have. Your answer should indicate the referencing table (the one in whose table definition the constraint should be included), the referenced table, and the attribute(s). You may use a format like the following without writing out the whole table definition or keywords FOREIGN KEY ...

Order. Phone REFERERENCES Customer. Phone

design  Relational Algebra query to find to find the lignums and streets of customers who have orders with status = "ready".

 

Transcribed Image Text:

Customer (phone, bldg Num, street, apt Num) Dish(item, description, category) Dish Size(item, size, price) Order (order Num, phone, order Date, status) Order Items (order Num, item, size, qty) Customer (phone, bldg Num, street, apt Num) Dish(item, description, category) Dish Size(item, size, price) Order (order Num, phone, order Date, status) Order Items (order Num, item, size, qty)

Answer rating: 100% (QA)

1 In the Order table there should be a foreign key constraint that references the Customer table o... View the full answer