Spring Semester 2011 – DE4:

Course – Database Design

---

Welcome to the Database Design Course:

Instructor:

• Dr. D. M. Akbar Hussain ( akh@es.aau.dk )
• Meetings: Send me an Email with Time and Date.
• Urgent or Personal ISSUES: Just walk in.
• Room #: H329
• Tel: 7729 (Direct)

Text Book for the Course: DATABASE CONCEPTS, 4^th 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