CIS 111 Study Career Begins/cis 111mart.com CIS 111 Study Career Begins/cis 111mart.com | Page 21

Perform the following steps in MySQL :
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 .