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".

 

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)