CS 275 Database Systems: SQL & Oracle

Introduces the design, purpose, and maintenance of a database system. Covers the entity-relationship (ER) model, relational systems, data definition, data manipulation, query language (SQL) and the Oracle and Access 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:
Develop amd Enrty relationship diagram. Design a database the is normalized. Create tables and populate them with data. Use SQL to query a database. Define and use Views. Format reports created from database.