Contents

B461: Database Concepts

Fall 2009

Resources

• Course text web page.
  
  
• Oncourse: Original Oncourse
  
  
• If you are not familiar with latex, I recommend the book-lshort .
  
  
• The SQL tutorial in w3school.



• embedded SQL C(hand out of the class on 10/16/2008)



• SQL Server at IU homepage .



• Oracle at IUB help
  • Oracle at IU homepage.
  • Accessing Oracle on Steel

    Important: Your initial password is set to your IU network ID and the name of the database is oed1,i.e., you will initially login with
    username: netid@oed1
    password: netid
    where netid is your IU network ID. Please change your password after your first login.

  • Oracle 9i Online Documentation
  • Oracle for B561 primer


• Previous Assignments
• Fall 2007
• Assignment 1:
  • ER diagrams and the relational model
• Assignment 2:
  • Relational Algebra (Solutions)
• Assignment 3:
  • Formulating Queries (Solutions)
• Assignment 4:
  • Dynamic and PL/SQL (Solutions)
• Exercises for FDs, Normal Forms, Decompositions:
  • FDs, Normal Forms, Decompositions (Solutions)
• Assignment 5:
  • B+-Trees, Hash Tables, Query Evaluation (Solutions)
• Assignment 6:
  • Transaction Management, Concurrency Control, Crash Recovery. Solutions can be found here, here, and here.



• Previous Exams
• Fall 2004
  • midterm: version 1, version 2
  • final exam: version 1, version2
• Fall 2003
  • midterm 1 (solutions)
  • midterm 2
  • final exam
• Fall 2001
  • midterm (solutions)
  • final exam
• Fall 2000
  • midterm (solutions)
  • final exam
• Fall 1999
  • midterm (with solutions)
• Fall 1997
  • midterm