Purchase Solution

Question 11. What are "referential integrity constraints"? P

Not what you're looking for?

Ask Custom Question

Question 11.
What are "referential integrity constraints"? Provide an example.
Question 12.
What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

Attachments
Purchase this Solution
Solution Summary

Question 11.
What are "referential integrity constraints"? Provide an example.
Question 12.
What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems?

Solution Preview

Question 11.
What are "referential integrity constraints"? Provide an example.

A referential integrity constraint is a value that "appears in one relation for a given set of attributes and also appears for a certain set of attributes in another relation" (GreenWebHost, 2011).
Essentially, they are rules that make up the database table scheme, which can accept nulls. The referential integrity constraint can happen in almost any data model, and specifies three key pieces of information. The first factor it identifies is the principal end of the constraint, which is the entity type, "Whose entity key is referenced by the deepest end" (Microsoft, 2012). Other factors it identifies include the entity key of the principle end of the association involved in the referential integrity constraint, and the dependent end of the constraint. The dependent end of the constraint is the entity type that symbolizes the entity key at the principal end. The fourth relevant factor identified is the referencing property on the dependent end of the association.
An example of a referential integrity constraint is a setup where customers are each assigned a specific number that is located in the master ...

Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Introduction to Finance

This quiz test introductory finance topics.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Rules of Referential Integrity and Overriding

    It shows what the rules in order to enforce referential integrity constraints and also how to overiride these constraints as may be needed in some cases.

  • Enforcing Referential Integrity Constraints

    142801 Enforcing referential integrity constraints Describe the default rules for enforcing referential integrity constraints. Explain how referential integrity actions can be used to override the default referential integrity constraints.

  • Data Integrity Categories

    Domain integrity restricts types, formats, and ranges of possible values. Data types restrict data, CHECK constraints restrict formats, and CHECK constraints, DEFAULT definitions, or NOT NULL definitions restrict the range of possible values.

  • Relationships for any referential integrity violations.

    Referential Integrity Check Question 1 - Given the following data types of some table fields and the simple schema of the relational database they are a part of, inspect its relationships for any referential integrity violations.

  • Key Concepts that Support Data Integrity in a Database

    What are the disadvantages? How do integrity constraints impact the overall application design? Data Integrity is an umbrella term that refers to the consistency, accuracy, and correctness of data stored in a database.

  • supporting data integrity in a database

    24328 SQL Commands Explain the key concepts that are involved in supporting data integrity in a database. How is integrity enforced? What are the advantages of enforcing integrity? What are the disadvantages?

  • Entity integrity and Referential integrity in a database

    80514 What are entity integrity and referential integrity? What are entity integrity and referential integrity? Why are they important for relational databases? Please provide examples to support your answers.

  • Database Constraints

    What are the long-term problems when these constraints are not implemented? Student, Your answer is in the attached Word Doc as the code requires formatting.

  • Database system and effective internal control system

    There are three database characteristics - entity integrity, domain integrity, and referential integrity - that help companies have effective internal control systems.

View More Related Solutions