Fundamentals of Database Systems

Number: 
CMPSC 174A
Level: 
Undergraduate
Units: 
4

Description

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