IDD

From PLSwiki

Contents 1 Introduction to Database Design, Fall 2010 2 Practical and administrative matters 3 Topics and tentative plan 4 Exam 5 Old Exams 6 Project Description 7 Mandatory Assignments 8 Teaching Staff

Introduction to Database Design, Fall 2010

Practical and administrative matters

• First lecture: Monday Aug 24, 11:30-14:20. 4A14
• Remaining lectures: Monday 9:00-11:00. 4A14
• Labs:Monday 11-13:00. 4A54 and 4A56
• The course period is 14 weeks (7.5 ects), starting August 24rd.
• Blog

Topics and tentative plan

• Below is a tentative plan.

Week	Date	Teacher	Topic	Materials	Homework
35		CS	Introduction Relational Model	Slides Slides	Read Chapter 1 in Database System Concepts Assignment0 out
36		PB	joint session with DSF		Read Chapter 2 in Database System Concepts
37		PB	joint session with DSF		Read Chapter 3 in Database System Concepts
38		CS	SQL	Slides	Chapter 3 Assignment0 due (before class) Assignment1 out Lab: Exercises: 3.1, 3.2, 3.3, 3.9, 3.11
39		CS	Advanced SQL	Slides	Chapter 4 Lab: Exercises: 4.2, 4.5, 4.10, 4.11, 4.14
40		CS	Entity Relationship Model	Slides	Chapter 6 Assignment1 due (before class) Assignment2 out Lab: Exercises: 6.2, 6.9, 6.16 (for 6.2 only), 6.21
41		CS	Relational Database Design	Slides	Chapter 7 Assignment2 due (before class) Assignment3 out
42			Fall break
43		CS	Catch-Up lecture		Lab: Exercises 7.1, 7.2, 7.3,7.6, 7.23, 7.25
44		CS	Storage and File Structure	Slides	Chapter 11 Lab: Exercises 11.2, 11.3,11.5, 11.6, 11.10
45		CS	Indexing and Hashing	Slides	Chapter 12 Assignment3 due (before class) Assignment4 out Lab: 12.3, 12.4, 12.12, 12.15, 12.16, 12.20
46		CS	Query Processing	Slides	Chapter 13 Project out Lab: 13.3.(a,b,c), 13.6, 13.11, 13.12
47		CS	Query Optimization	Slides	Chapter 14 Assignment4 due (before class) Lab: 14.1, 14.2, 14.4, 14.6, 14.11
48		CS	Transactions	Slides	Chapter 15 Lab: 15.6, 15.11
49		CS	Concurrency Control	Slides	Chapter 16 Lab: 16.1,16.2,16.7,16.24
50		CS	Recovery System	Slides	Chapter 17 Project due: Monday, 14.12.2009

Exam

External examiner, 7-point marking scale, A2: Written examination with all written and printed aids.

Qualification for the exam: pass on 50% of the assignments + pass on the project

The final grade will be determined in negotiation with an external censor.

Old Exams

1 2 3 4 5 6

Project Description

TBA

Mandatory Assignments

Teaching Staff

• Carsten Schürmann. carsten@itu.dk
• Nicola Pascelupo. nipa@itu.dk