ICS322 Database Management System

Welcome to Database Management Systems.

Instructor: Dr. Vaide Narvaez

Schedule: Tuesday, Thursday 8:00-10:00am

Course Description

Introduces the concepts and techniques of database management systems. Key concepts will be presented, including database design and modelling, data integrity, building a business-oriented database, security, database administration and implementation.

Course Objectives

On successful completion of this subject, students should be able to demonstrate an understanding of fundamental database concepts, the typical database system components and functions; understand the role of high-level conceptual data modeling in database design and develop the ability to design and implement conceptual schemas for database applications; demonstrate knowledge of the relational database model and its basic characteristics and the relational algebra; develop the ability to use SQL to create a database and specify retrieval queries and develop skills in database application development.

Course Syllabus and Material

Course Syllabus

Week Content Exercises/Assignments/Additional Material
1 Lecture 1: Introduction to DatabasesLecture 2: Database Development Process
  • Homework 1: Read up on pros and cons for a DBMS of your choice
  • Homework 2:Consider CIS as a business enterprise. Define several major entities and draw a preliminary enterprise data model.
2 Lecture 3&4: Conceptual data modeling
3 Lecture 5&6: Conceptual data modeling: EER diagrams
  • Assignment 1 (due 16.11.2010)
4 Lecture 7&8: Relational data model, Mapping to ER.
  • Assignment 2(due 23.11.2010)
  • Homework: transform the ships ER diagram (last slide) into a relational schema
5 Lecture 9&10: Functional dependencies, Normal Forms
  • Homework: review definitions of the normal forms
6 Lecture 11-12: Relational Algebra
  • Assignment 3 (due 30.11.2010)
7 ReviewIntro to basic SQL
8 Lab exercises
9 Advanced SQL
10 Views, indexes, triggers and transactions in SQL
11 -12 SQL in a Server Environment, JDBC
13 Security and User Authorization in SQL
14 Structured, semistructured and unstructured data. XML
15 Course Review
  • Project presentations (24.02.2011)

Reading Material

Required textbook

  1. R. Elmasri, S. B. Navathe. (2004) Fundamentals of Database Systems, 4th ed., Prentice Hall, ISBN 0-321-20448-4
  2. H. Garcia-Molina, J.D. Ullman, J. Widom. (2009) Database Systems: The Complete Book, 2nd ed., Prentice Hall

Supplementary reading materials

  1. Jeffrey A. Hoffer, Mary B. Prescott and Heikki Topi. (2009) Modern Database Management, 9th ed., Prentice Hall, ISBN-10: 0132212110
  2. Raghu Ramakrishnan and Johannes Gehrke. (2003) Database Management Systems, 3rd ed., McGraw-Hill, ISBN:0-07-246563-8
  3. Abraham Silberschatz, Henry F. Korth and S. Sudarshan. (2002) Database System Concepts, 4th ed., McGraw-Hill, ISBN:0-07-228363-7