Spring Semester 2011 DE4:

Course Database Design


Welcome to the Database Design Course:

Instructor:

Text Book for the Course: DATABASE CONCEPTS, 4th Edition by DAVID M. KROENKE and DAVID J. AUER

Objectives:

To enable students to apply database concepts and their principles to design simple relational database systems. The important topics are:

 

q  Design of simple relational database systems

q  Database processing

q  Basic SQL for database definition and manipulation

q  Entity-relationship model and illustration of data modelling

q  Transformation of E-R data models to relational designs

Course Outline & Structure

q  Basic concepts and principles of database systems

q  ER-models

q  Converting to relational models

q  1st-3rd normal forms

q  SQL

q  Database Design

q  Database Administration

Exam

q  Running Evaluation (It was agreed to have a running evaluation. There will be 3 Programming Assignments & 1 descriptive Assignment for the exam evaluation).

q  3 Questions (This option obviously was not selected)

 

Guidance Plan for Students

Date

Time

Place

Subject

Exercises

Handouts

08-02-2011

08:30

B206

Introduction to Database Design

Delivered in the class

Lecture 1

15-02-2011

08:30

B206

Relational Model

Delivered in the class

Lecture 2

22-02-2011

08:30

B206

SQL

Delivered in the class

Lecture 3

01-03-2011

08:30

B206

Data Modeling and Entity Relationship Model, Database Design

Delivered in the class

Lecture 4

Extra-Lecture-4

08-03-2011

08:30

B206

Database Administration

Delivered in the class

Lecture 5