Create a query with all fields from the student table , where the student ' s last name is " Smith ".
Create a query that includes students ’ first names , last names , and phone numbers .
Create a query that includes instructors ' first names , last names , and courses they teach .
Include the following screen shots in a Microsoft Word document to show the completion of the steps above :
Screen shot depicting the tables created within MySQL . Screen shots depicting the records added into each table .
Screen shots depicting the SQL code and the query results from each of the queries created .
Your assignment must follow these formatting requirements : Submit the lab as a Microsoft Word document .
Include a cover page containing the title of the assignment , the student ’ s name , the professor ’ s name , the course title , and the date . The cover page is not included in the required assignment page length .
The specific course learning outcomes associated with this assignment are :
Prepare database design documents using the data definition , data manipulation , and data control language components of the SQL language .
===================================================