QI) 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- update the record data of the ministry of education in ministry table. 2- Find the employees who live in Basra and work as a driver in Ministry of finance. 3- Find the name of employees who work as a manger in ministries that have more than 100 employee and lies in baghdad city.

QI) 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- update the record data of the ministry of education in ministry table. 2- Find the employees who live in Basra and work as a driver in Ministry of finance. 3- Find the name of employees who work as a manger in ministries that have more than 100 employee and lies in baghdad city.

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

4. This question continues from Q3. (a) Write the insert SQL to populate the Zoom, BB, and the QR tables with the values given below. For each table, use only one insert to complete the insert task. The Duration column is initially empty. (b) Can you insert the ZOOM table first? Provide a reason according to the relational database theory if it is not possible. (c) Write a Delete SQL to remove student ‘M M’ from the BB table. If it is not possible to remove the row, provide a reason according to the relational database theory. You must not use SID in the SQL because only the name is given. (d) Write an Update DML that will compute and update the duration in minutesin the Zoom table. Show the updated table and the DML.
use national join plz QI/ Consider the education database with student and school tables, where the primary keys are underlined. Give an expression in SQL for each of the following queries. Student(studentlID. full_name, sat_score, age, school_name) School(school name, street, city, country) 1- find the street and the city of all schools in England. 2- Find the school street, city, country, and the name of students who their school in 'West Carter' street. 3- Display the age and id of student that study in spanish. schools
Computer Science provide SQL code (Use the EBOOKS database) When a course is offered in several sections taught by more than one instructor, students have the ability to choose an instructor, otherwise they have no choice. The deans of each college would like to know how many courses have only one section in the schedule, how many courses have more than 1 section, but taught by the same instructor, how many courses have sections taught by more than one instructor. Sort the results alphabetically by College ID as shown below: COLLEGE SINGLE_SECTION MULTISECTION_ONE_INSTRUCTOR MULTIPLE_INSTRUCTORS CAS 83 21 22 CED 76 8 39 COB 72 16 13
Assume the e-commercial database shown in the Appendix. Write the following queries in (a) relational algebra and (b) SQL. State your assumptions if the semantics is not clear. 1) Find the names of all students who have taken courses in both the Computer Science and Mathematics departments. APPENDIX - You may detach this page from the exam: STUDENTS(student id, first_name, last _name, email, major_code, class_year) COURSES(course id, course_name, course_description, credits, department_code) ENROLLMENTS(student id, course id, semester, grade) MAJORS(major code, major_name, department_code) DEPARTMENTS(department code, department_name)
Consider the following relations: BRANCH (branch no, street, area, city, degree, Tel_no, Fax_no) STAFF (Staff no, Fname, Lname. address, position, salary, branch_no) Write the following queries in SQL: 1. Find all the branches that number less than 453 and found in area '34 east 2. Find staff whose salary is greater than the salary of evcry member of staff at branch 71. 3. List all stalf who their last name ends with ith'. 4. Find all the staff that works in branch 345 and have salary between 15000 and 45000.
You are working with a database table that contains invoice data. The table includes columns for invoice_id and billing_state. You want to remove duplicate entries for billing state and sort the results by invoice ID. You write the SQL query below. Add a DISTINCT clause that will remove duplicate entries from the billing_state column. NOTE: The three dots (...) indicate where to add the clause. SELECT ... FROM invoice ORDER BY invoice_id What billing state appears in row 17 of your query result? 1 point 1-CA 2-NV 3-WI 4-AZ
Make use of the institution's structure in a SQL query to identify non-students. Avoid using set operations and subqueries (use an outer join).
I need the answer as soon as possible
Subject : Data base management system( MY SQL LIVE) NOTE: write queries for following. 1. Make a table bonus (bonus Id, bonus amount, department no), insert information of multiple departments with department numbers 2, 4, 10, 15, 20 and 25. 2. Delete row when department no is equal to 20, 3. Increment bonus amount when department no is equal to 10 , 4. Delete row where department is between 10 and 20. 5. Delete rows where department number is greater than 20