← Lab slides

RDBMS · CSE2132 Lab

Lab Evaluation

Thirty practical scenarios on Labs 1–7, split into two batches. The question sets and the solutions of both batches are available below. Download the zip of your batch, then work on the set number your instructor gives you. Everything works offline in MySQL Workbench.

Batch 1

Sets 1–15

Batch 2

Sets 16–30

How to attempt your set

  1. Unzip the batch and open only the file for your set number in MySQL Workbench (File → Open SQL Script).
  2. Select the SETUP STARTS … SETUP ENDS block and run it once (Ctrl+Shift+Enter). It builds your database.
  3. Answer the four tasks under their -- TASK n lines, one statement at a time (Ctrl+Enter), in order.
  4. Save your file, then hand it in from the Submission tab. Needs MySQL Server 8.0.16 or newer.

Submit your work

When you have finished your set, upload your files through the Google Form below. Upload both files.

File 1Solution fileYour saved .sql file with your answer under every -- TASK n line.
File 2Output fileThe output of your queries: screenshots of the result grids (one per task, including the DESCRIBE / verification queries) or a PDF of them.
Open the submission form →
  1. Open the form and sign in with your university Google account if it asks.
  2. Enter your name, registration number and set number exactly as your instructor assigned it.
  3. Attach the solution file and the output file, then press Submit.

Submit before the time your instructor announces. Only the solution and output files for your own set are needed - do not upload the whole zip.