Skip to Main Content

CMPSC174A

Download as PDF

CMPSC 174A - Fundamentals of Database Systems

Computer Science College of Engineering

Full Course Title

Fundamentals of Database Systems

Instructor Name(s)

Su

Course Description

Database system architectures, relational data model, relational algebra, relational calculus, SQL, QBE, query processing, integrity constraints (key constraints, referential integrity), database design, ER and object- oriented data model, functional dependence, lossless join and dependency preserving decompositions, Boyce-Codd and Third Normal Forms.

Unit Value

4

Maximum number of times course can be repeated for additional credit

0

Maximum Units

4

Recommended Preparation

Students are strongly encouraged to complete Computer Science 56 or Computer Science 156 prior to enrolling in Computer Science 174A.

Prerequisites

Computer Science 130A.

Programs

CMPSC174A is a completion requirement for: