Learning Center
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>



									                             DEPARTMENT OF INFORMATION
                             DEPARTMENT OF INFORMATION
                                      King Abdul Aziz University
                                             Jeddah, Saudi Arabia

                                   COURSE OUTLINE
Course:                Database Systems
Instructors:           Dr. Muhammad Al Haddad & Muhammad Emran
Course website:
Credit Hours:          03
Course Code:           CPIT-240
Pre-Requisite:         CPIT-204
Class:                 BS (IT) Spring 2010

Recommended Books:
Text Book(s):      Fundamentals of Database Systems 5th Edition by Elmasri & Navathe
Reference Book(s): Database Systems a Practical Approach 4th Edition by Thomas M
                   An Introduction to Database Systems by C. J. Date

  Weeks                                              Chapters
                 Lectures:        Chapter # 1 Data, Information, File System, Database and
                                  Database Users
  Week 1
                 Lab 1 (Project): Classical Database Development Methodology (Page 1-6)
                 Lab SQL:
                 Lectures:        Chapter # 2 Database System Concepts and Architecture
                 Lab 2 (Project): Analysis (Page 7-14) Information Flow Diagram, Example,
                 Lab SQL:         Installation of Oracle 10 g
Week 2 & 3
                 Lectures:   Chapter # 3 Data Modeling using the Entity Relationship (ER)
            Lab 3 (Project): Page (15-23) Entity Relationship Diagram, Example
            Lab SQL:         Introduction to Oracle 10g
            Lectures:        Chapter # 5 The Relational Data Model and Relational
                             Database Constraints
            Lab 4 (Project): Page (24-29) Designing of ER Diagram, Primary Key
Week 4 & 5
            Lab 5 (Project): Conceptual Schema, Composite Key Constraint
            Lab SQL:         (Quiz 1)
            Lectures:        Chapter # 10 Functional Dependencies and Normalization for
                             Relational Databases
Week 6, 7 &
            Lab 6 (Project): Page (30-32) Create Database Physically, Physical Schema,
                             (Conceptual Schema Implementation)
            Lab 7 (Project): Page (33-36) Put Constraints Physically on Database Tables
                                                                                Page 1 of 3
             Lab 8 (Project): Page (37-39)Data Types, Specifying Constraints and
                              Default Values
             Lab SQL:         Introduction to SQL-PLUS
                              DROP Commands
                              ALTER TABLE Command
                              INSERT Command
                              DELETE Command
                              UPDATE Command
             Lectures:        Chapter # 6 The Relational Algebra and Relational Calculus
             Lab 9 (Project): Page (40-43) Select statement, Aggregation Functions and
                               Internal Schema Implantation
             Lab SQL:

             Lectures:         Chapter # 7 Relational Database Design by ER and EER to
 Week 9 &                      Relational Mapping
   10        Lab 10 (Project:) Page (44) Joining of Tables, Conditional Statements
             Lab SQL:          The SELECT-FROM-WHERE Structure of SQL Queries
                               Unspecified WHERE-Clause and Use of Asterisk (*)
                               Tables as Sets in SQL
                               Substring Comparisons, Arithmetic Operators, and
                               (Quiz 2)
             Lectures:         Chapter # 13 Disk Storage, Basic File Structure and Hashing
                               (13.1 & 13.2)
                               Chapter # 14 Indexing Structures for Files (14.1, 14.2 &
 Week 11
             Lab 11 (Project:) Page (45) Indexing in Oracle
             Lab SQL:
             Lectures:         Chapter # 8 SQL-99 Schema Definition, Constraints, Queries
                               and Views (DDL and DML)
 Week 12
             Lab 12 (Project:) Page (46) Performance function in Oracle
             Lab SQL:
             Lab 13 (Project:)
             Lab SQL:          Nested Queries and Set Comparisons
 Week 13                       Explicit Sets and NULLS in SQL
                               Aggregate Functions and Grouping
                               (Quiz 3)
Assessments and Grading Policy:       Percentage
i) Quizzes & Assignments              10%
ii) Mid Exam                          20%
iii) Final Exam                       30%
iv) Lab                               40% (15% Lab + 25% Project)
Lectures per week:                    Three (03) lectures of duration 50 minutes each.
Days:                                 Saturday       (8:00 to 8:50) AA
                                      Monday         (8:00 to 8:50) AA
                                      Wednesday (8:00 to 8:50) AA

                                                                                 Page 2 of 3
                          DEPARTMENT OF INFORMATION
                          DEPARTMENT OF INFORMATION
                                       King Abdul Aziz University
                                             Jeddah, Saudi Arabia

Course Aim
To give students a balance introduction of both database theory and practical implementation

Course Objectives

On completion of this course, successful students should have a good understanding of the
motivation and principles underlying database system with particular emphasis on the relational
model including study of query language design, storage structure and normalization.

      Understand the difference between a file system and a database system.
      Know the characteristics and functions of a database management system (DBMS),
       understanding the advantages and disadvantages of using a DBMS.
      Study and practice database modeling tools, such as Entity Relationship Diagrams
      Understand the nature and characteristics of the Relational Database model and property.
      Be able to convert a conceptual data model into a relational logical schema.
      Database architecture, models, views, schema, Data independence, backup and recovery,
       class of users, role of DBA.
      Aspects of integrity and security.
      Know the different normal forms and master how to normalize a database.
      Know how to work with database management systems through the DDL and DML.
      How the data is stored. How data can be accessed by hashing and indexing techniques
      Study and practice different DB Languages at both academic and commercial levels:
       Relational Algebra, Relational Calculus and SQL.
      Study the database design methodology.
      Design and implement a full real size database system.
      Know the internal architecture of a Database Management System and know how data
       are stored on the secondary storage.
      Know some of the advanced functions provided by most professional commercial

                                                                                      Page 3 of 3

To top