Does DBS really end

Database systems I in winter semester 2009/10


Current

  • The tickets can now be picked up in the secretariat (room 1.54, Oettingenstr. 67).
  • Bachelor's degree students do not receive a certificate. The results are sent directly to the respective examination offices.
  • The catch-up exam can be viewed on Friday, April 30th, 2010 at 3: 00-4: 00 pm in Oettingenstr. 67 in room 157.
  • The results of the catch-up exam should now really be visible in Uniworx.
  • You can find the list of participants registered for the catch-up exam here.
  • You can find the leaflet on the catch-up exam here.
  • Registration for the exam is complete. The exam takes place in the following rooms in the main building (Geschwister-Scholl-Platz 1):
  • The certificates for the first exam can now be picked up in the secretariat (room 1.54, Oettingenstr. 67).
  • The catch-up exam will take place on April 13, 2010 from 13: 30-15: 30. Registration for the catch-up exam is still open at http://www.pst.ifi.lmu.de/uniworx/ (register for the lecture "DBS I - catch-up exam").
  • The exam will take place on Thursday, March 11th, 2010 at 14: 00-16: 00 in Oettingenstr. 67 in room 157.
  • The distribution of grades for the first exam can be found here.
  • The catch-up exam is expected to take place at the end of the semester break. You can already register for it at http://www.pst.ifi.lmu.de/uniworx/ (register for the lecture "DBS I - catch-up exam").
  • The exams have been corrected! The results can be viewed at http://www.pst.ifi.lmu.de/uniworx/. (Note: The DBS I lecture can now be found under Uniworx under "Lectures from earlier semesters").
  • A list of all participants registered for the exam can be found here.
  • As a reminder: The registration for the exam is only open until Friday, January 22nd, 2010. Organizational matters for the exam (room layout etc.) will be announced afterwards.
  • In addition to the exam on January 29, 2010, there will be a catch-up exam, probably at the end of the semester break. An exact date will be announced.
  • A bug in the Select interface that occurred when using self-joins has now been fixed. Due to the error, relations with several identically named attributes (e.g. l1.lnr and l2.lnr) were displayed incorrectly.
  • The errors in chapter 7 in the script, especially the slides on multi-valued dependency, have been corrected. The revised version of the script (chapter 7) is available for download (see below) !!!
  • The exam will take place on January 29th, 2010 from 14: 30-16: 30. Please register for the exam at http://www.pst.ifi.lmu.de/uniworx/. For reasons of space, only registered students can be guaranteed a place!
  • With the help of the Select interface you can send queries to the LTP database from exercise sheet 3 and the following. The Select interface is only accessible from within the CIP pool!
  • The second exercise sheet is now available.
  • The exercises on November 9th, 2009 and November 13th, 2009 are omitted.
  • The lecture on November 4th, 2009 is canceled!
  • The first exercise sheet is now available.
  • The lecture will now take place from 9:30 a.m. to 12:00 p.m. The room doesn't change.
  • The exercises do not begin until November 2nd or 6th, 2009.
  • On October 21, 2009, the lecture does not begin until 9:30 a.m. (And ends as planned at 11:00).

content

The lecture offers an introduction to the field of database systems from the user's point of view. The focus is on the theoretical aspects of relational database design using the relational data model, relational algebra and relational calculus. There is a detailed discussion of the query language SQL, which is implemented in most relational systems. Furthermore, formalisms, theory and algorithms of relational design theory are described and newer applications in the field of databases are dealt with.

Successful completion of the lecture "Database Systems I" is a prerequisite for all other courses (lectures, seminars, internships) as well as student work in the field of databases.


organization


time and place

eventtimeplaceBeginning
lectureWed, 9.30 a.m. - 12.00 p.m.Large auditorium (main building)21.10.2009
exerciseMon, 2 p.m. - 4 p.m.Room M 110 (main building)02.11.2009
exerciseMon, 4 p.m. - 6 p.m.Room 203 (Schellingstr. 3 (R))02.11.2009
exerciseFri, 2 p.m. - 4 p.m.Room M 203 (main building)06.11.2009
exercise Fri, 4 p.m. - 6 p.m.Room M 203 (main building)06.11.2009

planning

datelectureexercise
October 21, 2009 start at 9:30 am !!! Chapter 1: Introduction (PDF)
October 28th, 2009 start at 9:30 am !!! Chapter 2: The Relational Model (PDF)

Exercise sheet 1

November 4th, 2009 lecture canceled !!! -- No practice
11/11/2009, 9:30 a.m. Chapter 3: Relational Algebra (PDF)

Exercise sheet 2

11/18/2009, 9:30 a.m. Chapter 4: The Relation Calculus (PDF)

Exercise sheet 3

November 25, 2009, 9:30 a.m. Chapter 5: More on SQL (PDF)
Exercise sheet 4
December 2nd, 2009, 9:30 a.m. Chapter 6: The E / R Model (PDF)

Exercise sheet 5

09.12.2009, 9:30 a.m. Chapter 7: Normal forms (PDF (revised version from December 17, 2009))

Exercise sheet 6

December 16, 2009, 9:30 a.m. Chapter 7 (continued)

Exercise sheet 7

December 23, 2009, 9:30 a.m. Chapter 8: Transactions (PDF)

Exercise sheet 8

January 13, 2010, 9:30 a.m. Chapter 9: Physical Data Organization (PDF)

Exercise sheet 9
Worksheet

January 20, 2010, 9:30 a.m. Chapter 10: Object-Relational Extensions (PDF)

---

January 27, 2010, 9:30 a.m.Replay sheet

---

02/03/2010, 9:30 a.m. Chapter 10 (continued)

---

02/10/2010, 9:30 a.m. Exam discussion

---


Exam

The exam will take place on January 29th, 2010 from 2:30 p.m. - 4:00 p.m. Please note the information on the exam.


Additional information


Previous semester

WS 15/16, WS 14/15, WS 13/14, WS 12/13, WS 11/12, WS 10/11, WS 09/10, WS 08/09, WS 07/08, WS 06/07, WS 05/06, WS 04/05, WS 03/04, WS 02/03, WS 01/02, WS 00/01, SS 00, SS 99, SS 98