ID 1001 1002 1003 1004 1005 1006 Employee Employee Name Salary ename Eman Ali Moosa innan Hessa Alaa Mariam m sal 550 600 900 300 600 800 Employee Phone Number empno 39999999 39999998 39999997 39999996 39999995 39999994 Emp job Developer CS HR Network Server SE Department number deptno 10 20 40 30 30 10 Department name dname IT Registration Admin Date of hiering hiredare 3/3/2000 3/4/2000 3/5/2000 Engineering 3/6/2000 Engineering 3/7/2000 IT 3/8/2000 From the above table, Answer the questions: Q1) Write a query that count the employees in each department? Q2) Write a query that retrieve all employees information who are in 'Hessa' department? Q3) Write a query that find the number of the employees in each department which salaries total greater than or equal the salaries total of department 30? Q4) Modify the information for the employee whose ID 1004, change the job to Writer? Q5) Delete the employees data who have same salary of the employee has ID is 1002? Q6) Write query that display ID, ename, sal, deptno, dname, hiredate for all employees.

ID 1001 1002 1003 1004 1005 1006 Employee Employee Name Salary ename Eman Ali Moosa innan Hessa Alaa Mariam m sal 550 600 900 300 600 800 Employee Phone Number empno 39999999 39999998 39999997 39999996 39999995 39999994 Emp job Developer CS HR Network Server SE Department number deptno 10 20 40 30 30 10 Department name dname IT Registration Admin Date of hiering hiredare 3/3/2000 3/4/2000 3/5/2000 Engineering 3/6/2000 Engineering 3/7/2000 IT 3/8/2000 From the above table, Answer the questions: Q1) Write a query that count the employees in each department? Q2) Write a query that retrieve all employees information who are in 'Hessa' department? Q3) Write a query that find the number of the employees in each department which salaries total greater than or equal the salaries total of department 30? Q4) Modify the information for the employee whose ID 1004, change the job to Writer? Q5) Delete the employees data who have same salary of the employee has ID is 1002? Q6) Write query that display ID, ename, sal, deptno, dname, hiredate for all employees.

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

Similar questions

What six traits distinguish relational databases?
Describe various data modeling techniques used to represent the structure and relationships within a database. Discuss the Entity-Relationship (ER) model, object-oriented modeling, and relational modeling, highlighting their strengths, limitations, and suitability for different database applications.
Discuss briefly the three phases of database design.
Discuss the role of database virtualization and containerization technologies in modernizing database architectures.
Explain the reasons for three level database architecture ?
Do a comparison of on-premise and cloud-based database management systems.
Describe the challenges and strategies for scaling and optimizing database systems in large-scale, high-traffic applications.
Discussion of two database design issues that are important to the development of Web-based applications in detail
Analyze the emerging trends in database development, including the adoption of serverless databases and database as a service (DBaaS).
What six traits distinguish relational databases?
Describe the key principles and advantages of a distributed database management system.
Justify each of the three design objectives for relational databases.