Database Design I - 1DL300
Spring 2012
Contents
- News
- Literature
- Assignments
- Teachers
- Schedule
- Goal, content and prerequisite
- Organization and examination
- Slides and compendia
- Reading instructions
- Miscellaneuos information
- F.A.Q.
News
- 2012-04-19 En del studenter med underkänt resultat har frågat efter möjlighet att höja poängsättningen till godkänt resultat genom att göra extra uppgifter. Vi har inga sådana rutiner eftersom vi inte har resurser att täcka någon sådan verksamhet. Jag granskade särskilt alla tentor som låg nära godkänt, men jag kunde inte se några möjligheter till generösare poängsättning. Er nästa chans är inte långt borta; redan i juni äger nästa omtenta rum. Därefter i augusti. Lycka till! /EZ
- 2012-04-16 Exams are graded and reported to the student office. Results (and overall pass ratio) [frist (63%); it3 (67%); x3 (22%)]. Students on F, STS, master, &c are in "frist" list.
- By popular request, the March 2012 exam is posted. /EZ
- Next exam is April 10. /EZ
- 2012-03-17 Exams are graded and reported to the student office. Results [f3 f4b frist mast sts3]. Please contact the student office if you want to look at your exam. Make sure that you follow the procedure if you want to appeal. Note: Results will be reported to UPPDOK no earlier than March 26. /EZ
- 2012-01-26 Slides on Normalization are updated. Try to decompose
the relation Teach (pp 19) so that it fulfils BCNF ! /SS
- 2012-01-25 Slides on Relational Algebra are updated. Try to make the exercices (last slide from the lecture) ! /SS
- The course starts Mon, Jan 16 at 10:15 in P 1111. That lecture will cover a course overview and ER modeling. We plan to give a small exercise on ER modeling at the end of that lecture, which is to be solved until the next lecture. /EZ
- All questions regarding registration is handled on Studentportalen, by the Student Office (Polacksbacken, building 4), or by your study counsellor. The teachers do not handle any such administrative issues. /EZ
Literature
- Elmasri, R. & Navathe, S. B.: Fundamentals of Databases, 6th Edition, Addison-Wesley, 2010 (available e.g. at Akademibokhandeln).
- Padron-McCarthy, T. & Risch, T.: Databasteknik, Studentlitteratur, 2005 (available e.g. at Akademibokhandeln).
Assignments
- Instructions and material for the database assignments are here.
Teachers
- Erik Zeitler, examiner, lecturer, email: erik.zeitler@it.uu.se, phone: 471 3390, room 1320
- Silvia Stefanova, lecturer, email: silvia.stefanova@it.uu.se, phone: 471 2846, room 1319
- Anne-Kathrine Peters, lecturer, email: anne.peters@it.uu.se, phone: 471 2978, room 2404
- Mikael Lax, course assistant, email: mikael.lax@it.uu.se, phone: 471 7345, room 1306
- Lars Melander, course assistant, email: lars.melander@it.uu.se, phone: 471 1051, room 1316
- Cheng Xu, course assistant, email: cheng.xu@it.uu.se, phone: 471 7345, room 1306
Schedule
- The schedule including time and location is available here.
| 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. | |
|
|