Please include information about what type of relationship does INVOCE AND PRDUC

Question

Please include information about what type of relationship does INVOCE AND PRDUCT have (one to many, many to many etc) also talk about us there is any foreign keys and primary keys Looking at the following Image, please explain all aspects of the relationship between INVOICE and PRODUCT SEMINAFR CUSTOMER EmailAddress SeminarlD SeminarDate SeminarTime Location SeminarTitle LastName 04 FirstName Phone StreetAddress City State ZIP CONTACT EmailAddress ContactDate 70ContactNumber ContactType INVOICE LINE ITEM InvoiceNumber LineNumber PRODUCT ProductNumber Description InvoiceNumber InvoiceDate PaymentType Subtotal Shipping Tax Total Quantity UnitPrice Total o-UnitPrice TTI QuantitynHand Copyright 02013 Pearson Education, publishing as Prentice Hall

Explanation / Answer

The tables INVOICE and PRODUCT have a many-to-many relationship between them, as there is a junction table between them, which is LINE_ITEM.

A many-to-many relationship exists between two tables if for one entity there may be one or more records in the other table and vice versa.

There are two primary keys in the two tables, one each for tables INVOICE and PRODUCT. For table INVOICE, the primary key is InvoiceNumber and for table PRODUCT, primary key is ProductNumber.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---