Course Number
CMPSC 174A
Internal Course Number
174
Level
Undergraduate
Units
4
Faculty
Jianwen Su
Course Description

Prerequisite: Computer Science 32; Computer Science 130A.
Recommended Preparation: Students are strongly encouraged to complete Computer Science 56 prior to enrolling in Computer Science 174A
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.