CSE2132 RDBMS LAB EVALUATION  -  Batch 1  -  question sets 1-15 (Labs 1-7)
=============================================================

WHAT IS IN THIS FOLDER
  Set_01_....sql  to  Set_15_....sql   one file per question set.

  Every file contains, in this order:
    1. the instructions and the 4 tasks (written as a comment at the top),
    2. a SETUP block that builds the database for that set (tables + data),
    3. an ANSWER AREA where you type your answers.

  Everything works OFFLINE in MySQL Workbench - no internet is needed.

BEFORE YOU START
  * MySQL Server 8.0.16 or newer (CHECK constraints and RENAME COLUMN are used).
  * Your instructor will tell you your SET NUMBER. Open ONLY that file.

HOW TO DO THE EVALUATION
  1. Open MySQL Workbench, connect to your local server.
  2. File > Open SQL Script... > choose your Set_NN file.
  3. Select the text from  ">>>>>>>>>> SETUP STARTS <<<<<<<<<<"  to
     ">>>>>>>>>> SETUP ENDS <<<<<<<<<<"  and run it with Ctrl+Shift+Enter.
     (Run it ONCE. Running it again deletes your work and rebuilds the data.)
  4. Write your answer under each "-- TASK n" line in the ANSWER AREA.
     Run one statement at a time: cursor inside the statement, Ctrl+Enter.
  5. Do the tasks in order. Save the file and submit it as instructed.

IF SOMETHING GOES WRONG
  Re-run the SETUP block: it drops and rebuilds the database, giving you the
  original data back. Then redo the tasks in order.
  If Workbench says "Error Code: 1175 ... safe update mode", the SETUP block
  already switches it off for your session - run SETUP again in the same tab.
