This topic contains a solution. Click here to go to the answer

Author Question: What relationship pattern is illustrated in the following schema? PRODUCT (ProductID, Description) ... (Read 57 times)

karlynnae

  • Hero Member
  • *****
  • Posts: 599
What relationship pattern is illustrated in the following schema? PRODUCT (ProductID, Description) SUPPLIER (SupplierID, ContactName, PhoneNumber) PRODUCT_SUPPLIER (ProductID, SupplierID, Cost) ProductID in PRODUCT_SUPPLIER must exist in ProductID in
 
  PRODUCT SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCTA) Association relationship
  B) Intersection relationship
  C) Recursive relationship
  D) Strong entity relationship
  E) Supertype/subtype relationship

Question 2

What are referential integrity constraints? Give an example.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

kaykay69

  • Sr. Member
  • ****
  • Posts: 322
Answer to Question 1

A

Answer to Question 2

A referential integrity constraint is a rule that restricts certain actions on the database data. A referential integrity constraint is used to ensure that the values in a field in one table have matching values in a corresponding field in another table. These constraints are enforced by the DBMS, which will not allow changes to the values of the database that would result in violations of this rule. For example, a database has an EMPLOYEE table and a VEHICLE table that are used to store data on employees and the vehicles that they are assigned to drive. The EMPLOYEE table has a column called EmployeeID that is used to distinguish one employee record from another. The VEHICLE table also has an EmployeeID column that is used to associate a vehicle with the appropriate employee. A referential integrity constraint could be used to prevent a vehicle from being assigned to an employee with an EmployeeID that does not appear in the EMPLOYEE table by requiring that all values in EmployeeID in the VEHICLE table have a matching value in EmployeeID in the EMPLOYEE table.




karlynnae

  • Member
  • Posts: 599
Reply 2 on: Jul 7, 2018
Gracias!


parker125

  • Member
  • Posts: 332
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

HIV testing reach is still limited. An estimated 40% of people with HIV (more than 14 million) remain undiagnosed and do not know their infection status.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

For a complete list of videos, visit our video library