Join Adam Wilbert for an in-depth discussion in this video Enforcing referential integrity, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…One of the ways that we can prevent invalid entries in a child table is by…placing a specific kind of data constraint on…the relationship between the child table and the parent.…This constraint is called referential integrity.…Referential integrity ensures that related records in the child…table actually point to something in the parent table.…Let's take a look at an example of how this works.…Here we have our Employees table, and the…Departments table, which have a one-to-many relationship between them.…Each employee is supposed to point to a single…department, but here's the problem, our database is not…currently set up to protect us from erroneous data…getting entered into the department field in the Employees table.…
For instance, we can create a reference to a department that doesn't exist.…Such as if we add someone to the Maintenance Department.…When this occurs, we have what is called an orphaned record.…This means this particular line item doesn't refer to…any department at all, which is clearly a problem.…
- What is a database management system (DBMS)?
- Moving through the database development cycle
- Preventing duplicate, inconsistent, and conflicting data entries
- Gathering requirements
- Developing relationships
- Identifying key fields
- Following a naming convention
- Developing the actual database
Skill Level Beginner
FileMaker Pro 12 Essential Trainingwith Cris Ippolite10h 28m Beginner
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
1. Relational Database Basics
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.