Catalog Description:

Introduction to database concepts. This course examines the logical organization of databases: the entity-relationship model; the relational data model and its languages. Functional dependencies and normal forms. Design, implementation, and optimization of query languages; security and integrity, concurrency control, transaction processing, and distributed database systems.

Contact Hours:

• Lecture: 3 hours

Prerequisites: CSC 316 or ECE 309
Co-requisites: None
Restrictions: None
Coordinator: Dr. Rada Chirkova
Textbook: Database Systems

Course Outcomes:

Upon successful completion of this course, a student will be able to:

1. design and edit entity-relationship (E/R) diagrams for database schemas
2. translate E/R diagrams into relational schemas
3. determine the normalization status of relational schemas and decompose schemas into 3NF and/or BCNF
4. understand, design, and evaluate relational-algebra queries on a given relational schema
5. understand, design, and evaluate SQL queries on a given relational schema
6. understand, design, and evaluate constraints and triggers on a given relational schema
7. understand and design SQL code for transactions, security, and user authorization in relational database systems
8. understand and explain algorithms for coping with database-system failures
9. understand and explain algorithms for concurrency control in database systems
10. write, test, and deploy application programs in database-system environments

Topics:

• Introduction
• Database programming basics
• Data modeling: entity-relationship approach
• Relational model
• Relational algebra
• SQL
• Constraints and triggers
• Transactions, security, and authorization in SQL
• Index structures
• Recovery
• Concurrency control
• Query execution
• other topics (time permitting)