At this point, you should have a good foundation in understanding how to start taking the field list of items you’ve discovered through the requirements gathering phase, and be able to begin grouping them into the tables you'll need for the relational dat
- [Instructor] At this point, you should have…a good foundation in understanding how…to start taking the field list…of items that you've discovered through…the requirements gathering phase…and be able to begin grouping them…into the tables that we'll need…for the relational database management system.…This will serve as the first draft…of your data model.…You've seen some techniques for exploring…the table relationships to each other…and how to bring in additional tables…that will make the database run smoothly.…So go ahead and start organizing your tables…into a data model and begin to think…about the relationships between…the various entities that'll make up your final database.…
But don't get too hung up about making…it perfect at this stage.…The important part is to start getting…the design down on paper so that you can take…a step back and see the bigger picture.…We'll continue to refine the layout…of the relationships in the next chapter…as we run through a process called normalization.…Remember, this is an iterative process.…
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.