Lookup tables are simple tables—often only a single column—that contain a full listing of all of the valid entries for another table’s attributes. They’re often used to build drop-down menus in the final user interface.
- [Instructor] There is one additional type of table…that you might find useful in your database…that might not have turned up in your research,…but don't worry, they're actually very simple to create.…These tables are often referred to as lookup tables…or validation tables.…Lookup tables help support the business rules…that you established while gathering the requirements…for the system and they make sure that data…is entered consistently.…Essentially, the idea is that there will be many cases…when a valid input in one field will come from…a finite list of acceptable values.…For instance, in a table that stores customer…shipping addresses, there will only be…a small list of countries that will serve,…or when typing in a two-letter state abbreviation…we want to make sure that it's actually entered correctly…and represents a real state, and is not…just some random two-letter code.…
These types of lookup tables typically get implemented…as a drop-down list in the final user interface,…where you make selections rather than typing in a value.…
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.