Question

The purpose of this lab is to gain familiarity with MySQL Workbench. The lab also ensures the correct version of the Sakila sample database is installed on your computer, for use in other zyLabs.

This lab has three parts:
Install the Sakila database.
Run a simple query.
Recreate a Sakila table in the zyLab environment.
Only the third part is graded.
Install the Sakila database
To create Sakila tables on your computer, download the Sakila schema file, open MySQL Workbench, and click the following menu commands:
Click 'File' > 'Open SQL Script…' and open the Sakila schema file.
Click 'Query' > ''Execute (All or Selection)'.
To load sample data to the Sakila tables, download the Sakila data file and repeat steps 1 and 2 with this file.
Run a simple query
Refer to the following MySQL Workbench screenshot, taken from a Mac computer. Workbench looks slightly different on Windows.
If 'sakila' does not appear under 'Schemas', click the refresh icon, in the red circle above. If 'sakila' still does not appear, repeat the installation process or request assistance.
When 'sakila' appears under 'Schemas':
Click > to expand 'sakila'.
Click > to expand 'Tables'.
Right-click 'film'.
Click 'Select Rows - Limit 1000'
MySQL Workbench executes SELECT * FROM film; and displays 1000 films:
Recreate a Sakila table in the zyLab environment
To recreate the actor table in the zyLab environment:

Right-click 'actor'.
Select 'Copy to Clipboard' > 'Create Statement' to copy the CREATE TABLE statement to your clipboard.
Paste the CREATE TABLE statement into the zyLab Main.sql box.
Delete the following characters for compatibility with the zyLab environment:
COLLATE=utf8mb4_0900_ai_ci
all apostrophes (`)
The CREATE TABLE statement creates actor columns, keys, and indexes.

Answer 1

The student is instructed on how to recreate the actor table from the MySQL Workbench Sakila sample database in the zyLab environment by copying the CREATE TABLE statement, removing specified characters, and executing it.

Step-by-step explanation:

The student is seeking to gain familiarity with MySQL Workbench by installing and using the Sakila sample database. The lab exercise has three parts: installing the Sakila database, running a simple query, and recreating a table in the zyLab environment, with only the third part being graded. To recreate a Sakila table in zyLab, the student must copy the CREATE TABLE statement from MySQL Workbench, paste it into zyLab, and make certain modifications for compatibility.

The specific task involves recreating the actor table. This requires copying the CREATE TABLE statement, ensuring that COLLATE=utf8mb4_0900_ai_ci and all backticks (`) are removed to meet zyLab environment requirements. Once these modifications are made, the CREATE TABLE statement can be executed within the zyLab to successfully create the actor columns, keys, and indexes matching the Sakila sample database