Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the following Schema, and company data.sql answer the following questions: EMPLOYEE Frame Minit Lname Sen Bdate Address DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date

image

Based on the following Schema, and company data.sql answer the following questions: EMPLOYEE Frame Minit Lname Sen Bdate Address DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation. PROJECT Pname Pnumber Plocation. Dnum WORKS ON Esan Pno. Hours Sex Salary Superssn Dno DEPENDENT Esan Dependent name Sex Bdate Relationship Q1: Write a statement that displays each employee name as (Employee_Name), dependent name and each dependent age in years without fractions. Q2: For each department, find the number of employees who belong to it. Q3: Write a statement that displays the Dependent_name and birth date for the oldest Dependent. Q4: Write a statement that displays each employee name of the projects that worked on, then sort the results according to employee name from (z-a or Z-A). Q5: Retrieve the project name and hours worked on that project in which hours are equal to the maximum hours worked on the projects.

Step by Step Solution

3.49 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

1 Select EMPLOYEEFname as EmployeeName DEPENDENT Dependentname Yea... 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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant Navathe

7th Edition

0133970779, 978-0133970777

Students also viewed these Electrical Engineering questions

Question

Why are stocks usually more risky than bonds?

Answered: 1 week ago