| |
May 02, 2024
|
|
|
|
|
COSC 3380 - Database SystemsCredit Hours: 3
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
Add to Portfolio (opens a new window)
|
|