Refer a friend and get % off! They'll get % off too.

Lab 4 Structured Query Language (SQL) Refer to the database design crested in Lab 2 Modifying a Database Design to complete this Lab. Perform the following steps in MySQL: 1. Create the tables and relationships from the database design discussed in Lab 2

Lab 4 Structured Query Language (SQL) Refer to the database design crested in Lab 2 Modifying a Database Design to complete this Lab. 

Perform the following steps in MySQL:

1.      Create the tables and relationships from the database design discussed in Lab 2. 

2.      Add at least five (5) records into each table (Note: You must determine the field values). 

3.      Create a query with all fields from the student table, where the student's last name is "Smith".

4.      Create a query that includes students’ first names, last names, and phone numbers.

5.      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.

You will get a DOCX (2MB) file

$ 5.00

$ 5.00

Buy Now

Discount has been applied.

Added to cart
or
Add to Cart
Adding ...