Database ManagementThis 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.