Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

data base OG Based on the following Schema, and company data.sql answer the EMPLOYEE NA DERTMENT Damen Mor DEPT LOCATIONS De Occasion PROJECT Prame Porto

data base
image text in transcribed
OG Based on the following Schema, and company data.sql answer the EMPLOYEE NA DERTMENT Damen Mor DEPT LOCATIONS De Occasion PROJECT Prame Porto Drum WORKS ON Hours DEPENDENT En Decindentame SOR Bdato 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. 04: Write a statement that displays each employee name of the projects that worked on, then sort the according to employee name from (z-a or Z-A) 5: Retrieve the project name and hours worked on that project in which hours are equal to the ma urs worked on the projects

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

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

More Books

Students also viewed these Databases questions

Question

What factors affect the steepness of the AS curve?

Answered: 1 week ago