With integrity constraints, data validation can be performed as data is being entered into a table. With check constraints, the values are compared to a list of valid entries. And with a lookup table, the valid entries are stored in a small table that is
- One of the most important things…about having your data stored in a database…is being able to trust…that the data has been entered correctly.…The database management system…can protect you in a number of ways…from getting invalidated into…the database in the first place…through a series of rules called "integrity constraints".…Sometimes integrity constraints…are implemented through a new related data table.…For instance, when storing a two letter state abbreviation…you might refer to a separate state lookup table…to ensure that the entered value…appears in the table of valid state abbreviations.…
Lookup tables will include all of the valid choices…for a particular piece of data.…A second approach to the same problem…is to create what's called "a check constraint",…or in Microsoft Access it's known as a validation rule.…Here we can build the constraint…right into the design of the table itself…without needing any additional tables.…The advantage to this approach is, well,…one less table in your database.…The disadvantage is that if the constraint changes…
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
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.