Database Design I - 1DL300

Contents

• News
• Literature
• Assignments
• Teachers
• Schedule
• Goal, content and prerequisite
• Organization and examination
• OH slides and compendium
• Reading instructions
• Miscellaneuos information
• F.A.Q.

OH slides and compendie

• Introduction to database terminology (as *.pdf)
• Introduction to ER and EER-modeling (as *.pdf)
• The relational model (as *.pdf)
• Relational algebra (as *.pdf)
• Normalization (as *.pdf)
  
• Normalization example (as *.pdf)
• Introduction to SQL (as *.pdf)
• SQL call-level API:s (as *.pdf)
  
• Transactions and concurrency control (as *.pdf)
• Recovery (as *.pdf)
  
• Physical database design - storage structures and index (as *.pdf)