Uppsala University / Computer Science Division / Uppsala Database Laboratory : Database Design I - 1DL300
Uppsala universitet
Hoppa �ver l�nkar

CONTENTS
News
Literature
Assignments
Teachers
Schedule
Goal, content and prerequisites
Organization and examination
Slides and compendia
Reading instructions
Miscellaneuos information
F.A.Q.

Database Design I - 1DL300

Spring 2012

Contents



News

Literature

Assignments

Teachers

Schedule

No: Subject: ENCh: PRCh: Tchr:

L1 Intro to database terminology 1, 2 1 EZ
L2 ER modeling 7, 9 2, 3 AP
L3
ER example


AP

L4 Relational model 3, 8 5, 6 AP
L5 Relational algebra 6 10 SS
L6 Logical database design - normalization 14 11 SS

L7 Normalization example - - SS
L8 SQL query language 4 7,8,9 AP
L9 SQL continued - - AP

L10 Transactions and concurrency control 20,21 23, 24 EZ
L11 Recovery 22 23, 24 EZ
L12 Introduction to physical DB design: storage structures and indexes 16, 17 21, 22 SS

Lx Guest lecture - reserve


SS/EZ/?
L14
Feedback on study questions, general questions


EZ

T Final exam.


Goal, content and prerequisites

Organization and examination

Slides and compendia

Reading instructions

Miscellaneous information

F.A.Q.