From the course: Database Foundations: Data Structures
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Denormalization considerations
From the course: Database Foundations: Data Structures
Denormalization considerations
- [Instructor] The rules of good database design outlined as the three normal forms should be treated as guidelines that'll help you arrive at a solid foundation for your data tables. But they're not something that needs to be strictly adhered to in all circumstances. The process of reversing or ignoring the normal forms is called denormalization. Denormalization should be approached deliberately. It's not just a free pass to go back to creating tables how ever you want. If we consider the locations table that we created while normalizing our pet and orders database, you'll find an opportunity to restructure this a little bit further. Given a large enough database, it's likely that we'll have several people that all live in the same city, state, and country. We could break that information out into its own tables, and create a lookup table of cities. Going another step further, we'll have several cities in the same state…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.