Normalization is a series of rules that your database’s table structure must pass in order to be considered a good relational design. First normal form—or what is sometimes abbreviated as 1NF—requires that all fields only include a single piece of data.
- [Instructor] By now you should have a good idea…of all the tables that you'll need to store your data…as well as the individual fields or columns…that'll be in those tables, including the primary keys.…Now comes the process of adding additional tables…and fields that will be required by the DBMS…to do its job efficiently.…This is a process called normalization.…Normalization is a series of rules…that your database's table structure must pass…in order to be considered a good, relational design.…The individual rules are called normal forms…and they must be tested in order, like passing…through a series of gates or checkpoints.…
In other words, you can't satisfy the requirements…of the second normal form without first satisfying…the requirements of the first normal form.…Now, you might have actually accomplished…some of these checks earlier in the process…without realizing it.…There are multiple ways to identify the issues…that we're about to look for,…but it's always a good idea to go through…a formal normalization procedure…
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.