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.
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.
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.