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

karlynnae · **on:** Jul 7, 2018

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?

kaykay69 · **Reply #1 on:** Jul 7, 2018

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.