Join Adam Wilbert for an in-depth discussion in this video Third normal form, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…The third normal form follows a similar pattern to…the second normal form but instead of checking against…the individual components of a composite primary key, we'll…check each non-key column against every other non-key column.…Here, we're looking for columns that are functionally dependent…on another piece of information that isn't the primary key.…This often occurs when two fields are simply…stating the same thing in a different way.…For instance, you might try and store…state and state abbreviation in an address table.…Since state abbreviation is entirely dependent on the state, or vice…versa, one of those two fields should be removed from the table.…
Here's another example using our explore California tour company.…In the table about the various tour…packages, we are storing a difficulty rating…as both a numeric rating and a text description of what that number means.…You can see that a difficulty at easy should always correspond to a rating…of one and a difficulty of difficult,…should always correspond to a rating of five.…
- 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.