CSCI 320
Database Design

Course Description:

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, database constraints, and file structure. Students will be required to complete a project involving database design and implementation.

Major Topics:

• Entity-relationship models
• Relational model
• Relational algebra and calculus
• Normalization
• Transformation of data models into database designs
• SQL programming
• Physical database design

Course Outcomes:

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.

Textbook:

Fundamentals of Database Systems (Fifth Edition) by Ramez Elmasri and Shamkant B. Navathe, Addison-Wesley, 2007.

Projected Schedule:

Every Spring

Recent Syllabi:

Spring 2008, Zahid
Spring 2007, Moore