Relational Database Design (Third Edition)
Course Specifications
Course number: 085986
Software: MySQL
Course length: 1.0 day(s)
Course Description
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. 
Course Objective: You will design and create a relational database.

Target Student: Individuals who are able to write simple queries or run queries that someone else has designed.

Prerequisites: Microsoft Access 2007 Level 1 (Second Edition) course (recommended).

Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Hardware Requirements
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components: 
•	Minimum 250 MB hard disk space for installation of MySQL. 
•	128 MB RAM or higher. 
•	Intel/Celeron (or similar) processor with minimum 300 MHz clock speed. 
•	CD-ROM drive. 
•	Mouse or other pointing device. 
•	1024 x 768 resolution monitor recommended. 
•	An Internet connection. 
•	Projection system to display the instructor's computer screen. 
Platform Requirements
•	Windows XP Professional. 
Software Requirements
•	Microsoft Windows XP Professional (SP2) or Microsoft Windows 2000 (SP2), both 32 bit. 
•	MySQL Server 5.0. 
•	MS Office. 
Performance-Based Objectives
Upon successful completion of this course, students will be able to: 
•	analyze client requirements. 
•	create a preliminary design. 
•	implement the database design. 
•	generate reports. 
•	customize a database. 
Course Content
Lesson 1: Analyzing Client Requirements 
Topic 1A: Analyze Current Data Storage Systems 
Topic 1B: Identify New Client Requirements 
Topic 1C: Determine the Required Data Fields 
Topic 1D: Group Fields into Tables 
Topic 1E: Identify Key Fields
Lesson 2: Creating a Preliminary Design 
Topic 2A: Create a Preliminary Entity Relationship Diagram 
Topic 2B: Apply the First Normal Form 
Topic 2C: Apply the Second Normal Form 
Topic 2D: Apply the Third Normal Form 
Topic 2E: Apply the Higher Normal Forms 
Topic 2F: Denormalize Tables 
Topic 2G: Incorporate Client Feedback
Lesson 3: Implementing the Database Design 
Topic 3A: Translate Business Rules into Constraints 
Topic 3B: Create Tables 
Topic 3C: Create Indexes
Lesson 4: Generating Reports 
Topic 4A: Manipulate Data 
Topic 4B: Generate Reports Using Conditions 
Topic 4C: Generate Reports from Multiple Tables 
Topic 4D: Generate Summary Reports 
Topic 4E: Create Views
Lesson 5: Customizing a Database 
Topic 5A: Modify Constraints 
Topic 5B: Modify Fields 
Topic 5C: Modify Tables