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.