At work, storing and accessing data are part of a person’s day-to-day activities. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a simple relational database application and its associated tools. You have used databases to store and retrieve data. Now, you may want to plan and design your own database. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying relational database design techniques.
You will design and create a relational database.
Individuals who are able to write simple queries or run queries that someone else has designed.
Microsoft Access 2003 or 2007 Level 1 course or equivalent is recommended.
Analyzing Client Requirements
- Analyze Current Data Storage Systems
- Identify New Client Requirements
- Determine the Required Data Fields
- Group Fields into Tables
- Identify Key Fields
Creating a Preliminary Design
- Create a Preliminary Entity Relationship Diagram
- Apply the First Normal Form
- Apply the Second Normal Form
- Apply the Third Normal Form
- Apply the Higher Normal Forms
- Denormalize Tables
- Incorporate Client Feedback
Implementing the Database Design
- Translate Business Rules into Constraints
- Create Tables
- Create Indexes
- Manipulate Data
- Generate Reports Using Conditions
- Generate Reports from Multiple Tables
- Generate Summary Reports
- Create Views
Customizing a Database
- Modify Constraints
- Modify Fields