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

Lab 4: XML databases and XQuery

solutions

Midterm 1 review (optional)

solutions, slides

Lab 5: Transactions and schedules; XQuery revisited

solutions

Lab 6: Locking

solutions

Lab 7: Timestamp-based concurrency control

solutions

Last updated on October 29, 2026.