Join Martin Guidry for an in-depth discussion in this video Using second normal form, part of Designing Database Solutions for SQL Server 2012.
- View Offline
- Exercise Files
- Next, let's talk about Second Normal Form.…In order for a database to be in Second Normal Form,…it must first be in First Normal Form…and there is one additional criteria.…There can be no repeating data.…In other words, we can not store…the exact same piece of data twice.…So again, we'll look at an example…where this rule wasn't followed.…In this hypothetical database, we have the Orders table…and for every line item in the Orders table,…we list the Customer and their Address.…
So, you can see OrderID number 1…and OrderID number 3 both being shipped…to the same gentleman, John Doe at 100 Main Street.…Obviously, this is inefficient…to store the exact same data twice…and also will create problems…if we ever need to update the data.…If John Doe ever moves to a new address…and we want to update his record,…we would have to go back to every location…in the database where this is stored…and we may not know how many locations…or how many different places we have this data stored…and we'd have to update all of them.…
If we didn't update all of them,…
- Planning the database infrastructure
- Designing databases vs. data warehouses
- Designing the physical database implementation
- Planning for partitioning
- Adding FileStream data
- Monitoring server health
- Managing SQL Server with PowerShell
Skill Level Intermediate
1. Designing a Database Server Infrastructure
2. Designing a Logical Database Schema
3. Designing a Physical Database Implementation
4. Incorporating Data Files into Databases
5. Tuning Database Performance
6. Policy-Based Management
7. Monitoring Server Health
Exploring health data5m 3s
8. Managing SQL Server with PowerShell
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
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.