CSCI 320: Database Design
CSCI 320 Database Design Three Credit Hours
Prerequisite: CSCI 202 or CSCI 216
Required for B.S. degree in computer science.
An introduction to the logical and physical structures of computer database systems. Topics include data models, query languages, relational database design, and database constraints. Students will be required to complete a project involving database design and implementation.
- Entity-relationship models
- Relational model
- Relational algebra and calculus
- Transformation of data models into database designs
- SQL programming
- Physical database design
Upon successful completion of this course, a student will be able to
- Explain the conceptual, logical, and physical models of a relational database
- Explain the concepts of keys, foreign keys, and referential integrity
- Write SQL statements to create, query, and update a relational database
- Explain normalization and its role in database design
- Design and implement a relational database.
Fundamentals of Database Systems (Fifth Edition) by Ramez Elmasri and Shamkant B. Navathe, Addison-Wesley, 2007.