The Military College of South Carolina Dare to Lead

Info Academics Admissions Alumni Cadet Life Graduate College Evening Undergrad Athletics Connect Giving
Close this window

Giving to The Citadel

  • The Citadel Foundation
  • Blueprint
  • The Citadel Brigadier Foundation

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, and database constraints. 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 Fall

Recent Syllabi:

Fall 2011, Joshi
Fall 2010, Moore