1-1-11 Heading 11nNormal!!NoSpaci Heading 2 Title Font Paragraph Styles 2) Consi

Question

1-1-11 Heading 11nNormal!!NoSpaci Heading 2 Title Font Paragraph Styles 2) Considerthe following relations for a database that keepstrack of customers, products invoices, and lines (a line on an invoice refers to a product). Assume that an invoice can have many lines and that a customer can have many invoices: (5 points) CUSTOMER(Cus Code Cus Name Cus Phone) PRODUCT Prod Code Prod Name,Prod Descript,Price) INVOICE(Inv Num,Cus Code,Inv Date,Inv Total) LINE Unv Num, Line Num,Prod Code Units Price) Assume that a car can have multiple options and that a salesman can sell many cars. In the following table, specify the primary and foreign keys for each relation. If a table does not have a foreign key, write"none Table Primary Key Foreign key CUSTOMER PRODUCT INVOICE UNE P.

Explanation / Answer

Table Primary Key Foreign Key Customer Cus_Code None Product Prod_Code None Invoice Inv_Num Cus_Code Line Line_Num Inv_Num

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.