Question: I. (10 points) Identify the primary key and foreign key for the relations below for a company that runs a The RESTAURANT numbers. That is

 I. (10 points) Identify the primary key and foreign key for

I. (10 points) Identify the primary key and foreign key for the relations below for a company that runs a The "RESTAURANT" numbers. That is to say, invoice numbers are only unique within a restaurant relation records information of restaurants. The "DISH" relation records information of dishes off by the company. The "CUSTOMER" relation records customer information. The"NVOCE" relation records overall information of invoices such as date, time, and total amount paid. Ihe "ININVOICE" relation records each dish in invoices. restaurant chai in. The company has many restaurants. Each restaurant maintains its own invoice RESTAURANT (RestaurantNo, Name, Address, Phone) DISH(Dishld, Name, Price, Long Desc) CUSTOMER(CustomerNo, Name, Address, Phone, Email) INVOICE(InvoiceNo, RestaurantNo, CustomerNo, Date, Time, TotalAmount) ININVOICE(InvoiceNo, RestaurantNo, Dishld, Quantity, Price) Table Primary Key oreign Key able Referenced ESTAURANT ISH USTOMER NVOICE NINVOICE

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!