It Is time to Change Data in Your Tables

You should have 3 Tables from last week to work with

1) Either Modify an existing Table or create a New Table that has the following characteristics:

a) At least one field with the following field types: CHAR, VARCHAR, DATE, INT, DECIMAL, ENUM, SET

b) Load this table with at least 5 records of appropriate Values

2) This will be the last lab using your hobby database, I want you to clean it up and get it ready to show as part of your portfolio.

a) Fix issues which make your database look non professional

b) Clean up any data problems

c) Clean up your script(s)

d) Turn the results into a 4-5 slide presentation

Homework