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 61 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
Thanks for the timely response, appreciate it


epscape

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

The most common childhood diseases include croup, chickenpox, ear infections, flu, pneumonia, ringworm, respiratory syncytial virus, scabies, head lice, and asthma.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

For a complete list of videos, visit our video library