What are "referential integrity constraints"? Give an example
What will be an ideal response?
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.
You might also like to view...
Which of the following is NOT a work-related pressure?
a. fear of losing one's job b. wanting to appear successful c. getting overlooked for a promotion d. insufficient/little recognition for work performance
Decreases in taxes lead to decreases in disposable income.
Answer the following statement true (T) or false (F)
The risk that is limited to a particular industry is also known as _____.?
A. ?unsystematic risk B. ?non-diversifiable risk C. ?market risk D. ?relevant risk E. ?combined risk
In 2008, BlackBerry's market cap peaked at $75 billion. By 2017 this valuation had fallen more than 90 percent, to $3.9 billion. BlackBerry fell victim to two important PESTEL factors in its external environment: sociocultural and technological. How did technology contribute to BlackBerry's decline?
A. BlackBerry failed to adapt to a groundswell that involved workers bringing mobile devices to work. B. BlackBerry failed to produce an efficient emailing system using a keyboard. C. BlackBerry failed to offer strong security features for its device. D. BlackBerry failed to change its device into one that could perform multiple tasks effectively.