Course Details

3 credits

Database Design

The information shown on this page is simply that, information. This information is related only to this course in general, not to a specific class or instance of this course that is being offered. The labs shown on this page are those that I have created for this course, they are not those that are specifically assigned. For actual class information, the information that my current students should be looking at, return to the homepage and choose a currently offered class.

Course Description

Course covers the design and creation of relational databases using the Structured Query Language including performing analysis of data needs, establishing table structures, defining and working with keys, defining field specifications, establishing and working with table relationships, defining business rules, creating views, and managing data integrity.

Objectives

  1. Students should be able to generate mission objectives and subjects for a data storage need
  2. Students should be able to develop correct lists of tables and fields based on objectives and subjects
  3. Students should be able to determine candidate and primary keys
  4. Students should be able to distinguish relationships that exist between entities
  5. Students should be able to generate business rules and needed views for a database
  6. Students should be able to evaluate data integrity
  7. Students should be able to evaluate various aspects of database security
  8. Students should be able to generate a database

Potential Assignments