Create the tables and relationships from the database design discussed in Lab 2 .
Add at least five ( 5 ) records into each table ( Note : You must determine the field values ).
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 :
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 :