Interviewing specific people within an organization who are members of each actor group allows you to fine-tune your understanding of the database’s requirements.
- [Instructor] So far you've laid out the mission goals,…taken a look at the current system of record-keeping,…and identified the key actors in the tasks…that need to be performed.…At this point, you're ready to dig into…the detailed nuance of how the system you're about to build…needs to function.…For this, you're going to have to become an expert…in all of the various facets of the real world system…that you're trying to model.…What we're after is a complete understanding…of the data items that need to find a home…in your new database.…To do that, we're going to get help from specific members…of the actor's groups that you identified in the last movie…and conduct interviews.…
The specific people that you're looking to get in touch with…are the ones with the most knowledge…of both how their current system operates…and how the system should operate in an ideal world.…In some businesses, you'll have identified…subject matter experts that are the go-to person internally…for questions on each segment of the business.…
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.