Join Simon Allardice for an in-depth discussion in this video Database denormalization, part of Programming Foundations: Databases.
- So we should always take our database design…through the First, Second, and Third Normal Forms.…There are more criteria available.…There are Fourth, Fifth, and Sixth Normal Forms.…There's something called Boyce-Codd Normal Form,…but taking it to Third Normal Form…is the usual expectation in a business environment…and certainly all we need to cover…in a course like this one.…And you will actually find that a lot of tables out there…intentionally break normalization rules…and some others seem like they do, but they actually don't.…
Here's one example.…Let's say we've got an Employee table…and I'm storing an email and a phone number.…Well, what happens if I want to add…another email address, another phone number?…Technically this can be described as…breaking First Normal Form.…It's a repeating group.…But in practice, you may find it…more convenient to just allow an Email,…and Email2 column, or perhaps a home phone…and mobile phone column, rather than splitting…everything out into multiple tables…and having to follow relationships…
Author
Released
9/30/2015- What is a database?
- Why do you need a database?
- Choosing primary keys
- Identifying columns and selecting data types
- Defining relationships: one-to-one, one-to-many, and many-to-many
- Understanding normalization
- Creating queries to create, insert, update, and delete data
- Understanding indexing and stored procedures
- Exploring your database options
Skill Level Appropriate for all
Duration
Views
Related Courses
-
Programming Foundations: Design Patterns
with Elisabeth Robson2h 19m Intermediate
-
Introduction
-
Welcome1m 2s
-
What you need to know1m 14s
-
-
1. Understanding Databases
-
What are databases?7m 41s
-
-
2. Database Fundamentals
-
Defining table relationships5m 33s
-
3. Database Modeling: Tables
-
Planning your database5m 45s
-
Choosing primary keys1m 45s
-
Using composite keys2m 4s
-
4. Database Modeling: Relationships
-
Creating relationships2m 38s
-
-
5. Database Modeling: Optimization
-
First normal form4m 5s
-
Second normal form4m 29s
-
Third normal form4m 34s
-
6. Database Modeling: Querying
-
Creating SQL queries5m 34s
-
Structuring the WHERE clause6m 24s
-
Sorting query results2m 37s
-
Using aggregate functions4m 49s
-
Joining tables6m 54s
-
The data definition language4m 50s
-
-
7. Database Modeling: Indexing and Optimization
-
Understanding indexes9m 24s
-
-
8. Database Options
-
Desktop databases5m 13s
-
NoSQL databases8m 59s
-
-
Conclusion
-
Final thoughts50s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Database denormalization