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

Fall 2011

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 EZ
L3
ER example


EZ

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

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

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 SB

L13 Physical DB design: continued - - EZ
Lx Guest lecture - reserve


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


EZ

T Final exam in Skrivsalen, Polacksbacken. Dec 13, 14:00-19:00.


Goal, content and prerequisites

Organization and examination

Slides and compendia

Reading instructions

Miscellaneous information

F.A.Q.