This assignment teaches you how to modify your tables

Either modify an existing table or create a new table that is related to your hobby and has the following characteristics:

1. At least one field with the following field types:
• CHAR
• VARCHAR
• DATE
• INT
• DECIMAL
• ENUM
• SET
2. Load this table with at least 5 records of appropriate values
3. Save your script as a .sql file

Run your script and take a screenshot of it working with no errors

Cleaning Up Your Hobby Database

For the hybrid part, I want you to clean up and get your database ready to show as part of your portfolio. Do the following:

• Fix issues which make your database look non-professional
• Clean up any data problems
• Clean up your script(s)

Once you have done this, turn the results of your cleanup into a 4-5 slide presentation

Requirements -- at a minimum, your presentation should include the following:

• A slide showing your tables and what is in each table
• An example script used to load one of your tables
• Examples of SQL queries in your database
• Examples of a Join (2 or 3 are better) using your database

Here is an example of what I'm looking for in the hybrid assignment

• If you have Linux, click HERE  
• If you have MS Office, click HERE