Course Outline: NJ, Essex County College

By: Higher Education

Abstract: CSC 231: Engineering Technologies and Computer Science

Essex County College
Engineering Technologies and Computer Science

Course Outline

Database Design
CSC 231


    Credits: 4
    Prerequisites: CSC 122 or CIS 211
    Corequisites: None
    Concurrences: None

    Description:
    This course introduces the concepts and techniques associated with construction and design of database management systems. The topics to be explored include various database processing environments, access methods, data modeling, relational algebra, and database design.

    Course Objectives:
    Upon completion of the course the student will be able to:

    1. Understand the impact that database designs have on user interfaces and application program structure;
    2. Design and implement a relational database and supporting applications;
    3. Design and implement a data dictionary for a relational database;
    4. Understand multi-user database processing on LANs in client-server systems.

    Required Materials:
    Textbooks:
    Database Systems Design, Implementation, and Management
    Peter Rob, Carlos Coronel
    Course Technologies

    Delphi 2 Unleashed
    Charles Calvert
    Borland Press

    Materials:
    (5) 3 1/2" diskettes

    Methods of Instruction:

    1. Lecture
    2. Laboratory Assignments
    3. Programming Examples

    Minimum Course Requirements:

    1. The reading of all assigned textbook chapters;
    2. Participation in class discussions;
    3. The completion of database design project.

    Method of Evaluation:
    Passing average on all quizzes and examinations (75% or better); passing average on database design project and homework assignments (70% or better); and passing grade on the final examination (75% or better).

    Course Content Outline:

    1.File Systems and Databases

      1.1 File Systems
      1.2 Database Systems
      1.3 Database Models
    2.The Relational Model
      2.1 Logical View of Data
      2.2 Integrity Rules
      2.3 Relational Database Operators
      2.4 Relational Database Software Classification
      2.5 Data Redundancy
    3.Introduction to SQL
      3.1 Data Definition Commands
      3.2 Data Management
      3.3 Queries
      3.4 Advanced Data Management Commands
    4.Data Models
      4.1 Conceptual Model
      4.2 Internal Model
      4.3 External Model
      4.4 Physical Model
    5.E-R Modeling
      5.1 The E-R Model
      5.2 Developing an E-R Diagram
    6.Normalization of Database Tables
      6.1 Normalization
      6.2 First Normal Form
      6.3 Second Normal Form
      6.4 Third Normal Form
      6.5 Boyce-Codd Normal Form
    7.Database Design
      7.1 Systems Development Life Cycle
      7.2 Database Life Cycle
    8.Case Study University Lab
      8.1 Conceptual Design
      8.2 Logical Design and Implementation
    9.Client Server Systems
      9.1 Client/Sever Environment
      9.2 Client/Sever Architecture
      9.3 Managerial Expectations

Server Response from: ETNASC01