Internet Explorer in all versions is a dangerous browser. It has many deficiencies and security vulnerabilities that make it unsafe.
You should instead use a current version of Chrome or
Firefox if you're using windows or Safari for the Mac.
This site will not function properly in Internet Explorer. Emails will not be sent, downloads will not function, assignments will not be
submitted...
3 credits
Database Design (Online)
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 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
Students should be able to describe the current database design methodology
Students should be able to write mission statement and objectives
Students should be able to develop correct lists of tables and fields
Students should be able to determine candidate and primary keys
Students should be able to construct proper field specifications
Students should be able to distinguish relationships that exist between entities
Students should be able to generate business rules and needed views for a database
Students should be able to evaluate data integrity
Students should be able to evaluate various aspects of database security
Students should be able to generate a database using SQL