QM433: Database Management

Course description

Course Objectives

Exercises and chapters to download

Textbook

Course outline

Grading

Grade distribution

Additional material

Policies

 

Course description

This course focuses on the design of a database starting from the conceptual design to the implementation of  a database schema and user interfaces. Students will learn about database design concepts, data models (Entity-Relationship and Relational Model), the database query language SQL and components of the database management system.

The course is heavily design oriented. In most of the projects, students have to design and implement a database using a commercial database management system (MS Access) and associated development tools (MS Visio). Students will in particular learn the database query language SQL.

 

Teaching Assistant: Osama Mustafawi: osama@cba.edu.kw; Tel: 24 98 86 21  Every weneday you will have a lab session starting 4th of June

 

Course Objectives

  1. Allow the students to understanding Database Terminology (file management, data base management, conceptual model, normalization, SQL)

  2. Introduce the students to the logical design and the SQL language

  3. Learn the students how to normalize a relational database

  4. Allow students to distinguish between conceptual design and physical design

  5. Teach students skills needed to manage and develop a data base systems

  6. Enable students to develop effective data base systems

  7. Allow the students to create database systems with MS Access

See more information on the course

 Chapters to download

Chapter 1 to download ( Click here to download)
Chapter 2 to download ( Click here to download)

Chapter 3 to download ( Click here to download)

Chapter 5: to download ( Click here to download)

Chapter 7: to download ( Click here to download)

 

Assignment to download

Assignment1-Chapter1  (click here) - due date 

Assignment2-Chapter2 (click here to download)- due date

Assignment3-Chapter3 (click here to download)- due date

Assignment4 -Chapter3 (case study during class time Click here to download) -  due date

Assignment4-Chapter 3 (To Be Returned By Students-click here)-  due date

Assignment4-Chapter 5 (To Be Returned By Students-click here)-  due date

Case study 1- Chapter1 (click here to download)- due date

Case study 2 - Chapter 2 (click here to download)- due date -

Case study 3 - Chapter 3 (click here to download)- due date -

Case study 4 - Chapter 5 (click here to download)- due date - Sunday 9th May 2010 (need to be read)

 

Mini Case  (Due date To 26/09/2013) - (raw data related to Case_Friends_IM_Spring- click here)

 

Textbook

Hoffer Jeffrey, V. Ramesh and  Heikki Topi, Modern Database Management: 2013 International, 10th Edition

Book cover

 

 Edition:11/e 2013

 

 

Book cover

Other resources: Books of  Hoffer Jeffrey- MIS Cases by LISA  Miller

Course Outline

Topic

Reading

Database Fundamentals

    Disadvantages of file processing system (pp. 8-9)

    Range of database application (pp. 14-18)

    Advantages of database approach (p. 23-25)

    Components of the database environment  (pp. 26-28)

Chapter 1

Basic Database Analysis

    Database development process (pp. 44-48)

    The role of case tool and repository (pp. 52-54)

    Three-tiered database location architecture (pp.59-60)

Chapter 2

Quiz 1 (covers chapter 1 & 2) takes place after two classes of chapter 2

Advanced Database Analysis

    The E-R model (pp.92-96)

    Entity-Relationship model constructs (pp. 96-106)

    Relationships (pp. 106-123)

Chapter 3

Quiz 2 (covers chapter 3) takes place after two classes of

chapter 3

Relational Database Design

    The relational data model (pp. 289-290)

    Integrity constraints (pp. 292-294)

    Transforming ER diagrams into relations (pp. 197-211)

    Introduction to normalization (pp. 211-215)

    Merging relations (pp. 220-225)

Chapter 4

Quiz 3 (covers chapter 5) takes place after two classes of

chapter 5

Basic SQL

    The role of SQL in a database architecture (289-290)

    The SQL environment (291-294)

    Defining a database in SQL (295-303)

    Inserting, Updating, and deleting data (303-306)

    Processing single tables (306-318)

Chapter 6

Quiz 4 (covers chapter 7) takes place after two classes we finish

chapter 7

Advanced SQL

    Processing multiple tables (p. 327-340)

    Ensuring transaction integrity (p. 340-342)

    Data dictionary facilities (p. 342-343)

    Triggers and routines (p. 346-351)

Chapter 7

Quiz 5 (covers chapter 8) takes place after two classes we finish

chapter8

Data Quality Chapter 10

Administration

    Role of data and database administrator (496-503)

    Modelling enterprise data (504-505)

    Managing data security (505-516)

   Data base  Backing up databases (517-523)

    Controlling concurrent access (523-530)

    Managing data quality (530-532)

    Data dictionary and repositories (532-535)

    Overview of tuning the database for performance (535-537)

    Data availability (537-539)

Chapter 11
Overview: Distributed databases
Chapter 12

Final Exam (26/12/2013 from 08:00 to 10:00): Final exam covers multiple choices questions, short questions (covering definitions, terminology and concepts), problem modelling, critical thinking questions  and  short mini cases

Grading

 

-         5 Quizzes (keep the best four)

25 %

-         Project

20 %

-         Assignment

15 %

-         Final exam

40 %

-         Total

100 %

 

Grade distribution

Range

Grade

>= 95

A

90-94

A-

87-89

B+

83-86

B

80-82

B-

77-79

C+

73-76

C

70-72

C-

65-69

D+

60-64

D

<= 59

F

 

Additional links to database

  1. Database courses

  2. Database connectivity option

Policies

  1. Students should check the website for class information regularly, you are responsible for any information posted on the website

  2. Each week students will have to attend 1 hour lab class on MS Access

  3. You will be expected to arrive in time and to remain in class until the end. If you must arrive late or leave early please inform before 24 hours.

  4. Quizzes will not be repeated, no "make-ups",  even if absent with an excuse

  5. Negotiation of the final grade is neither accepted nor discussed