ISTE-230 Introduction to Database & Data Modeling Homework #8 – Relational Algebra, Subqueries, and Joins | Complete

Document Content and Description Below

Needed to complete: MySQL version 5 In this assignment you will utilize the JOBS database to explore the use of relational algebra, subqueries, and joins within MySQL. This exploration will help you... to formulate strategies for query composition when a specified set of data needs to be found within a database. Download and install the JOBS database In MyCourses you will find a script called ‘createJOBS.sql’, download the file to your local hard drive. Run the ‘createJOBS.sql’ script within MySQL to create the JOBS database. Familiarize yourself with the structure of the JOBS database by examining the ‘createJOBS.sql’ script as well as reviewing the information provided in appendix A. Query the database Create a script called ‘yourlastname_HW8.sql’ and add a comment at the top of the file with your name. For each question you will add a comment indicating the task number, followed by your SQL statement that addresses the task, given the specification provided. The results you should achieve are shown after each task (if your records appear in a different order but the content is the same, that is fine). [Show More]

Last updated: 2 years ago

Preview 1 out of 15 pages