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.