With a comprehensive list of data elements that need to be stored, those elements will need to get grouped into the structure required for a relational database. Using a data model can help visualize the tables, fields, and attributes that need to get cre
- [Narrator] Now that we have a…pretty comprehensive list of data elements…that we need to store, it's time to…start organizing them into the…structures that we'll need to go in the database.…By doing so, we're going to start building…what's called a data model.…A data model is a graphical representation…of the elements that make up…the overall database's design.…It's the construction blueprint…that we've been working towards.…The data model will also help us…visualize the tables, fields, and…the relationships that will allow the database…to both store and retrieve information very efficiently.…Tables represent the various types of…entities that we want to keep track of in the database.…
And records or rows in those tables…hold information about a single person,…place, thing, or event.…In order to discover the tables that we need to create.…We need to take a close look at the…field list that we generated in the last chapter…and start organizing them into…logical groupings of entities or subjects.…As you start to scan through the fields…
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.