Answer the following queries using relational algebra operators 1.List all branch names and their assets 2. List all accounts of Brooklyn branch 3. List all loans with amount > 1000 4. List all accounts of Perryridge branch with balance < 1000 5. List Numbers of accounts with balances between 700 and 900

Answer the following queries using relational algebra operators 1.List all branch names and their assets 2. List all accounts of Brooklyn branch 3. List all loans with amount > 1000 4. List all accounts of Perryridge branch with balance < 1000 5. List Numbers of accounts with balances between 700 and 900

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter2: Data Models

Section: Chapter Questions

Problem 21RQ

See similar textbooks

Similar questions

You are given the following schema of a University, where primary keys of each table areunderlined and symbol (#) symbolises foreign keys:Student (student_id, first_name, last_name, date_of_birth)Course (course_id, #professor_id, course_name, credits, programme)Exam (#student_id, #course_id, exam_date, grade)Professor (professor_id, first_name, last_name, research_field) -Use RELATIONAL ALGEBRA to write the following queries:a) Find names and surnames of professors, who teach a course in "Biology" programmeb) Find the student IDs and names of students who have not taken any exam (from any course)c) Find student IDs of students who have passed every exam from "Data Science" programmed) Find the course IDs and names of courses that have been passed by at least two differentstudents (If a course was taken, it means that a student wrote an exam on that course)
You are given the following schema of a University, where primary keys of each table areunderlined and symbol (#) symbolises foreign keys:Student (student_id, first_name, last_name, date_of_birth)Course (course_id, #professor_id, course_name, credits, programme)Exam (#student_id, #course_id, exam_date, grade)Professor (professor_id, first_name, last_name, research_field) -Use DOMAIN or TUPLE RELATIONAL CALCULUS to write thefollowing queries:a) Find the last names of professors who have taught a course with 6 creditsb) Find all student IDs of students who are born before January 1, 1999 or have passed at leastone exam with a 10c) Find the last names of professors who have never taught a coursed) Find the last name(s) of the professor(s) who teach the most courses
Database Systems Question 6. Consider the following relation: Invoice(Order_ID, Order_Date, Customer_ID, Customer_Name,Customer_Address,Product_ID, Product_Desc, Price, Order_Quantity) FD1 - Order_ID -> Order_Date, Customer_ID, Customer_Name, Customer_Address FD2 - Customer_ID -> Customer_Name, Customer_Address FD3 - Product_ID -> Product_Description, Price FD4 - Order_ID, Product_ID -> Order_Quantity What are the candidate keys of this relation? Give reasons to explain if this is in 1NF or not. If not, decompose it to 1NF. Give reasons to explain if this is in 2NF or not. If not, decompose it to 2NF. Give reasons to explain if this is in 3NF or not. If not, decompose it to 3NF.
If any of the following choices are applicable, please tick them. This model includes entities like as customers and accounts; employees; checks; and transactions. Using recursive relationships correctly, which of the following is the proper choice?(A) Checks drawn on a checking or savings account are referred to as "checks."Bank transactions that are both credit and debit belong to the same account, as do checks, and so do employees and their managers.
Consider the following shorthand representation of a relational database used by a book publisher to answer the following questions.BRANCH (BRANCH_NUM, COUNTRY, NUM_EMPLOYEES) WRITER (WRITER_NUM, LAST_NAME, FIRST_NAME, BOOK_NUM) BOOK (BOOK_NUM, TITLE, TYPE, PRICE, WRITER_NUM) INVENTORY (BOOK_NUM, BRANCH_NUM, ON_HAND)2.3 List the number of employees for each branch in South Africa. 2.4 List the book code and title of each book of type “Romance”. 2.5 For each type of book list the type and the average price. 2.6 Find the title for each book written by “Bob Builder”. 2.7 List the name of all books in South Africa written by “Hans Anderson“ 2.8 Count the number of books (AS NumOfBooks) written by each author
Damon Davis was creating the Drano Plumbing Company's spreadsheet. He determined that the net income would be $50,000. When he tallied the columns on the Balance Sheet, the totals were as follows: debit, $400,000; and credit, $300,000. What was the most likely reason for this discrepancy? If this was not the case, how should he proceed to determine the source of the error?
12. In a book store, a customer who wants to buy a book asks the assistant if a copy of the book is available. The assistant then checks if the book is available by searching for the book title in the store’s book catalogue. In that scenario, with the help of DFD symbols, what can the ‘book catalogue’ be categorized as?A. External entityB. Data storeC. Data flowD. Process
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) ________________________________________________________________Laboratory Work No. 3 Querying – I Using the relational database given in the previous lab work, write the following queries in SQL: 1) List all departments in the CL building. 2) Find the course title of COMP124. 3) Find the prerequisite code(s), if there exists, of COMP217. 4) Which course titles offered in the Fall 2020. 5) List all students (id and names) whose advisor is Dr Cem…
(check all that apply) The ER model for a small bank system has Customer, Account, CheckingAccount, Employee, Check, Transactions, etc. as entities. Which of the following is correct use of weakentities?A) Check is a week entity of Checking AccountB) Checking Account is a weak entity of AccountC) Transaction is a weak entity of AccountD) Accout is a weak entity of Customer
Schema Suppliers (sID, sName, address) Parts (pID, pName, colour) Catalog (sID, pID, price) Solve all queries using Relational Algebra: 1. Find the names of all red parts. 2. Find all prices for parts that are red or green. (A part may have different prices from different manufacturers. 3. Find the sIDs of all suppliers who supply a part that is red or green. 4. Find the names of all suppliers who supply a part that is red or green.
2. Given the grocery store transactions example with minimum support = 33.34% and minimum confidence = 60%, Trace the results (show results for each database scan) and exact the rules using Apriori Algorithm. Transaction ID Items Bought 001 Hotdog, Bun, Ketchup 002 Hotdog, Bun 003 Hotdog, Coke, Chips 004 Coke, Chips 005 Chips, Ketchup 006 Hotdog, Coke, Chips
Consider the relational database below, where the primary keys are underlined.employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name)Give a query for each of the following:a Find the company that has the smallest payroll.b Modify the database so that Jones now lives in Newtown.c Give all employees of the First Bank Corporation a 10 percent raise.d Give all managers in database a 10 percent raise.e Give managers in the database a 10 percent raise, unless the salary would be greaterthan $100,000. In such cases, give only 3 percent raise.f Delete all tuples in the works relation for employees of Small Bank Corporation.