Loading...
Please wait, while we are loading the content...
Similar Documents
Referential Integrity for Database Design
| Content Provider | Scilit |
|---|---|
| Author | Kim, Bonn-Oh |
| Copyright Year | 2021 |
| Description | Maintaining the integrity of data is one of the most critical issues involved in designing in database systems. In relational database systems, there are four common integrity constraints: The key constraint, which states that the values of a primary key must be unique, so there should be no duplicate primary key values. Entity integrity, which indicates that a primary key of a relation cannot take null values. Referential integrity, which is a constraint to ensure the existence of a tuple of a relation that is referenced by a tuple in another relation. Semantic integrity, which states that data in the database systems should be consistent or semantically correct. Book Name: Data Management |
| Related Links | https://api.taylorfrancis.com/content/chapters/edit/download?identifierName=doi&identifierValue=10.1201/9780429114878-22&type=chapterpdf |
| Ending Page | 232 |
| Page Count | 8 |
| Starting Page | 225 |
| DOI | 10.1201/9780429114878-22 |
| Language | English |
| Publisher | Informa UK Limited |
| Publisher Date | 2021-12-06 |
| Access Restriction | Open |
| Subject Keyword | Book Name: Data Management Referential Integrity Primary Key Semantically Duplicate Referenced Designing in Database |
| Content Type | Text |
| Resource Type | Chapter |
