Question
Need help, as i dont quite understand. Using MySQL Workbench: Create a new schema for this lab In the Lab07DB.sql file, add a USE statement
Need help, as i dont quite understand. Using MySQL Workbench: Create a new schema for this lab In the Lab07DB.sql file, add a USE statement in line 1, specify the schema name you just created. Import the data from Lab07DB.sql Create a second new schema for this lab In the dept_emp.sql file, add a USE statement in line 1, specify the second schema name you just created. Import the data from dept_emp.sql Following the steps in Lab 4: Reverse engineer the first newly created schema. Reverse engineer the second newly created schema. These new models will be needed to perform the following tasks. Before proceeding with tasks 3 and 4, analyze the data in each of the tables and familiarize yourself with the two models. For the Lab07DB schema, complete the following requirements: Display the professor name, professor program, student first and last names from the student and professor tables. Refering to the model created in step 2, determine the PK/FK relationships to build the SQL joining the three tables. Sort the data by professor name then by student last name. Display the professor name and students first and last names who are being mentored. The output should be sorted by professors name, students last name then first name. The Mentor column on the student_professor table determines if a student is being mentored; value of 0 = no, 1 = yes. Display all columns from the professor table where the professor is identified as a mentor in the student_professor table. A subquery is to be used to determine the mentor status of a professor. For the dept_emp schema, complete the following requirements: Display all contents from the Departments and Employees tables, only employees who are assigned to a department should be displayed. Using the same SQL as 4a, modify it to include employees who are not yet assigned to a department. Using the same SQL as 4a, modify it to include departments who do not yet have any employees working in it
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started