Relational Database Design
For many new or intermediate database developers, it's difficult to know where to start when designing a relational database. It's easy to make the mistake of assuming that the functionality of a database will take shape over time, or the design will fall into place as you build the database. This course covers the steps to effectively plan and design functional, efficient databases.
You will plan a relational database so that you have a database that is efficient and easy to maintain.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
Upon successful completion of this course, students will be able to:
- Gather information to plan a relational database.
- Identify relationships between tables.
- Normalize data.
- Ensure data integrity.
- Determine queries needed for the database.
Outline
- Lesson 1: Gathering Information to Plan a Relational Database
- Topic 1A: Determine Database Purpose
- Topic 1B: Create a Preliminary Field List
- Topic 1C: Determine Fields
- Topic 1D: Group Fields into Tables
- Lesson 2: Identifying Relationships
- Topic 2A: Designate Primary Key Fields
- Topic 2B: Identify Table Relationships
- Lesson 3: Normalizing Data
- Topic 3A: Normalize to the First Normal Form
- Topic 3B: Normalize to the Second Normal Form
- Topic 3C: Normalize to the Third Normal Form
- Topic 3D: Normalize to the Higher Normal Forms
- Lesson 4: Ensuring Data Integrity
- Topic 4A: Ensure Consistent Data
- Topic 4B: Prevent Field Data Errors
- Lesson 5: Determining Queries
- Topic 5A: Determine Select Queries
- Topic 5B: Determine Calculations
- Topic 5C: Determine Action Queries
- Topic 5D: Improve Query Performance
- Topic 5E: Test Queries
- Appendix A: Additional Resources
- Appendix B: Query Criteria