Overview

Overview

Now that you've gotten a taste of the power provided by relational databases to answer questions, let's shift our attention to the dirty work: designing, implementing, populating and maintaining a database.

Objectives

At the successful completion of this lesson, students should be able to:

• design a relational database and depict that design through an entity-relationship diagram;
• create new tables in MS-Access;
• develop and execute insert, update and delete queries in MS-Access;
• describe what is meant by 1st, 2nd and 3rd normal forms in database design;
• explain the concept of referential integrity.

Questions?

If you have any questions now or at any point during this week, please feel free to post them to the Lesson 2 Discussion Forum.