in SQL 1.Create a data base (company)3.Retrieve all the2.Create two tables in the database:attribute values fromeach table.Employeeemployee noe nameSalaryphoned nowmoon4. Display sum of salariesfor each d artmentwhere the sum of salariesmore than 6000?1456Ahmad4000055555888811457Khaled4500055555333321458Ahmad3000055555444431459Mohamed6000055555577741460Noor5000055555333425. Retrieve the details ofemployees whose salaryis greater than theminimum salary of theemployees working indept number 2 and alsohe is not working in deptDepartment-d nod namemanager_no1CS1457IS1459SE1444CS1433CS1411Note: d no in Department is primary key.number 237 1. Create a data base (company)2.Create two tables in the database:3. Retrieve e name,d no from Employeeand d name fromdepart. ent by Inner„left and right join?employee nohameSalaryphoned no1456Ahmad4000055555888811457Khaled450005555533331458Ahmad3000055555444431459Mohamed6000055555577741460Noor5000055555333421461Waleed70000555553222NULLd nod namemanager noCS1457iS1459SE1444NT14334SS1411Note: d no in Department is primary key.

1. create database company_lab4;use company_lab4; 2. create table employee(employee_no int primary…

1. Create a data base (company) 3.Retrieve all the 2. Create two tables in the database: attribute values from Employee employee no each table. e name Salary phone d no 4. Display sum of salaries for each dartment where the sum of salaries 1456 Ahmad 4000 0555558888 1 1457 Khaled 4500 0555553333 1458 Ahmad 3000 0555554444 3 1459 Mohamed 6000 0555555777 4 more than 6000? 1460 Noor 5000 0555553334 2 5. Retrieve the details of Department d no employees whose salary is greater than the minimum salary of the employees working in dept number 2 and also he is not working in dept d_name manager_no 1 CS 1457 IS 1459 SE 1444 4. CS 1433 5 CS 1411 Note: d no in Department is primary key. number 2

1. Create a data base (company) 3.Retrieve all the 2. Create two tables in the database: attribute values from Employee employee no each table. e name Salary phone d no 4. Display sum of salaries for each dartment where the sum of salaries 1456 Ahmad 4000 0555558888 1 1457 Khaled 4500 0555553333 1458 Ahmad 3000 0555554444 3 1459 Mohamed 6000 0555555777 4 more than 6000? 1460 Noor 5000 0555553334 2 5. Retrieve the details of Department d no employees whose salary is greater than the minimum salary of the employees working in dept number 2 and also he is not working in dept d_name manager_no 1 CS 1457 IS 1459 SE 1444 4. CS 1433 5 CS 1411 Note: d no in Department is primary key. number 2

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

SQL Database Designs What do you think is the most important concept in SQL Database Designs
A real-world SQL database may be given and explained?
What is the need for transactions in SQL?
Is it possible to use PL/SQL or T-SQL procedures on MySQL?
To what extent does SQL diverge from standard programming languages?
Explain about Tuple relational calculus (TRC) and Domain relational calculus (DRC)
How to import mysql databases using console sql statement?
Computer Science write a sql script to change only the first character in a given full name into capital letter(only the begining of the names is capitalized ) add explanation in the steps
What distinguishes Structured Query Language (SQL) from other computer languages?
What are the Automated SQL injection attacks using sql map
SQL Database Explain the function and importance of the SQL COMMIT command and list the pros/cons of using Autocommit mode.