Homework Assignments

There are four assignments considered for this course, as addressed below.

No

Assignment

Example solution

Program

Date of Hand-out

Deadline

1

Databases and
ER-diagrams

Solution-1

IK, AI,

and IN

Monday,

February 1

Friday,

February 12

2

Relational schemas and Relational algebra language

Solution-2

IK, AI,

and IN

Monday,

 February 15

Friday,

February 26

3

SQL and QBE

Languages

 

Schemas for the “mondial” database:

Relational schema

ER diagram

Referential dependencies

Solution-3

IK, AI,

and IN

Monday,

 February 22

Tuesday,

 March 16

4

Relational database design

Solution-4

Only IK

and IN

Monday,

 March 15

Tuesday,

March 23

Please note that because of the different number of ECs for the IK students (5 ECs), for the AI students (3 ECs), and the IN students (3 ECs):

Rules for submitting assignments: