Lab 4 Structured Query Language (SQL) Refer to the database design crested in Lab 2 Modifying a Database Design to complete this Lab
in Other (Other) by vomms
Favorite
Add it to your favorites and revisit later
Instant Download
Previewing 1 of 8 total pages.
Regular Price: $17.14
Your Price: $12.00 (30% discount)
You Save: $5.14
Your Price: $12.00 (30% discount)
You Save: $5.14
Description
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:
- 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...
Comments (0)
You must sign in to make a comment.
Rating:
Published On:
07/07/2019
Last Updated:
07/07/2019
Print Length:
8 page(s)
Word Count:
252
File Name:
lab-4-structured-query-language-sql-refer-to-the-database-design-crested-in-lab-2-modifying-a-database-design-to-complete-this-lab-73.docx
File Size:
1,784.25 KB (1.78 MB)
Sold By:
vomms
Purchased:
0 times
Best Seller Ranking:
#