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: SQL revisited

solutions

Lab 4: Record formats; index structures

solutions

Midterm 1 review

solutions

Lab 5: XML databases and XQuery

solutions

Lab 6: Transactions and schedules; marshalling

solutions

Lab 7: Locking

solutions

Lab 8: Timestamp-based concurrency control

solutions

Midterm 2 review

Lab 9: MongoDB queries

solutions

Lab 10: Logging and recovery

solutions

Last updated on April 24, 2025.