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.