1
Lab Assignment 3
Important Note: [SS] denotes screen shot needed! [no SS] means no
screen shot required.
You should end up with 9 screen shots!
Ensure that you start with this document and keep you [SS]’s with the
appropriate step. [SS]’s not positioned with the numbered steps in this and ALL
labs, will received significant deductions!!!
1. Using MySQL Workbench, create a new database names Sales (ensure that
the database does not already exist and remember to refresh your SCHEMA).
[SS}
2. Using the newly created Sales database, create a new table named customer
with the following fields & properties:
a. customer_id integer
2
b. first_name varchar (255)
c. last_name varchar(255)
d. email_address varchar(255)
e. number_of_complaints integer [SS]
3. Perform a Select * for all entries, did you find any data? [SS] No, I did not find
any data.
