1. Write an SQL Query to list the department number and the count of projects in each of these departments and only display those values that has more than 3 count. Rename the count column as ‘Project Count’. Use GROUP BY and HAVING. 2. Write an SQL Query to count unique ‘Female’ employees who have been designated as ‘Staff’ and also have worked for more than 20 hours on a single project? Rename the count value as ‘Employee Count’ (Hint: Use Table Joining)Just please help me write the querey based on the picture The image shows a schema outlining the structure of a database for managing employee records. The schema includes five entities, with their corresponding attributes and foreign keys highlighted.1. **Employee** - Attributes: - `empNo` (Employee Number, Primary Key) - `firstName` (First Name) - `lastName` (Last Name) - `address` (Address) - `DOB` (Date of Birth) - `sex` - `position` - `deptNo` (Department Number, Foreign Key)2. **Department** - Attributes: - `deptNo` (Department Number, Primary Key) - `deptName` (Department Name) - `mgrEmpNo` (Manager Employee Number, Foreign Key)3. **Project** - Attributes: - `projNo` (Project Number, Primary Key) - `projName` (Project Name) - `deptNo` (Department Number, Foreign Key)4. **WorksOn** - Attributes: - `empNo` (Employee Number, Foreign Key) - `projNo` (Project Number, Foreign Key) - `hoursWorked`5. **Dependent** - Attributes: - `empNo` (Employee Number, Foreign Key) - `Dependent_name` (Dependent Name, Primary Key) - `Sex` - `Bdate` (Birthdate) - `Relationship`Primary keys are emphasized to uniquely identify each record within their respective tables, while foreign keys are highlighted to indicate references between tables. These relationships help maintain data integrity across the database.

Solution- We have create an query for each of them in step by step manner.Here, we look for patterns…

Answered: Employee (empNo, firstName, lastName,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

1. Write an SQL Query to list the department number and the count of projects in each of these departments and only display those values that has more than 3 count. Rename the count column as ‘Project Count’. Use GROUP BY and HAVING.

2. Write an SQL Query to count unique ‘Female’ employees who have been designated as ‘Staff’ and also have worked for more than 20 hours on a single project? Rename the count value as ‘Employee Count’ (Hint: Use Table Joining)

Just please help me write the querey based on the picture

The image shows a schema outlining the structure of a database for managing employee records. The schema includes five entities, with their corresponding attributes and foreign keys highlighted.

1. **Employee**
- Attributes:
- `empNo` (Employee Number, Primary Key)
- `firstName` (First Name)
- `lastName` (Last Name)
- `address` (Address)
- `DOB` (Date of Birth)
- `sex`
- `position`
- `deptNo` (Department Number, Foreign Key)

2. **Department**
- Attributes:
- `deptNo` (Department Number, Primary Key)
- `deptName` (Department Name)
- `mgrEmpNo` (Manager Employee Number, Foreign Key)

3. **Project**
- Attributes:
- `projNo` (Project Number, Primary Key)
- `projName` (Project Name)
- `deptNo` (Department Number, Foreign Key)

4. **WorksOn**
- Attributes:
- `empNo` (Employee Number, Foreign Key)
- `projNo` (Project Number, Foreign Key)
- `hoursWorked`

5. **Dependent**
- Attributes:
- `empNo` (Employee Number, Foreign Key)
- `Dependent_name` (Dependent Name, Primary Key)
- `Sex`
- `Bdate` (Birthdate)
- `Relationship`

Primary keys are emphasized to uniquely identify each record within their respective tables, while foreign keys are highlighted to indicate references between tables. These relationships help maintain data integrity across the database.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions