Relational database management systems include functionality that allows you to force data entry on specific fields in a table by marking them as required or as NOT NULL.
- [Instructor] If you're anything like me,…I'm sure there have been plenty of times…when you're performing some data entry task…and you find that there's some piece of information…that you just don't know.…You think to yourself,…"I'll put in the parts that I know now,…"and I'll come back and fill in the rest later."…Only you get busy and you move onto other tasks,…and completely forget to fill in the blanks.…Unfortunately this happens all too often to a lot of people.…We've already seen that incorrect or mistyped data…is problematic for a database.…Almost as troublesome to the integrity of the system…is the case of missing or incorrectly entered data.…
Needless to say, when important pieces…of your data structure go missing,…your database will probably return…incorrect or misleading information.…Gone undetected, you might find that…important business decisions are being made…off of this erroneous information,…and that's never going to be a good thing.…Here's a quick look again at our invoices table.…We'll want to go through it column by column…
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.