Database Design I - 1DL300

Spring 2010

2010-09-24 - the list of passed students for the reexam 100818 can be found here. /KO
2010-04-04 - the list of passed students for the final exam 100318 can be found here. More detailed info will given thruogh the Student portal later /KO
2010-01-16 - the course starts 2010-01-18 at 13.15 in room 1111. /KO
2010-01-16 - this page made accesible /KO

Elmasri, R. & Navathe, S. B.: Fundamentals of Databases, 5th Edition, Addison-Wesley, 2006 (available e.g. at Akademibokhandeln).
Padron-McCarthy, T. & Risch, T.: Databasteknik, Studentlitteratur, 2005 (available e.g. at Akademibokhandeln).

Kjell Orsborn, examinator, lecturer, email: kjell.orsborn@it.uu.se, phone: 471 1154, room 1321
Lars Melander, course assistant, email: lars.melander@it.uu.se, phone: 471 3155, room 1310
Cheng Xu, course assistant, email: cheng.xu@it.uu.se, phone: 471 7345, room 1306

The schedule including time and location is available here, or you can search for it here.

No:	Subject:	ENCh:	PRCh:	Tchr:

L1	Intro to database terminology	1, 2	1	KO
L2	ER modeling	3, 4	2, 3	KO
L3	ER example

L4	Relational model	5, 7	5, 6	KO
L5	Relational algebra	6	10	KO
L6	Physical database design - normalization	10	11	KO

L7	Normalization example	-	-	KO
L8	SQL query language	8	7,8,9	KO
L9	SQL continued	-	-	KO

L10	Transactions and concurrency control	17, 18	23, 24	KO
L11	Recovery	19	23, 24	KO
L12	Physical database design storage structures and indexes	13, 14	21, 22	KO

L13	Physical database design - continued	-	-	KO
LXX	Guest lecture - reserve
??	Feedback on study questions, general questions

T	Tentamen in the "Skrivsalen" hall at Polacksbacken