News

Chapter 6 (Information Systems in Organisations) of the lecture was skipped due to lack of time.

Contact Hours

Prof. Dr. Wolfgang Prinz
wolfgang.prinz@fit.fraunhofer.de
(by appointment after the lecture)

Dr. Mareike Schoop
schoop@informatik.rwth-aachen.de
Tel.: 0241/80-21511
Contact Hour: Thu 14.00 - 15.00
Room: 6234

Dipl.-Inform. Christoph Quix
quix@informatik.rwth-aachen.de
Tel.: 0241/80-21510
Contact Hour: Mon 12.30-13.30 and Thu 14.00 - 15.00
Room: 6233
 

Dates

	Lecture Tuesday, 14.15-15.45, AH IV Thursday, 11.45-13.15, AH IV
	Example Class Monday, 10.00-11.30, AH I

General Information

	Course Announcement in VIS
	Course and Example Class Announcement in CAMPUS
	Contents and other general information
	Literature
	Literature for Chapter 2 (File and Memory Management)

Lecture

	ER Model of the MD Tours example
	Additional/updated slides for chapter 7 (RDF & Queries)
	Additional slides for XQuery.
	Additional slides for chapter 7 (Distributed Databases and XML) can be found on the BSCW server (username and password were given in the lecture).

Exercises

	General Information about the organisation of the example classes
	Examples/Exercises (Index structures and access times, for first example class)
	Exercise 1 (Terminology, Secondary storage, and access methods)
	Exercise 2 (Access methods, physical database design, B-Trees)
	Exercise 3 (ER diagrams)
	Exercise 4 (ER diagram and mapping to relational database model)
	Exercise 5 (ER diagram, mapping to relational model, and relational algebra)
	Exercise 6 (Relational algebra, calculus, and SQL)
	Exercise 7 (SQL and functional dependencies)
	Exercise 8 (SQL, normal forms, synthesis, and decomposition)
	Exercise 9 (Synthesis and OODBs)
	Exercise 10 (OO Modelling)
	Exercise 11 (UML)
	Exercise 12 (XML, RDF, and XQuery) XQuery Demo (provided by Microsoft, read also the Announcement on DBWorld)
	Example Exam
	Results of the exam and information about the relationship between marks/grades and points.

Links

	MySQL (free SQL database system, frequently used for small (web-) applications, does only support a limited set of SQL statements)
	PostgreSQL (free SQL database system, very close to the SQL standard)
	TogetherSoft (provides an UML modelling tool used in the lecture, evaluation version available)
	XML page of W3C (information about the XML standard) XML Query (information about the XML Query standard) XQuery Demo (provided by Microsoft, read also the Announcement on DBWorld) XML Tutorial (by Anders Møller & Michael I. Schwartzbach) Managing XML and Semistructured Data (course by Dan Suciu)
	UML Reference Card (by Allen I. Holub, short overview of the concepts of the UML structure diagram)
	ConceptBase's home page (Metadata Manager developed Informatik V)
	Databases & Logic Programming bibliography server
	ACM SIGMOD (Special Interest Group Management of Data): Links to many online resources related to research in databases