Join Adam Wilbert for an in-depth discussion in this video Understanding the first normal form (1NF), part of Database Fundamentals: Storage.
- Let's take a look at meeting the requirements…of the first normal form.…In order to get our table into 1NF…we need to make sure that it's in an entity format…and will remove repeating groups of values.…We could do this by ensuring that at least…one column will store a unique identifier for each record.…And then we'll remove the ability to store…multiple values in a single field,…or have repeating lists of the same kind of data.…Let's take a look at how we can do this in…Management Studio.…With the H Plus Active database selected…over here in the Object Explorer,…I'm going to come up and press the…New Query button here.…
We're going to use the data definition language…to explore the creation of a customers table,…and we'll walk it through the steps…of normalizing the table.…I'm going to start with the keywords Create Table.…And the name of the table is going to be Customers.…I'll go ahead and Type in the open parentheses…and then come down a few lines by pressing Enter…and type in the the closing parentheses…and the finishing semi colon.…
Note: This course will also prepare certification candidates for the "Understanding data storage" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals. Find out more at https://www.microsoft.com/learning/en-us/exam-98-364.aspx.
- Reducing redundancy with normalization
- Fixing partial dependencies
- Creating primary keys
- Linking tables with foreign keys
- Creating clustered and nonclustered indexes