CS-443 Database Systems Manipulation and Design

Mathematics, Statistics & Computer Science Department

COURSE NO./TITLE: CS-443 DATABASE SYSTEMS MANIPULATION AND DESIGN

CREDITS: 3

COURSE DESCRIPTION: Database systems: conceptual and logical organization of data, data models, data manipulation and data definition languages, and design of databases. Other database issues: integrity, constraints, concurrency, security, and query optimization. Distributed database systems, object-oriented database systems, and expert database systems.

Prerequisite: CS-244.

TEXTBOOK:

  • Database Management Systems, 3rd Ed. by Gehrke (adopted Spring 2003)
  • (Adopted 1/98: Database Processing Fundamentals, Design, 6th Ed., by Kroenke)
    (Previously used 4th Ed. Of Kroenke)

COURSE OBJECTIVES: As a result of taking this course the student shall:

  1. Understand the general concepts of database systems, both in terms of usage and design.
  2. Become familiar with the relational database model and other models currently in use.
  3. Be able to design, implement, and extract information from a database using common relational database system products.
  4. Gain awareness of current issues and problems in the area of database systems.

COURSE OUTLINE:

  1. Basic Database Concepts
  2. Data Modelling
    -Levels of Abstraction
    -Types of Data Models
  3. The Relational Model
    -General Concepts
    -Formal Languages (Relational Algebra and Calculus)
    -SQL Standard/Other Practical Languages
  4. Relational Database Design
    -Problems
    -Normalization
  5. Physical Structure of Databases
    -Storage
    -Indexing
  6. Other Issues
    -Implementation Issues--Integrity, Constraints, Concurrency, Security, Others
    -Other Logical Models--Network and Hierarchical
    -Alternative Models--Object-oriented, Logic-based
    -Client-Server Architectures
    -Distributed Databases
    -Expert Database Systems
  7. Academic and Commercial Database Systems

Revised 6/08