Scribd Logo
Upload

Welcome to Scribd!

    • 2 views

    Course Out Cs

    Uploaded by

    abboy9654

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Course Out Cs

    Uploaded by

    abboy9654
    2 views3 pages

    Original Title

    Course out cs

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    2 views3 pages

    Course Out Cs

    Uploaded by

    abboy9654

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Course Number:

    CoSc 322

    Course Title: Fundamentals of Database Systems


    Credit: 4; Lecture: 3 hours; Lab: 3 hours; Prerequisite: none
    Course Description: Database management systems; database design for real applications; database models: net
    relational database concepts; standard SQL (relational algebra, relational calculus); transac
    concurrency control and distributed database; and object-oriented databases.

    Course Objectives: After completing this course the student will be able to:
     define and explain database concepts;
     design and develop databases using a standard and appropriate software; and
     implement, use and evaluate developed databases.
    Course outline Chapter One :Introducation to Database Management Systems
     Introduction to database system
     Database system and File System
     Characteristics of the Database Approach
     Actors on the Scene

    Chapter Two : Data Models


     Data Models, Schema and Instances
     DBMS Architecture and Data Independence
     Database Language and Interface
     The Database System Environment
     Introduction to ODL
     E/R Model
     Design principles, Network and hierarchical
     Classification of DBMS

    Chapter Three: Data Modeling using Relational Database


     Using High level Data Models for Database Design
     Entity types and Sets, Attributes and Keys
     Relationships, Roles and Structural Constraints
     Weak Entity Types
     Database Abstraction
     E/R Diagram naming conventions, and Design issues

    Chapter Four : Data base Design


     Introduction
     Functional Dependency
     Normalization

    Chapter Five Standard SQL


    Chapter Six : Database security.
    Chapter seven: Object-Oriented Databases
    Chapter Five : Structured Query Language(SQL)
     SQL Statements
     SQL Query
     Data Manipulation Language
     Constraints and Triggers
    Chapter Six : Database security.

    Chapter seven: Object-Oriented Databases


    Compulsory

    Course Status: Ramez Elmasri and Shamkant B. Navathe (2000) Fundamentals of Database Systems, 3rd e

    Text Book
    Reference Date, C. J. (2000) An Introduction to Database Systems. Massachusetts: Addison Wesley
    Ramakrishman, Raghu & Johannes Gehrke (2000) Database Management Systems. 2nd ed.
    Shepherd, John C. (1990) Database Management: Theory and Practice. Boston: IRWIN
    Ramakrishman, Raghu & Johannes Gehrke (1998) Database Management Systems. 2nd ed.
    Siberschatz, Abraham Henry F. Korth & S. Sudarshan (1997) Database System Concepts,
    Ullman, Jeffrey & Jennifer Widom (1997) A First Course in Database Systems. Prentice-H
    Garcia-Molina, Hector; Jeffrey Ullman & Jennifer Widom (2000) Database System Implem
    Stonebraker, Michael & Joe Hellerstein, eds. (1998) Readings in Database Systems. Morga

    Software Requirement: SQL/ORACLE

    Instructional Methods: Lectures, Laboratory

    Method of Evaluation: Continues Assessments and mini Project (50%) and Final Exams(50%)

    You might also like