Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet, position, ministry_name) Ministry(ministry_name, address,No_of_employee, No_of_dept., category) 1- Find all employees who work as consultant in ministeries that have more than 7 departments. 2- Find the ministries that have less than 50 employees and lies in Baghdad. 3- delete the all employees that have salary greater than 150000 or between 15000 and 20000

Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet, position, ministry_name) Ministry(ministry_name, address,No_of_employee, No_of_dept., category) 1- Find all employees who work as consultant in ministeries that have more than 7 departments. 2- Find the ministries that have less than 50 employees and lies in Baghdad. 3- delete the all employees that have salary greater than 150000 or between 15000 and 20000

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter7: Introduction To Structured Query Language (sql)

Section: Chapter Questions

Problem 3P

See similar textbooks

Similar questions

Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet, position, ministry_name) Ministry(ministry name, address,No_of_employee, No_of_dept., category) 1- Find all employees who work in ministery of foreign affairs And their age less than 33. 2- find the ministries that have at least 6 department and order them by their address.
Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet, position, ministry_name) Ministry(ministry name, address,No_of_employee, No_of_dept., category) 1- Find all employees who work as manger in ministery of foreign affairs or ministry of education and their salary greater than 40. 2- Find the adress of employees who have salary between 15000 and 20000 and work as a driver in ministries that have more than 50 employees. 3- delete the all munisteries that have more that 6 deparments and 70 employees
Assignment III (5%): Design of the conceptual model (ERD) from the given relational database. (Note: students has to give appropriate labels on relationships and type of relationships between the entities) Use the same Assignment- I schema to perform the PL/SQL programs Q1. The management of the organization has decided to increase the salaries of all employees to 15% for this, write a PL/SQL block to accept the employee number and to update the salary of that employee. Display the output based on the existing records of the employees. (2 marks) Q2. having the employee age above 40 years. (2 marks) Create a PL/SQL a cursor program that will increase the employee salary to 25% who are Q3. where place belongs to Ibri, dunk or Yanul (hint: Project (projectID. projectName, place, start Year, end Year, #DepartmentID) (2 marks) Write a PL/SQL procedure to change the name of the project to "AL Dahariyah Projects"
Consider the following database tables: Employee (empNo, empName, street, city) Works (empNo. companyName, joiningDate, salary, deptNo) Employee salary (empNo, basic, total deduction, net salary, gross salary) Write a PL/SQL code to display employee number, name and basic salary of the 5 highest paid employees.
Write a Structured Query Language (SQL) statement for each of the following questions:a) Create the AppointmentDetails table with the following requirements:  Appropriate data types. All keys can store between 6 to 10 characters. All the columns must have values (cannot be empty). Add on charges is set to 0.00 by default. Enforce entity and referential integrities. b) Diplay the therapists’ particulars (include TheraName, TheraContact) as first two columns, then calculate the Total_Count_Of_Appointment for each therapist within the year 2020 as third columns. Lastly, arrange the outcome to show the list by the higher popularity of therapists first.
Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age, address, salary, departmet, position,ministry_name) Ministry(ministry name, address,No_of_ employee, No_of_dept., category) 1- Find all employees who work in ministery of foreign affairs And their age less than the average age all the employees who work in the ministery of education. 2- Find the name of employees who work as a manger in ministries that have more than 100 employee and lies in baghdad city.
Q1) Consider the employees database , where the primary keys are underlined. Give an expression in SQL for each of the following queries. Employee(ID. name, age, address, salary, departmet, position,ministry_name) Ministry(ministry_name, address,No_of _employee, No_of_dept., category) 1- Find all employees who live in baghdad and work in ministery of foreign affairs And older than all the employees who work in the consuls department. 2- Find the name of employees who work as a counselor in ministries that have more than 5 departments . 3- Insert a new employee (o the database.
Write SQL Queries for following set of tables:EMPLOYEE (EmpNo, Name, DoB, Address, Gender, Salary, DNumber)DEPARTMENT (DNumber, Dname, ManagerEmpNo, MnagerStartDate).i) Display the Age of ‘male’ employees.ii) Display all employees in Department named ‘Marketing’.iii) Display the name of highest salary paid ‘female’ employee.iv) Which employee is oldest manger in company?v) Display the name of department of the employee ‘SMITH’..
a) from university database , Write the following queries in SQL Find the titles of courses in the Comp. Sci. department that have 3 credits Find all instructors earning the highest salary (there may be more than one with the same salary) Find all courses that have never been offered (i.e., do not occur in the section relation). b) given the following tables( instructor, teaches) what is the output of the following query select i.name from instructor as i, teaches as t where i.ID=t.ID and semester=’ Fall’ and year=2017;
Consider the following schema(keys are underline); Product(pid,name,type,manufacturer,price), (Buys(cid,pid), Customer(cid,cname,age,gender) Write the following query in SQL. Find the names and cid of all customers who have purchased the second most expensive product. You can assume that no two products have the same price.
Using the relational database given in lab work no. 2, write the following queries in SQL: 1) 2) 3) 4) How many instructors are advising more than three students?5) Which department has the highest number of students?6) Which courses have multiple prerequisites? Sort the list. You should also present the output of each query in the lab report. ========================================== Please dont answer to this : The relational database schemas are as follows:department(dept-name, building, budget)instructor(ID, name, dept-name, salary)student(ID, name, dept-name, tot-cred)advisor(s-ID, i-ID)course(course-id, title, dept-name, credits)teaches(ID, course-id, sec-id, semester, year)takes(ID, course-id, sec-id, semester, year, grade)classroom(building, room-number, capacity)time-slot(time-slot-id, day, start-time, end-time)section(course-id, sec-id, semester, year, building, room-number, time-slot-id)prereq(course-id, prereq-id)
a) Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname and occupation do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “Flacq”. customer is at least 18 years old. Salary is above Rs 25000. (b) Consider the schema of Customer table in part(a) and write SQL query to set salary of all administrators to Rs 50 000.

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS