Labs

Other relevant information:

• Using the virtual desktop
• Creating and using folders

Lab 0: Preliminaries

complete on your own ASAP!

Lab 1: ER diagrams and the relational model

solutions

Lab 2: SQL and relational algebra

solutions

Lab 3: Record formats; index structures

solutions, slides

Midterm 1 review

solutions, slides

Lab 5: XML databases and XQuery (optional)

solutions

Lab 6: Transactions and schedules; locking

solutions, slides

Lab 7: Timestamp-based concurrency control

solutions, slides

Last updated on March 27, 2026.