Does DBS really end
Database systems I in winter semester 2009/10
- 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).
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.
time and place
|lecture||Wed, 9.30 a.m. - 12.00 p.m.||Large auditorium (main building)||21.10.2009|
|exercise||Mon, 2 p.m. - 4 p.m.||Room M 110 (main building)||02.11.2009|
|exercise||Mon, 4 p.m. - 6 p.m.||Room 203 (Schellingstr. 3 (R))||02.11.2009|
|exercise||Fri, 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|
|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
|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 |
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.
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
- Why am I afraid of losing myself?
- What do 14-year-olds do
- Why was trigonometry invented
- What is your work schedule
- Who was Chiaro Davanzati
- Does your mother think you're a loser?
- Can I have an arranged marriage?
- What breaks a Nikah in Islam
- Am I bisexual or what
- Like Koreans and Vietnamese
- Is 70K year good for one person
- Has YouTube a channel
- What's better than nothing
- How to become an arborist
- Why is KPMG successful
- How high are the victims of the Kargil War
- What is cryogenics
- How do you know if you're spoiled?
- What happened to Noah's son Ham
- What experiences have people had with pregabalin?
- Can an architect work from home
- Is long-term care worth the cost
- Israeli men marry Palestinian women
- What is the ethnicity of a white Australian