Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts Of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

4th Edition

0619064625, 978-0619064624

More Books

Students also viewed these Databases questions

Question

Why do everyone trade in the comparative Advantage explain?

Answered: 1 week ago

Question

A z score of -1.96 is a critical value : Select one: O True O False

Answered: 1 week ago