This lab practices SQL DDL. Submit the lab answers on Canvas as a text file or document that contains all of your SQL DDL commands.
Practice questions are available.
The assignment is completed using MySQL on Docker and requires computer setup by following these setup instructions.
Note: MySQL does not follow the standard for delimited identifiers using double-quotes ("). It uses backticks (`) instead. To force it to use double-quotes, run this command when you start a session: set session sql_mode = 'ANSI'; It is also possible to set this globally using set global sql_mode = 'ANSI'; Avoid using delimited identifiers for lab 2.