Reference

MySQLTutorial. $($n$.$d$.).$ MySQL sample database classicmodels $[$Data file$].$ MySQLTutorial.

https:$//$www$.$mysqltutorial.org$/$mysql$-$sample$-$

database.aspx

Before you begin, load the "classicmodels" data set:

Reading: Import CSV File Into My $SQL$ Table ${?}_{(})$

This resource discusses the process of creating a table with the necessary data types, fields, and their lengths so that information can be

imported for querying. As you read, consider the following:

How do you properly size a VARCHAR?

How do you identify all of the column types that need to be in the table?

Start a terminal session and run this command: mysqlsampledatabase.sql

Write commands to use the classicmodels database and show its tables to verify that you're in the right place.

Retrieve employee tuples and identify the number of employees in San Francisco and New York.

A$.$ Command for San Francisco: select firstName, lastName, jobTitle, offices.city from employees inner join offices on

employees. officeCode $=$ offices. officeCode where state $=\text{'}$CA$\text{'}.$

B$.$ Write and run a command to return records from New York on your own.

C$.$ Validate the completion of this step with a screenshot of these two tables.

Retrieve order details for orderNumber $10330,10338,$ and $10194$ and identify what type of cardinality this represents in the entity

relationship model.

A$.$ Retrieve the order details by running SELECT queries with WHERE clauses against the orders table.

B$.$ Validate the completion of this step with a screenshot.

C$.$ Then, reference the Module Four Lab ERD to assist in identifying relationships. A version with alternative text is available: Module Four