CS 275 Database Systems

Introduces the design, purpose and maintenance of a database system. Topics covered include the entity-relationship (ER) model, relational systems, data definition, data manipulation, query language and database management environments.

Credits

4

Prerequisite

Prerequisite: CS 161 Introduction to Computer Science I (Java) with a grade of C or better.

Offered

Offered Winter only

Notes

Lower Division Transfer (LDT) Course

General Education Requirements

Computer Competency

Outcomes

Upon successful completion of this course, students will be able to:
Describe and explain a select list of common database management system terms. Design and produce relational database models using entity relationship diagrams, integrity rules and normalization. Write structure query language (SQL) statements to select, update and delete records. Write SQL statements to create, modify and drop tables. Write SQL statements that use joins and set operators with multiple tables.