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

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.