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
- Unzip the batch and open only the file for your set number in MySQL Workbench (File → Open SQL Script).
- Select the
SETUP STARTS…SETUP ENDSblock and run it once (Ctrl+Shift+Enter). It builds your database. - Answer the four tasks under their
-- TASK nlines, one statement at a time (Ctrl+Enter), in order. - 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 form and sign in with your university Google account if it asks.
- Enter your name, registration number and set number exactly as your instructor assigned it.
- 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.