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