Jan 12, 2015
In the first part of the series, we looked at normalising into first normal form (1NF). In this article, the second part of the 3-part series, we focus on second normal form. Recall the general requirements of 2NF:- Remove subsets of data that apply to multiple rows of a table and place them in separate tables.
- Create relationships between these new tables and their predecessors through the use of foreign keys.
- CustNum
- FirstName
- LastName
- Address
- City
- State
- Postcode
- ZIP
- City
- State
- CustNum
- FirstName
- LastName
- Address
- ZIP
How do your Excel skills stack up?
Test NowNext up:
- Using Outlook flags and categories to manage emails
- Rich dad’s antidote for distractions
- Are you using the right colour?
- Using cross-domain library with SharePoint 2013 apps
- Reduce your PDF file size in Acrobat XI
- Monitoring user connections to Office 365
- New Horizons' top 10 blog posts of 2014
- The science of presenting (Part 1)
- Microsoft Sway - Will you be swayed?
- 5 super cool technology gadgets from the past...
Previously
- Setting up Outlook 2013 to suit your personal needs
- Designing business continuity management strategies in SharePoint 2013
- The five stages of competence
- Compact and repair an Access database
- Say goodbye to an old friend – and other end of life facts
- So long 2014, hello 2015!
- Beguile for a while with a smile
- Use the Eyedropper tool in PowerPoint 2013
- Happy Holidays from New Horizons!
- Implementing external content types in SharePoint 2013