A table is in second normal form if it passes 1NF, and all of the fields in a composite primary key are required to determine the other, non-key fields in a table.
- Second Normal Form or 2NF might be a relatively…easy gate to pass, depending on…how you set up your primary keys.…If all of your tables use only a single field or column…as their primary key then congratulations you've already…passed the requirements of 2NF.…If you're using a composite primary key though,…that's to say a primary key that requires two or…more fields than conjunction to uniquely identify a record…then we do have a little bit more work to do here.…A table is in Second Normal Form if all the fields…in the primary key are required to…determine the other non-key fields.…
Here's an example.…Here I have a table that is keeping track of…the individual LineItems for an invoice.…But it has a slightly different configuration…than the one that we previously see.…Here the Invoice Number and a Product Name are…composite keys that link to a specific order…that was placed and the specific item that was ordered.…The reason the composite key was chosen in this table was…so that we're protected from having two lines on…
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.