Join Martin Guidry for an in-depth discussion in this video Using third normal form, part of SQL Server 2012: Designing Database Solutions.
- In this section, I'd like to talk about…Third Normal Form.…In order for our database to be in Third Normal Form,…we first need to be in Second Normal Form.…And additionally, we need to have no caluclated columns…in the database.…So let's look at an example of a calculated column.…Here in a hypothetical table called,…"OrdersLineItem,"…for each line item we store the price…and the quantity ordered…and what that totals out to.…So, for the first line,…$25.00 per shirt, someone ordered 3 shirts...…
So for the total for that line item is $75.00.…Storing the total here, to me, isn't a huge mistake.…But there are some issues.…If we ever wanted to go back and…change the price or the quantity,…then you would also have to change the total…and we'd like to avoid that.…We don't like to have to change two things at once.…And also storing the total could be…looked at as wasted space.…Because if we ever need that piece of information,…we could always compute it on the fly.…We'll assume this database is supporting…some line of business application.…
- 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.