Scribd Logo
Upload

Welcome to Scribd!

  • 182 views

    Faculty Details: Mekelle Institute of Technology (MIT) Mekelle, Tigray, Ethiopia

    Uploaded by

    GemmedaMidakso
    The document provides course details for the Database Management Systems (DBMS) course offered at Mekelle Institute of Technology (MIT) during the 2011/2012 academic year. It includes information about the faculty instructor, course structure and schedule, textbooks, course objectives, evaluation criteria, topics to be covered in each unit, and a sample teaching plan for the first week. The course aims to provide students with theoretical and technical knowledge of database systems, covering concepts, architectures, data models, normalization, and practical skills in designing and implementing a database application.

    Copyright:

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

    Faculty Details: Mekelle Institute of Technology (MIT) Mekelle, Tigray, Ethiopia

    Uploaded by

    GemmedaMidakso
    182 views9 pages
    The document provides course details for the Database Management Systems (DBMS) course offered at Mekelle Institute of Technology (MIT) during the 2011/2012 academic year. It includes information about the faculty instructor, course structure and schedule, textbooks, course objectives, evaluation criteria, topics to be covered in each unit, and a sample teaching plan for the first week. The course aims to provide students with theoretical and technical knowledge of database systems, covering concepts, architectures, data models, normalization, and practical skills in designing and implementing a database application.

    Original Title

    DBMS_Course_Outline_2011_-_2012

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides course details for the Database Management Systems (DBMS) course offered at Mekelle Institute of Technology (MIT) during the 2011/2012 academic year. It includes information about the faculty instructor, course structure and schedule, textbooks, course objectives, evaluation criteria, topics to be covered in each unit, and a sample teaching plan for the first week. The course aims to provide students with theoretical and technical knowledge of database systems, covering concepts, architectures, data models, normalization, and practical skills in designing and implementing a database application.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    182 views9 pages

    Faculty Details: Mekelle Institute of Technology (MIT) Mekelle, Tigray, Ethiopia

    Uploaded by

    GemmedaMidakso
    The document provides course details for the Database Management Systems (DBMS) course offered at Mekelle Institute of Technology (MIT) during the 2011/2012 academic year. It includes information about the faculty instructor, course structure and schedule, textbooks, course objectives, evaluation criteria, topics to be covered in each unit, and a sample teaching plan for the first week. The course aims to provide students with theoretical and technical knowledge of database systems, covering concepts, architectures, data models, normalization, and practical skills in designing and implementing a database application.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 9
    At a glance
    Powered by AI
    The document provides information about a database management systems course including faculty details, course details, textbooks, and teaching plan.

    The course provides students with technical and theoretical knowledge of database systems covering fundamentals, concepts, architectures, data models, normalization, and developing database applications.

    The objectives include understanding databases, DBMSs, architectures, data models, normalization, and designing efficient applications using tools like ER diagrams.

    Mekelle Institute of Technology (MIT) Course File for Database

    Management Systems (DBMSs)


    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Faculty Details
    Name of the Faculty Mr.Mezgebo Hailu

    Designation Lecturer

    E-mail mezgebohailu@gmail.com

    Mobile number 0920813426

    Department Information Technology

    Office Number 209 or Registrar’s Office

    Course Details
    Course Number CSE309
    Corse Title Database Management Systems(DBMSs)
    Lecture 3
    Tutorial 0
    Practice 3
    Credit 4
    Pre-Requisite Nil
    Number of Students 52/-

    Weekly Class Outline


    Days Task Time
    Tuesday DBMSs lecture - Room 7 2:00 am – 4:00 am
    Tuesday DBMSs lab for CSE – Comp. Lab 2 8:00 pm – 11:00 pm
    Wednesday DBMs lecture – Room 4 4:00 am – 6:00 am
    Wednesday DBMSs lab for IT – Comp. Lab 2 8:00 pm – 11:00 pm
    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Text Book
    Remez Elmasri, Shamkant B.Navathe, Fundamentals of Database Systems, 4th edition, Pearson
    Education

    References
    1. Abraham Silberschartz, Henry F. Korth, S.Sudarshan, Database System Concepts, 4th edition,
    Mc Graw Hill

    2. C.J Date, An Introduction to Database Systems, 6th edition, Addison Wesley


    3. John V.Petersen, Absolute beginners’ guide to Databases, Techmedia

    Course Description
    A few decades ago, little attention was given to the importance of data and it was very difficult to
    organize and maintain data in a secure and easily accessible environment. During these years, data
    was almost useless. Nevertheless, today data has emerged as a valuable resource in many fields and
    hence it must be managed with care and rigour. Business enterprises and other organizations must
    effectively store, process, analyze, and synthesize their data to produce timely and accurate
    information which is crucial to gain maximum benefits. In addition to this, it is important to be
    successful in their day-to-day activities in the present competitive economic era. This course will
    provide students with adequate technical and theoretical knowledge of database systems. It covers the
    fundamentals of database management systems starting from basic terminologies and concepts up to
    the complex. In the theoretical session of this course you will learn the basic concepts of database
    systems and their Architecture, Entity Relationship (E-R) Model and Extended Entity Relationship
    Model, Different Data Models with special emphasis on Relational Data Model, Relational Algebra
    and finally Normalization. In the laboratory session you will get introduced with some E-R
    diagramming tools, you will learn how to use the SQL in MySQL and how to develop a small scale
    database application which will be useful for your future projects.
    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    General Course Objectives


     To enable students to understand what a Database is, what a DBMS is, and what a Database
    System is and hence make them develop a broad understanding of database systems.
     To enable students to understand various Database Management Systems and choose the one
    that suites their needs.
     To enable students to understand the advantages of Database Systems over File oriented
    systems.
     To enable students to understand the 3-Schema architecture of a DMBS and Database System
    environment.
     To enable students to understand E-R diagrams and EER diagrams.
     To enable students to understand various form of Normalization.
     To enable students to design efficient database applications for library, e-commerce, bank,
    hotel reservation and related sectors by applying E-R (or EER) diagrams, Normalization and
    other tools.
     To enable students to implement their design above using suitable existing DBMS and
    Programming language.

    Mark Allocation

     Quizzes (10 points)


     Homework assignments (10 points)
     Midterm exam(30 points)
     Project(10 points)
     Final exam(40 points)
    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Grading Scheme
    As per the grading rules of MIT, I am going to follow a fixed grading scheme. The
    detail of how you will be graded is shown in the table below:
    Scale Letter Grade
    >= 90.0 A
    89.99 - 87.50 A-
    87.49 – 85.00 B+
    84.99 – 80.00 B
    79.99 – 77.50 B-
    77.49 – 72.50 C+
    72.49 - 65.00 C
    64.99 – 60.00 C-
    59.99 – 55.00 D
    54.99 – 50.00 D-
    <50.00 F
    <50.00 F

    Course Outline
    Unit – 1 Databases and Database Users
    1.1 Introduction to databases, Difference between Data and Information
    1.2 Database Management Systems (DBMSs) and their components
    1.3 Characteristics of the database approach
    1.4 Actors on the Scene
    1.5 Workers behind the Scene
    1.6 Advantages of using a DBMS
    1.7 When not to use a DBMS
    Unit - 2 Database System Concepts and Architecture
    2.1 Introduction to MySQL
    2.2 Data Models, Schemas and Instances
    2.3 Three-Schema architecture and Data Independence
    2.4 Database languages and Database Interfaces
    2.5 Software Modules of the DBMS
    2.6 Centralized and Client/Server Architectures for DBMSs
    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Course Outline
    Unit – 3 The Entity – Relationship (E-R) & EER Model
    3.1 Introduction to database design process and the E-R Model
    3.2 Understanding Entities and their attributes
    3.3 Types of attributes
    3.4 Notations for E-R diagram
    3.5 Relationships and Relationship Types( One-to-One, Many-to-One, Many-to-Many)
    3.6 Roles and Structural Constraints
    3.7 Weak Entity Types
    3.8 Enhanced Entity Relationship (EER) Model

    Unit – 4 The Relational Data Model


    4.1 Relations and their properties
    4.2 Codd’s Rules
    4.3 Relational Model Notations & Constraints
    4.4 Relational Operations & Handling Constraint Violations
    4.5 Introduction to Relational Algebra
    4.6 Tuple Relational Calculus
    4.7 Domain Relational Calculus

    Unit –5 Data base Normalisation


    5.1 Introduction to the Normalization process & Functional Dependencies
    5.2 First Normal Form (1NF)
    5.3 Second Normal Form (2NF)
    5.4 Third Normal Form (3NF)
    5.5 Boyce-Codd Normal Form (BCNF)
    5.6 Fourth Normal Form (4NF)
    5.7 Fifth Normal Form (5NF)
    5.8 Other Normal Forms
    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Teaching Plan : Unit 1

    WEEK DATE TOPIC TEACHING STUDY


    MEATHOD RESOURCES
    11/10/2011 Introduction to databases; Board Lecture Notes , Text
    One DBMSs and their components book & Web
    (Oct.10- Oct.16)
    11/10/2011 Lab exercise 1,CSE --- Lab manual 1
    12/10/2011 Characteristics of the database Board Lecture Notes, Text
    approach book & Web
    14/10/2011 Lab exercise 1,IT --- Lab manual 1
    18/10/2011 Actors on the Scene ; Workers Board Lecture Notes, Text
    behind the Scene book & Web
    Two 18/10/2011 Lab exercise 2,CSE --- Lab manual 2
    (Oct.17- Oct.23) 19/10/2011 Advantages of using a DBMS ; Board & Lecture Notes &
    When not to use a DBMS Group Web
    discussion
    21/10/2011 Lab exercise 2,IT --- Lab manual 2

    Teaching Plan : Unit 2

    WEEK DATE TOPIC TEACHING STUDY


    MEATHOD RESOURCES
    25/10/2011 Introduction to MySQL; MySQL Board & Lecture Slides &
    Three Terminologies ; Types of SQL Projector Web
    (Oct.24- Oct.30) Statements
    25/10/2011 Lab exercise 3,CSE --- Lab manual 3
    26/10/2011 MySQL Data types ; Integrity Board & Lecture Slides &
    Constraints ; Basic MySQL Projector Web
    Commands
    28/10/2011 Lab exercise 3,IT --- Lab manual 3
    Four 01/11/2011 Data Models, Schemas and Board Lecture Notes , Text
    (Oct.31- Nov.6) Instances book & Web
    01/11/2011 Lab exercise 4,CSE --- Lab manual 4
    02/11/2011 Three-Schema architecture and Board Lecture Notes, Text
    Data Independence book & Web

    04/11/2011 Lab exercise 4,IT --- Lab manual 4


    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Teaching Plan : Unit 3

    WEEK DATE TOPIC TEACHING STUDY


    MEATHOD RESOURCES
    08/11/2011 Database languages and Board Lecture Notes,
    Five Database Interfaces; Text book & Web
    (Nov.7- Nov.13) Software Modules of the DBMS.
    08/11/2011 Lab exercise 5,CSE --- Lab manual 5
    09/11/2011 Centralized and Client/Server Board Lecture Notes &
    Architectures for DBMS Web
    11/11/2011 Lab exercise 5,IT --- Lab manual 5
    Six 15/11/2011 Introduction to the E-R Model; Board Lecture Notes ,
    (Nov.14- Nov.20) Understanding Entities and their Text book & Web
    attributes
    15/11/2011 Lab exercise 6,CSE --- Lab manual 6
    16/11/2011 Types of attributes; Board Lecture Notes,
    Notations for E-R diagram Text book & Web

    18/11/2011 Lab exercise 6,IT --- Lab manual 6


    Seven 22/11/2011 Relationships and Relationship Board Lecture Notes,
    (Nov.21- Nov.27) Types Text book & Web
    22/11/2011 Lab exercise 7,CSE --- Lab manual 7
    23/11/2011 Roles and Structural Constraints; Board Lecture Notes &
    Weak Entity Types Web
    25/11/2011 Lab exercise 7,IT --- Lab manual 7

    Teaching Plan : Unit 4

    WEEK DATE TOPIC TEACHING STUDY


    MEATHOD RESOURCES
    29/11/2011 Enhanced Entity Relationship Board Lecture Notes, Text
    Eight (EER) Model book & Web
    (Nov.28- Dec.4)
    29/11/2011 Lab exercise 8,CSE --- Lab manual 8
    30/11/2011 Enhanced Entity Relationship Board Lecture Notes, Text
    (EER) Model (Continuation) book & Web
    02/12/2011 Lab exercise 8,IT --- Lab manual 8
    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Teaching Plan : Unit 4

    WEEK DATE TOPIC TEACHING STUDY


    MEATHOD RESOURCES
    Nine
    (Dec.5- Dec.11) MID-EXAM WEEK
    13/12/2011 Relations and their properties Board Lecture Notes , Text
    Ten book & Web
    (Dec.12 -Dec.18)
    13/12/2011 Lab exercise 9,CSE --- Lab manual 9
    14/12/2011 Codd’s Rules; Board Lecture Notes, Text
    Relational Model Notations & book & Web
    Constraints
    16/12/2011 Lab exercise 9,IT --- Lab manual 9

    Teaching Plan : Unit 5

    WEEK DATE TOPIC TEACHING STUDY


    MEATHOD RESOURCES
    20/12/2011 Relational Operations & Handling Board Lecture Notes,
    Eleven Constraint Violations Text book & Web
    (Dec.19-Dec.25)
    20/12/2011 Lab exercise 10,CSE --- Lab manual 10
    21/12/2011 Tuple Relational Calculus(TRC) Board Lecture Notes,
    Text book & Web
    23/12/2011 Lab exercise 10,IT --- Lab manual 10
    Twelve 27/12/2011 Tuple Relational Calculus(TRC) Board Lecture Notes ,
    (Dec.26-Jan.1) (Continued…) Text book & Web
    27/12/2011 Lab exercise 11,CSE --- Lab manual 11
    28/12/2011 Domain Relational Calculus(DRC) Board Lecture Notes,
    Text book & Web

    30/12/2011 Lab exercise 11,IT --- Lab manual 11


    Mekelle Institute of Technology (MIT) Course File for Database
    Management Systems (DBMSs)
    Mekelle,Tigray ,Ethiopia
    Academic year: 2011/2012

    Teaching Plan : Unit 5

    WEEK DATE TOPIC TEACHING STUDY


    MEATHOD RESOURCES
    Thirteen 03/01/2012 Domain Relational Board Lecture Notes, Text
    (Jan.2-Jan.8) Calculus(DRC) book & Web
    (Continued…)
    03/01/2012 Lab exercise 12,CSE --- Lab manual 12
    04/01/2012 Introduction to the Normalization Board Lecture Notes &
    process & Functional Web
    Dependencies
    06/01/2012 Lab exercise 12,IT --- Lab manual 12
    Fourteen 10/01/2012 First Normal Form (1NF) Board Lecture Notes , Text
    (Jan.9-Jan.15) book & Web
    10/01/2012 Lab exercise 13,CSE --- Lab manual 13

    11/01/2012 Second Normal Form (2NF) Board Lecture Notes, Text


    book & Web
    13/01/2012 Lab exercise 13,IT --- Lab manual 13

    Fifteen 17/01/2012 Third Normal Form (3NF Board Lecture Notes, Text
    (Jan.16-Jan.22) book & Web
    17/01/2012 Lab exercise 14,CSE --- Lab manual 14
    18/01/2012 Boyce-Codd Normal Form Board Lecture Notes &
    (BCNF) Web
    20/01/2012 Lab exercise 14,IT --- Lab manual 14

    Sixteen 24/01/2012 Fourth Normal Form (4NF) Board Lecture Notes &
    (Jan.23-Jan.29) Web
    24/01/2012 Lab exercise 15,CSE --- Lab manual 15

    25/01/2012 Fifth Normal Form (5NF) ; Board Lecture Notes &


    Other Normal Forms Web
    27/01/2012 Lab exercise 15,IT --- Lab manual 15
    Seventeen
    (Jan.30- Feb.05) STUDY - WEEK
    Eighteen
    (Feb. 6 - Feb. 11) FINAL EXAM WEEK

    You might also like