print
Course Name
Database Design Concepts

Contact Hours: 4
Course Description
This course provides an introduction to relational database management systems. The series covers basic types of databases, data integrity, the relational model, entity relationship modeling, normalization, and performance measurement.

  1. Exercises allow learners to practice in the actual application being studied.
  2. A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  3. Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  4. Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  5. Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  6. A skill assessment generates a customized learning path based on the results of a pre-test.
  7. A glossary provides a reference for definitions of unfamiliar terms.
  8. Bookmarking tracks the learner's progress in a course.
Outcome
  • Describe databases and database management systems
  • Explain relational database management systems
  • Design simple database models using Entity-Relationship Modeling
  • Normalize a database
  • Measure the performance of a database
  • Estimate the storage needs of a database
  • Explain the reasons for and pitfalls of denormalizing a database
Assessment
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank. A skill assessment generates a customized learning path based on the results of a pre-test.
Outline
  1. Understanding Databases
  2. Relational Database Management Systems
  3. Entity-Relationship Models (ERDs)
  4. Understanding Normalization
  5. Planning and Management