2.15 Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: branch(branch_name, branch_city, assets) customer (ID, customer name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (ID, loan_number) account (account_number, branch_name, balance) depositor (ID, account_number) Figure 2.18 Bank database. A. Find each loan number with a loan amount greater than $10000. B. Find the ID of each depositor who has an account with a balance greater than $6000. C. Find the ID of each depositor who has an account with a balance greater than $6000 at the "Uptown" branch.

2.15 Consider the bank database of Figure 2.18. Give an expression in the relational algebra for each of the following queries: branch(branch_name, branch_city, assets) customer (ID, customer name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (ID, loan_number) account (account_number, branch_name, balance) depositor (ID, account_number) Figure 2.18 Bank database. A. Find each loan number with a loan amount greater than $10000. B. Find the ID of each depositor who has an account with a balance greater than $6000. C. Find the ID of each depositor who has an account with a balance greater than $6000 at the "Uptown" branch.

Database Systems: Design, Implementation, & Management

11th Edition

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:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

write queries in relational algebra
relational algebra
Quiz 1 العودة 00: all cö Given the following database schema: Customer(cid., cname , rating, salary) Item(iid, iname , type ) Ooder(cid, iid , day , gty ) what is the relational algebra that retrieve the names of customers who have ordered item with id 100 .a .All choices are correct .b 1ramelo iid=100 'iid=100 (OrderCustomer)) .C iid=100 1-100Order)aCustomer) .d (Order) templ<-o temp2<-templdCustomer Ocname(temp2) iid=100
2. The following relational schema form a university database which is implemented in a relational database: student (s_ID, s_name, semester, year) department(d_ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the Relational Algebra for the following queries: a) Find your own name using your own registration number as the student ID. b) Show the ID and name of the department located at the floor number equals to the last digit of your own registration number. c) Find the codes and titles of the courses having credits more than 3 credits. d) Find the name of all students from your own semester and year.
In order to demonstrate a single row function within a database, we employed a function referred to as "single row". Is the function scalar or vector-valued? Which option is superior?
DATABSE
Also Draw Schema Diagram
QUESTION 1 SQL: Consider the following database schema for flight reservation database. A flight can be booked by many passengers, and a passenger can book different flights. For each booking, the date of the flight and price are recorded. The database schema is given below Flight (FID:int, Airline:string(unique), DepartingAirport:string, ArrivalAirport:string, Rating: int (1,2,3,4,5) ) Booking (FlightID: int, PassengerCPR: int, Date: date, Time: time, Price: double) Passenger (CPR:int, FirstName: String, LastName: String, Address:String) Write SQL Code to: Create the Flight Table.List the Departing Airport and Arrival Airport for all flights with rating 4 or 5.
Wrong answer would downvoted So please give right answer
Formulate the following queries in: Relational Algebra. The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, salary, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) where Employee contains employee details and empNo is the key. Department contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager foreach department. Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project). WorksOn contains details of the hours worked by employees on each project, and empNo/ projNo/dateWorked form the key. Formulate the following queries in: Relational Algebra. Produce a list of the names of all employees who work on the Biometric project. Produce a report of all projects under the IT…
Formulate the following queries in: Relational Algebra. The following tables form part of a database held in an RDBMS: Employee (empNo, fName, lName, address, DOB, sex, position, salary, deptNo) Department (deptNo, deptName, mgrEmpNo) Project (projNo, projName, deptNo) WorksOn (empNo, projNo, dateWorked, hoursWorked) where Employee contains employee details and empNo is the key. Department contains department details and deptNo is the key. mgrEmpNo identifies the employee who is the manager of the department. There is only one manager foreach department. Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project). WorksOn contains details of the hours worked by employees on each project, and empNo/ projNo/dateWorked form the key. Formulate the following queries in: Relational Algebra. List all the details of employees who are female and born after 1990. List employee numbers and names of all employees who are not…
Consider the following database schema for University Library database. A student can borrow many books and a given book can be borrowed by any student if it is available in the library. For each borrowing, the borrowing and return dates are registered in the database. Student (SID: long, CPR:long (unique), Name:string, tel:number, major:String, gender:Character {'F' or 'M'}) Book (ISBN:long Title:string (unique), Author:string) BorrowedItems(stSID:long, book|SBN:long, serialNo:int (unique), BorrowingDate:date, ReturnDate:date) Write SQL statements to: 1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN. 2. List SID, Name, and Major of all female students doing major in CS'and their name starts with 'S'. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).

SEE MORE QUESTIONS

Recommended textbooks for you

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

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS