Naming conventions ensure that objects, including tables and fields, are consistently named throughout your database project. This makes things easier to understand and maintain.
- [Instructor] We've now got a good plan in place…for how our database needs to function.…The next step of the process…is to start thinking about…how to actually implement the plan…in our relational database management system of choice.…I've created a Table Design Worksheet…that you can print out for each of the tables…identified in your data model,…to help you keep track of…the decisions and changes that we're going to be making.…These Table Design Worksheets…will help you out when it comes time to…implementing the design in the RDBMS,…it'll help make up an important component…of your database blueprint.…The first step of the process…is to be explicitly clear…in how we're going to name…the various tables and attributes…that we're about to create.…
Proper naming of your tables and fields…provides a sort of self-documenting feature…of your completed system.…Such as they can aid someone that comes after you,…that needs to maintain your database.…Or, even help you remember what it was…that your were doing six months from now,…
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.