Docstoc

Database Management Systems 1.doc

Document Sample
Database Management Systems 1.doc Powered By Docstoc
					                                                                               Revised: June, 2009


                              Polytechnic University of the Philippines
           COLLEGE OF COMPUTER MANAGEMENT AND INFORMATION TECHNOLOGY
                                         Sta. Mesa, Manila



                                        COURSE SYLLABUS


 Course Code            :      INTE 3023

 Course Title           :      Database Management Systems 1

 Course Credit          :
                 Lecture:      2 units        Laboratory:    1 unit           Total Units:    3 units

 Hours Equivalent       :      90 hrs

                 Lecture:      2 hrs          Laboratory:    3 hrs            Total Hours: 5 hrs

 Course Pre-Requisites :       COMP 2053

 Course Description     :

          This subject discusses database management concepts with emphasis on the activities in
 database development. Topics include database analysis and database design specifically
 relational database design.      SQL Language is introduced. The subject provides students
 activities in database design and application of SQL Language through various problem solving
 exercises and computer activities.

 Course Objectives      :

     A. Cognitive Aims
        At the end of the course, the students are expected to be able to:
            1. discuss basic concepts of database management and database design.
            2. design a relational database using entity relationship model.
            3. write basic Data Manipulation Language SQL statements.
            4. write basic Data Definition Language SQL statements.

     B. Value Aims
        At the end of the course, the students are expected to:
            1. have strengthened their value for honesty, integrity, and hard work by giving their
                best in any class activity.
            2. be self-motivated, and work collaboratively with their group mates.
            3. have developed value for time so that promptness is observed in attendance to
                class and submission of requirements.
            4. have become more resourceful in order to get the best results in any activity.

 Course Contents        :

                                                                          Lecture            Laboratory
                               Topics
                                                                          Hours                hours
I. Introduction to Databases
   1.1. The Evolution of Database Technology
   1.2. Database Approach                                                  4 hours
        1.2.1 Advantages and Disadvantages of Database
               Approach
        1.2.2 Range of Database Applications

                            INTE 3023 – DATABASE MANAGEMENT SYSTEMS 1
                                              Page 1 of 5
                                                                                 Revised: June, 2009


                               Polytechnic University of the Philippines
             COLLEGE OF COMPUTER MANAGEMENT AND INFORMATION TECHNOLOGY
                                           Sta. Mesa, Manila



                                                                           Lecture         Laboratory
                                Topics
                                                                           Hours             hours
         1.2.3 Components of the Database Environment
   1.3. Database Development Process
       1.3.1. Systems Development Life Cycle and the DB
               Development Activities
       1.3.2. Three-Schema Architecture (External Level,
                Conceptual Level, Internal Level)
   1.4 Database Languages and Interfaces
                                                                                            6 hours
   1.5 Database System Environment
2. Database Analysis
                                                                           10 hours
   2.1 Conceptual Data Modeling
        -Modeling the Rules of the Organization
    2.2 Entity-Relationship Model Notation
   2.3 Entity-Relation Model Constructs
                                                                                            9 hours
         2.3.1 Entities
         2.3.2 Attributes
         2.3.3 Relationships (Degree of Relationships, Cardinality
         Constraints)
   2.4 Enhanced ER Model
        2.4.1 Notations indicating supertype and
              subtype
        2.4.2 Constraints in supertype/subtype
              relationships
                                                                           4 hours         10 hours
3. Logical Database Design and the Relational
   Model
   3.1 The Relational Data Model
   3.2 Integrity Constraints
          3.2.1 Domain Constraints
          3.2.2 Entity Integrity
         3.2.3 Referential Integrity
    3.3 Transforming EER Diagrams into Relations
          3.3.1 Map Weak Entities
          3.3.2 Map Binary Relationships
          3.3.3 Map Associative Entities
          3.3.3 Map Unary Relationships
          3.3.4 Map Ternary Relationships
          3.3.5 Map Supertype/Subtype Relationships
                                                                                            2 hours
MIDTERM EXAMINATION
                                                                             6 hours
   3.4   Normalization
         3.4.1 Steps in Normalization
        3.4.2 Functional Dependencies and Keys
         3.4.3 Basic Normal Forms (1st, 2nd, 3rd Normal Form)
                                                                             2 hours
4. Basics of Physical Database Design
                                                                             8 hours         27 hours
5. Implementation
                                                                             2 hours
 FINAL EXAMINATION

Laboratory
     Introduction to Structured Query Language
       Table
      - Table Name Construction

                            INTE 3023 – DATABASE MANAGEMENT SYSTEMS 1
                                              Page 2 of 5
                                                                                   Revised: June, 2009


                               Polytechnic University of the Philippines
             COLLEGE OF COMPUTER MANAGEMENT AND INFORMATION TECHNOLOGY
                                           Sta. Mesa, Manila



                                                                           Lecture           Laboratory
                                Topics
                                                                           Hours               hours

      - Data Types
      - Null Characteristic
     Maintaining Data
     Simple SQL Queries
      - Structure of an SQL Query
      - Retrieving All Columns, All Rows
      - Retrieving All Columns, Limited Rows
      - Selecting Specific Columns
      - Select with Ordered Output
      - Suppressing Duplicate Output Rows
      - Retrieving Rows by Character Comparisons
      - Retrieving Rows by Numerical Comparisons
      - Comparison Operators (AND and OR – Principle,
        Multiple Conditions, SELECT with IN, SELECT
        with BETWEEN, Retrieving Rows – with
        Null Comparison, Partial String Search, Negation)
     Column Functions and Grouping


  Course Requirements :

      The course entails active class participation on the following activities:
      1. Lecture/ Classroom discussion
      2. Laboratory activities
      3. Assignments/Seatworks
      4. Case Studies/Projects

  Evaluation Techniques          :

      1.   Completed Assignments/Seatworks
      2.   Completed Laboratory Activities/Cases
      3.   Projects
      4.   Quizzes
      5.   Long Examinations

  Course Grading System          :

                    Midterm                                                  Final

Class Standing                        70 %            Class Standing                         70 %
Quizzes                      30 %                     Quizzes                        30 %
Project                      20 %                     Project                        20 %
Seatworks/Assignments/       20 %                     Seatworks/Assignments          20 %
   Laboratory Activities                                 Laboratory Activities

Mid-term Examination                  30 %                Final Examination                     30 %

                     Final Grade = (1st Grading Grade+ 2nd Grading Grade)/2



                            INTE 3023 – DATABASE MANAGEMENT SYSTEMS 1
                                              Page 3 of 5
                                                                            Revised: June, 2009


                            Polytechnic University of the Philippines
          COLLEGE OF COMPUTER MANAGEMENT AND INFORMATION TECHNOLOGY
                                       Sta. Mesa, Manila



Suggested Teaching Methodologies/Strategies         :

   1.   Lecture/Class Discussion
   2.   Question and Answer
   3.   Demonstration
   4.   Discussion Groups
   5.   Group Projects
   6.   Computer-aided Instruction

Required Readings     :

   1. Modern Database Management by R.F. McFadden and J.A. Hoffer, 6th edition,
      Benjamin-Cummins (Narosa), 2007.

Suggested Readings :

   1.   Database Systems, Thomas Connolly and Carolyn Begg, 3rd edition, 2007
   2.   Fundamentals of Database Systems, Ramez Elmasri and Shamkant B. Navathe, 2007.
   3.   DB2 SQL Workshop Guide, 2002.
   4.   An Introduction to Database System by CJ Date, 8th edition, 2004
   5.   Database System Concepts by Silberchatz, 2002.

General Rules         :

   1. The course is expected to have a minimum of four (4) quizzes. No make up tests will be
      given.

   2. Assignments and research projects/report works will be given throughout the
      semester. Such requirements shall be due as announced in class. Late submission shall be
      penalized with grade deductions (5% per day) or shall no longer be accepted, depending
      on the subject facilitator’s discretion. Assignments and exercises are designed to assist
      you in understanding the materials presented in class, and to prepare you for the exams.

   4. Students are required to attend classes regularly, including possible make-up classes. The
      student will be held liable for all topics covered and assignments made during his/her
      absence. The university guidelines on attendance and tardiness will be implemented.

   5. Any evidence of copying or cheating during any examinations may result in a failing
      grade from the examination for all parties involved. Note that other university guidelines
      shall be used in dealing with this matter.

   6. Students are advised to keep graded work until the semester has ended.

   7. Contents of the syllabus are subject to modification with notification.

   8. Cell phones, radios or other listening devices are not allowed to be used inside lecture
      and laboratory rooms to prevent any distractive interruption of the class activity.

   9. No foods, drinks, cigarettes nor children are allowed inside the lecture and laboratory
      rooms.

   10. Withdrawal and dropping from the subject should be done in accordance with existing
       university policies and guidelines regarding the matter.
                          INTE 3023 – DATABASE MANAGEMENT SYSTEMS 1
                                            Page 4 of 5
                                                                       Revised: June, 2009


                          Polytechnic University of the Philippines
        COLLEGE OF COMPUTER MANAGEMENT AND INFORMATION TECHNOLOGY
                                     Sta. Mesa, Manila



Date Revised        :      June 5, 2009

Revised by          :

Gisela May A. Albano
Ma. Luisa C. Aro
Florante V. Andres
Ludivino Apanay
Zinia L. Guevara
Gafar Mua


Approved by:



    MICHAEL B. DELA FUENTE                           ANGELITO G. PASTRANA
  Chairperson, Dept. of Computer Science     Chairperson, Dept. of Information Technology



                                   ROSITA E. CANLAS
                                     Dean, CCMIT




                        INTE 3023 – DATABASE MANAGEMENT SYSTEMS 1
                                          Page 5 of 5

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:122
posted:9/6/2011
language:English
pages:5
Description: Database Management Systems 1.doc