Design File and Database Syst
COSC 3380
Credit 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
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
Sources:
Basic Information
- Earliest record:
- Latest record:
- Number of instructors:
- Number of sections:
- Average number of students per section: