RSEG 170

Database Management

This course covers data modeling, including relational, object-oriented, and object-relational database design concepts and issues. Concepts addressed include relational theory and database design; entity relationship modeling; normalization; issues of design and implementation; issues of database integrity, security, recovery and concurrence; and object-oriented databases.

At the end of the course, students will be able to:

  • Identify and clearly document business requirements and proposed solutions.
  • Define database requirements and design an entity-relationship diagram.
  • Create a conceptual model from an entity-relationship diagram.
  • Translate a conceptual model into a physical design.
  • Apply knowledge of DDL to create a set of tables from a physical design.
  • Develop a set of class diagrams for an object-oriented database design.
  • Code ODL scripts to create a set of tables based upon class diagrams.
View course prerequisites.