Course Description
Involves the study of generalized database management systems. The study will include logical data base models and physical base models based primarily on the relational model. The students will create a database utilizing an established database management system. The focus is on issues and principles of managing organizational data. Students will get extensive experience in developing data models, creating relational databases, and formulating and executing queries based on business applications.
Course Outcomes
Students who successfully complete the course should be able to do the following:
- Acquire and analyze data requirements in business
- Develop entity-relationship models from requirements
- Design, implement, and manage relational databases
- Normalize databases to remove anomalies
- Retrieve and manipulate data using structured query language (SQL)
