Join Adam Wilbert for an in-depth discussion in this video Drafting the initial data model, part of Relational Database Fundamentals.
- View Offline
- Exercise Files
…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 we'll need for the relational database management system.…You've seen some techniques for exploring the 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 will make up your final database.…But don't get too hung up about getting it perfect at this stage.…
The important part is to start getting the design down on…paper, so that you can step back and see the bigger picture.…We'll continue to refine the layout and the relationships in…the next chapter as we run through our process called normalization.…Remember, this is an iterative project.…Sometimes you'll discover new entities and relationships…
- 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.