CS 275 Introduction to Database Systems and Modeling

This is an introduction to production- scale, relational database environments. Included in the course are discussion and application of database models, entity relationship design, normalization, and an introduction to SQL Query usage and development.

Credits

4

Prerequisite

Placement into MTH 095 or higher

Course Learning Outcomes

Upon successful completion of this course, the student will be able to:
1. Identify and explain current data base models and their underlying advantages and disadvantages
2. Design a moderately complex database structure using Entity-Relationship diagrams
3. Use Normalization techniques for database design
4. Define and write database queries to extract data from multiple tables using SQL
5. Create database tables, and insert and update data into the tables using SQL
6. Identify and describe issues concerning enterprise-level processing by a Database Management System