Course Agenda

While in principle the chapters 1 to 7 of the text book will be covered in this course, the lectures planned for the course do not strictly follow the order of these chapters in the text book of the course. Also, section 8.7 is addressed in the lectures. The chapters planned to be covered at each lecture are represented in the following table.

Week

Date

Program

Instructor

Chapters

Subject

Assignments

5

Monday,

February 1

IK, AI,

and IN

H. Afsarmanesh

1

Introduction to Databases

Assignment-1 - hand-out

6

Monday,

 February 8

IK, AI,

and IN

H. Afsarmanesh

6

Entity-relationship model

 

7

Monday,

February 15

IK, AI,

and IN

H. Afsarmanesh

2

Relational model / Relational algebra

Assignment-2 - hand-out

8

Monday,

February 22

IK, AI,

and IN

H. Afsarmanesh

3

SQL

Assignment-3 - hand-out

9

Monday,

 March 1

IK, AI,

and IN

H. Afsarmanesh

(3)

4 & 8.7

SQL and Integrity / Security

 

10

Monday,

March 8

IK, AI,

and IN

H. Afsarmanesh

5

Query-By-Example

 

11

Monday,

March 15

Only  IK

and IN

H. Afsarmanesh

 

7

Relational Database Design / Normalization

Assignment-4 - hand-out

12

Monday,

March 22

Only IK

H. Afsarmanesh

 

*  hand out slides for  the presentations

Example DBs -  advanced R&D applications

 

 

 

Please note that: