The Citadel

The Military College of South Carolina

log3.jpg

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
  • Understand database security issues and vlunerabilities, such as SQL injection, and implement security measures
  • Learn about database security models
  • Learn about alternatives to relational databases, such as flat, network, object-based, object-oriented, and NoSQL

Textbook:

Required

Modern Database Management (12th Edition),Jeffrey A. Hoffer, V. Ramesh and Heikki Topi, Prentice Hall, 2016

Recommended

Database Security, Alfred Basta and Melissa Zgola, Cengage Learning, 2012

Reference
Fundamentals of Database Systems, (7th Edition), Elmasari and Navathe, Pearson 2016

Projected Schedule:

Every Spring

Recent Syllabi:

Spring, 2016 Joshi

Back to Top