COSC 3380 - Database Systems

Credit Hours: 3.0
Lecture Contact Hours: 3 Lab Contact Hours: 0

Prerequisite: A grade of C- or better in COSC 2320 or COSC 2436.
Description
Declared Computer Science majors and minors, and Computer Engineering majors. Database design with ER model, relational model and normalization up to 3NF/BCNF normal forms. Relational algebra and basic SQL queries combining filters, joins and aggregations. SQL transaction processing. Overview of DBMS internal subsystems including: storage, indexing, query optimizer, locking, recovery manager, security mechanisms. Database application development.
Repeatability: No

Note: Declared Computer Science majors and minors, and Computer Engineering majors only.
Typically Offered: Fall

Additional Fee: Y