Relational Database Design: A Practical Approach (Millennium Design)

Course specifications

Course number: 076 410

Software version number:

Course length: 1 day

Hardware/software required to run this course

The conceptual content of this course in not specific to any software application. Microsoft Access 97 or Access 2000 is needed to perform the tasks in the lessons pertaining to queries.

Course description

Overview: Students will learn the general principles involved in designing a database that complies with the relational database model.

Prerequisites: Some familiarity with data tables and basic knowledge of how to create queries in Access 97 or Access 2000.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on and minds-on activities.

Benefits: Students will learn how to correctly design tables for use in a relational database application.

Target student: Students enrolling in this course should have a need to design or modify the design of tables to be used in a relational database management system.


Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:


Course content

Lesson 1: Introduction to Relational Databases

Lesson 2: Designing Tables

Lesson 3: Data Normalization

Lesson 4: Data Integrity

Lesson 5: Query Basics

Lesson 6: More on Queries

Appendix: Additional resources