A1.1 Sakila Schema

In this assignment you become familiar with your cPanel server and how to access your MySQL database and setting up the Sakila database.

For all of your server assignments, make sure you use the auto-grader so you can confirm your assignment score and so it is recorded. Be sure to use the autograder to make sure your implementation is correct.

Once you log into cPanel, you see there are a large number of apps available to you. Open the File Manager and familiarize yourself with the directories and files that come with a server.

Part 1: Install the Sakila Database

In this part you will install the Sakila database on the server provided for you. You can use this database to complete all of the Sakila Labs in the textbook, rather than installing MySQL on your personal machine. Documentation for the Sakila database is available here.

Download and save these slightly modified versions of the sakila_schema.sql and sakila_data.sql files. They have been modified to remove all direct references to the name of the database. You will be installing these files using phpMyAdmin on your server from within the database with a different name.

See this video for help.

Once you've downloaded and saved the two files, you need to log into the server that is provided for you for this class.

Your server host name is http://<your UH username>.ics321.org. Your cPanel control panel is at http://<your UH username>.ics321.org/cpanel.

Your username is the first 5 characters of your UH username followed by '321' and your password is Xy12345678%#! where X is the first letter of your last name capitalized. y is the first letter of your first name not capitalized. 12345678 is your 8-digit UH ID. (If your UH username has less than 5 characters, just use that.)

For example, my UH email address is richardh@hawaii.edu. My server URL is http://richardh.ics321.org, my cPanel login username is richa321 and my password would be Hr12345678%#! (if 12345678 were my 8-digit UH ID).

Once you have logged into cPanel, complete the following steps.

  1. In cPanel, launch the Manage My Databases app. Create a new database named sakila (all lower case). (The name will be prefixed with your cPanel user name.)
  2. In cPanel, launch the phpMyAdmin app. On the left, click to open the _sakila database. Click the Import tab at top. Choose the sakila-schema.sql file. Click the switch to disable foreign key checks. (Uncheck Enable foreign key checks.) Click Import at the bottom. Then click the Import at the top again and repeat to import the sakila-data.sql file. Remember to disable foreign key checks.
  3. Confirm using the auto-grader grading assistant that your import was successful.

Make sure you leave this database as it is throughout the semester to insure you receive full credit at the end when the grades are computed. Some of the labs have you modify a Sakila database. If the lab requires you to modify the Sakila database, you must first create a new one with a slightly different name so the database you created for this assignment remains in its original form. (Part 2 next does not have you modify the database.)

Part 2: Generate CREATE TABLE statement

To produce the CREATE TABLE statement for the actor table, click the SQL tab at the top to open an SQL window. Type SHOW CREATE TABLE actor; and click GO. To see the complete CREATE TABLE statement, click the Extra options button and click Full texts and click Go. The full CREATE TABLE statement should appear. You should be able to copy the complete statement into the Lab solution box for full credit. Make sure you add a semi-colon to the end of the statement.