Consider the schema of 2 tables below, and then answer the question about it. employee (ID, emp_name, address) works (ID, company_name, salary) List the ID, name, address of all employees who works for "Arab Bank". Select one: O A. SELECT ID, emp_name, address FROM employee, works WHERE employee.ID = works.ID AND company_name = "Arab Bank" O B. SELECT ID, emp_name, address FROM employee, works WHERE company_name = "Arab Bank" O C. SELECT ID, emp_name, address FROM employee, works WHERE employee.ID == works.ID AND company_name == "Arab Bank" O D. SELECT ID, emp_name, address FROM employee, works WHERE employee.ID = works.ID OR company_name = "Arab Bank"

Consider the schema of 2 tables below, and then answer the question about it. employee (ID, emp_name, address) works (ID, company_name, salary) List the ID, name, address of all employees who works for "Arab Bank". Select one: O A. SELECT ID, emp_name, address FROM employee, works WHERE employee.ID = works.ID AND company_name = "Arab Bank" O B. SELECT ID, emp_name, address FROM employee, works WHERE company_name = "Arab Bank" O C. SELECT ID, emp_name, address FROM employee, works WHERE employee.ID == works.ID AND company_name == "Arab Bank" O D. SELECT ID, emp_name, address FROM employee, works WHERE employee.ID = works.ID OR company_name = "Arab Bank"

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

Find the names of all the managers who manage more than 10 employees.
Given the following table schemas (definitions) where "bid" is boat id, "name" is boat name, "sname" is sailor name and "sid" is sailorid: Sailors(sid: integer, sname: string, rating: integer, age: real) Boats(bid: integer, bname: string, color: string) Reserves(sid: integer, bid: integer, day: date) Which one of the below given queries "Finds the names of sailors who have reserved two different boats on the same day." SELECT S.sname, FROM Sailors S, Reserves R1, Reserves R2 WHERE (S.sid - R1.sid OR S.sid - R2.sid) AND (R1.day R2.day AND R1.bid R2.bid) Ob SELECT S.sname, FROM Sailors S, Reserves R1, Reserves R2 WHERE R1.sid = R2.sid AND R1.day-R2.day AND R1.bid R2.bid O SELECT S.sname. FROM Sailors S, Reserves R1, Reserves R2 WHERE R1.sid-R2.sid AND R1.day=R2.day AND R1.bid = R2.bid Od. SELECT S.sname, FROM Sailors S, Reserves R1, Reserves R2 WHERE S.sid -R1.sid AND S.sid - R2.sid AND R1.day=R2.day AND R1.bid =R2.bid O SELECT S.sname. FROM Sailors S, Reserves R1, Reserves R2 WHERE…
For the following Student table, find all the possible functional dependencies that arehe ld.Schema: Student (Regno, Name, DOB, Phone, Instructor_ID, Instructor_Name, Instructor_Office)Gender, Course_ID, Course_Na me ,Regno Name 14M01 Kumar 14M05 Mary 14M07 Ram 14M01 Kumar 14B01 Revathi 14M09 Steve 14B03 RamyaDOB 12-Jan-1996 10-Jun-1995 10-May-1996 12-Jan-1996 10-Dec-1995 23-Oct-1995 20-Jul-1996Phone 12345 12367 12898 12345 23456 34567 23456Gender CID M C1 F C1 M C1 M C3 F C3 M C4 F C4CNam
Schema: Part(PartNo, PartName, VehicleType, UnitPrice, SalesPrice) Service(ServiceNo, PartNo, ServiceDate, CustomerNo, Qty) Constraints: i. Vehicle Type should be V1', V2', 'V3', 'V4', or 'V5' ii. UnitPrice and SalesPrice should be greater than zero iii. PartNo, FK in Service refers to PartNo, PK in Part Data: Part Service P1 V1 10 12 1 01-Jan-17 C1 P2 V2 100 110 3 01-Jan-17 C1 4 P3 V1 150 175 2 3 05-Feb-18 C2 10 P4 V3 200 250 3 1 15-May-18 Сз 9. P5 V2 75 90 1 03-Jun-19 C1 A. Write the following queries in SQL: i. List the Part Names which are not used to service the vehicle of any customer. ii. List the customer number who has got his vehicle serviced maximum number of times. iii. List the customer number whose vehicle service used all the parts of vehicle type V1. B. Write a PL/SQL program to find the total profit done in the sales of a given part number in the service of different customer vehicles. Raise an exception for invalid part number. 12345n
Schema: Part(PartNo, PartName, VehicleType, UnitPrice, SalesPrice) Service(ServiceNo, PartNo, ServiceDate, CustomerNo, Qty) Constraints: i. Vehicle Type should be V1', V2', 'V3', 'V4', or 'V5' ii. UnitPrice and SalesPrice should be greater than zero iii. PartNo, FK in Service refers to PartNo, PK in Part Data: Part Service P1 V1 10 12 1 01-Jan-17 C1 P2 V2 100 110 3 01-Jan-17 C1 4 P3 V1 150 175 2 3 05-Feb-18 C2 10 P4 V3 200 250 3 1 15-May-18 СЗ 9. P5 V2 75 90 1 03-Jun-19 C1 Write a PL/SQL program to find the total profit done in the sales of a given part number in the service of different customer vehicles. Raise an exception for invalid part number. 12345n
2. Consider the following schema: Books (book id, title, year, pub_id, auth_id, price) Authors(auth_id, name, nationality) Publisher(pub_id, name) Sales(copies_sold, book_id, copies_printed) Write down the relational algebra expressions for the following queries a) Give the count of the books published by Pearson each year. b) Name the authors who wrote some book in 2015 and 2016 priced above 200 rupees. c) List the title, author name and publisher name of books written by Indian authors in the year 2019 d) List the publisher IDs with least number of books printed in 2020 e) List the publisher who made profit<500 (profit= book price* (copies printed – copies sold) f) List the author whose books are priced the highest.
branch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer. city) loan (loan.number, branch.name, amount) borrower (customer name, loan_number) account (account_number, branchname, balance) depositor (customer_name, account number) Figure 2: For solving Question 2 Question # 3: With respect to Figure 2, show Functional Dependencies, Primary Keys and Foreign Keys in the relations.
1A. Consider the bank database schema as below. loan (loan_number, branch_name, amount) account (account_number, branch_name, balance) depositor (customer_name, account_number). Give a relational algebra expression for following queries: a. Find all loan numbers with a loan value greater than $25,000. b. Find the names of all depositors who have an account with a value greater than $10,000 at the "Manipal" branch. 1B. Identify and list at least 3 Tables with 5 attributes (Including primary key), which might be used to create Database for a Social-Networking system like Facebook.
Consider applications “Q1”, “Q2”, “Q3”, and “Q4” as shown. These applications work on the table STUDENTS defined as “STUDENTS (RNO, NAME, ADDRESS, SEM, MARKS),” where RNO is the primary key column of the table. Q1: Select NAME from STUDENTS where MARKS = 100; Q2: Select MARKS from STUDENTS; Q3: Select SEM from STUDENTS where ADDRESS = ‘RWP’; Q4: Select NAME from STUDENTS where SEM = 6;Perform vertical fragmentation?frequency matrixCalculate usage matrix, Attribute affinity matrix, and Clustered affinity matrix?
Consider applications “Q1”, “Q2”, “Q3”, and “Q4” as shown. These applications work on the table STUDENTS defined as “STUDENTS (RNO, NAME, ADDRESS, SEM, MARKS),” where RNO is the primary key column of the table. Q1: Select NAME from STUDENTS where MARKS = 100; Q2: Select MARKS from STUDENTS; Q3: Select SEM from STUDENTS where ADDRESS = ‘RWP’; Q4: Select NAME from STUDENTS where SEM = 6; Perform vertical fragmentation? S1 S2 S3 S4 Q1 1 0 2 0 Q2 0 4 3 0 Q3 0 0 4 0 Q4 3 0 0 0 frequency matrix Calculate usage matrix, Attribute affinity matrix, and Clustered affinity matrix? Calculate Split point?
Give employee Id, name, and date hired of the managers who have the highest experience (years employed) order by employee name. If there is more than one employee with the highest experience, show all. Q1.2 : Give all manager names and date hired for managers whose work experience is higher than the work experience of their employees. List results in managers' name order. Q1.3: List Material ID and Product Id in which the Material has the highest quantity required for this material. List results in order of Material ID. Q1.4: For products that have used materials, show the product ID, product description, material ID, and quantity required of materials whose quantity required is higher than the average quantity required for that material. Sort the results by product ID and then by material ID
SQL: Consider the following relational schema: Staff (staffNo, name, dept, skillCode) Skill (skillCode, description, chargeOutRate) Project (projectNo, startDate, endDate, budget, projectManagerStaffNo) Booking (staffNo, projectNo, dateWorkedOn, timeWorkedOn) where: Staff contains staff details and staffNo is the key. Skill contains descriptions of skill codes (e.g. Programmer, Analyst, Manager, etc.) and the charge out rate per hour for that skill; the key is skillCode. Project contains project details and projectNo is the key. Booking contains details of the date and the number of hours that a member of…