For more course tutorials visit www . tutorialrank . com
This Tutorial contains 2 Papers
CIS 111 Week 7 Lab 4 Structured Query Language ( SQL ) ( 2 Papers )
For more course tutorials visit www . tutorialrank . com
This Tutorial contains 2 Papers
Lab 4 : Structured Query Language ( SQL )
Refer to the database design crested in Lab 2 : Modifying a Database Design in Visio to complete this Lab .
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 .