Join Adam Wilbert for an in-depth discussion in this video Identifying key fields, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…One of the important restrictions that are placed on our data…tables, is that every row or record must be uniquely identifiable.…There has to be one piece of information that you…can use to identify exactly one record, with absolutely no ambiguity.…This particular field is called the table's primary key.…And it's the value that we'll use when it…comes time to link our related data tables together.…Let's suppose on of your customers has an issue with a product he ordered.…We can go to an orders table to look up…the information about transaction, but how do we find it?…The customer first gives us their name which will…show us all the transactions that they've completed with us.…
Hopefully it's a bunch.…This is good to know but it doesn't find us a specific transaction.…They can tell us the date they placed the order but again, that would return…all of the orders placed on the same date and not identify their own specifically.…This is why we have something like an invoice number column.…It helps us uniquely identify a specific transaction in our table.…
- What is a database management system (DBMS)?
- Moving through the database development cycle
- Preventing duplicate, inconsistent, and conflicting data entries
- Gathering requirements
- Developing relationships
- Identifying key fields
- Following a naming convention
- Developing the actual database
Skill Level Beginner
FileMaker Pro 12 Essential Trainingwith Cris Ippolite10h 28m Beginner
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
1. Relational Database Basics
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.