Consider the following Account table and express in Relational Algebra each of the questions below:accountIDaccountTypeamountcustomerID100104103101105ас2005000SS0039002000157009655currentас201Savingac202ac203|ас 204ac205currentcurrentSavıngSaving| 106a. List the details of all the accounts of type Saving".b. Find the balance amount of the account that is owned by the customer whose id is 106.c. List the ids of customers who own an account of type "current" and its balance amounts is less than 7000 Omani rials.

a) SELECT * FROM Account WHERE accountType = 'Saving' ; b) SELECT amount FROM Account WHERE…

Consider the following Account table and express in Relational Algebra each of the questions below: accountID ac200 accountType amount customerID 5000 SS00 current 100 аc201 аc202 ас203 Saving 104 3900 current 103 2000 15700 9655 current 101 |Saving Saving аc204 105 ac205 106 a. List the details of all the accounts of type 'Saving". b. Find the balance amount of the account that is owned by the customer whose id is 106. c. List the ids of customers who own an account of type "current" and its balance amounts is less than 7000 Omani rials.

Consider the following Account table and express in Relational Algebra each of the questions below: accountID ac200 accountType amount customerID 5000 SS00 current 100 аc201 аc202 ас203 Saving 104 3900 current 103 2000 15700 9655 current 101 |Saving Saving аc204 105 ac205 106 a. List the details of all the accounts of type 'Saving". b. Find the balance amount of the account that is owned by the customer whose id is 106. c. List the ids of customers who own an account of type "current" and its balance amounts is less than 7000 Omani rials.

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

QUESTION 9 Consider the following Grades table and express in Relational Algebra each of the questions below: Grades StudentId CourseCode Semester Grade 1001 ITDR3101 FL20 B 1002 ITSW3104 FL20 A 1003 ITGP4101 SP20 A 1001 ITDR2106 SP21 C List the grades of students who studied the course having the code “ITDR2106” in the semester “FL20”. List the details of students who didn't get the grade ‘A’ in any course. List the ids students who got the grade ‘B’ in ‘SP20’ semester.
QUESTION 9 Consider the following Grades table and express in Relational Algebra each of the questions below: Grades StudentId CourseCode Semester Grade 1001 ITDR3101 FL20 B 1002 ITSW3104 FL20 A 1003 ITGP4101 SP20 A 1001 ITDR2106 SP21 C List the grades of students who studied the course having the code “ITDR2106” in the semester “FL20”. List the details of students who didn't get the grade ‘A’ in any course. List the ids students who got the grade ‘B’ in ‘SP20’ semester.
QUESTION 16 Consider the following Grades table and express in Relational Algebra each of the questions below: Grades StudentId CourseCode Semester Grade 1001 ITDR3101 FL20 B 1002 ITSW3104 FL20 A 1003 ITGP4101 SP20 A 1001 ITDR2106 SP21 C a. List the grades of students who studied the course having the code "ITDR2106* in the semester "FL20".] b. List the details of students who didn't get the grade 'A'’ in any course. c. List the ids students who got the grade B' in SP20° semester. С.
Please Write the following queries in relational algebra, using the university schema.a. Find the ID and name of each instructor in the Physics department.b. Find the ID and name of each instructor in a department located in thebuilding “Watson”.c. Find the ID and name of each student who has taken at least one coursein the “Comp. Sci.” department.d. Find the ID and name of each student who has taken at least one coursesection in the year 2018.e. Find the ID and name of each student who has not taken any coursesection in the year 2018.
Provide all the SQL statements that are required for the following transactions to be executed. Transaction 01: A residential customer (Bob Builder) of 53 Drip Drive, Dripwater (post code: 1267) has an account with the water company at the same address. The meter was installed on 30th October 2019 and has the serial number DDWC4763. This customer does not have any outstanding balance for the service at this address. Transaction 02: On 23rd July, 2020, the meter at 53 Drip Drive, Dripwater was read by Karen Karpenter (a meter reader). The reading the last time this meter was read was 123580 kL, at this reading it was 123683 kL. The bill was created and sent on the same day. Transaction 03: On 2nd August 2020, Bob Builder settled the account in full for consumption at 53 Drip Drive, Dripwater using PayPal.
From the Salesm an and Customer tables below, write SQL statements to do the following: a) List the sales man id, rating and names of those sales men who getrating from 3 to 5, sorted DESCENDING by rating. b) List all the customers' informat ion whose name starts with 'F' and the fourth character is T, rests may be any charac ter. c) List the name andcountry of those customers and sales men who belongs to the same country. Salesman table: Salesman Salesman_ rating _id country name 2001 Mc Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam grade country Salesman e _id 1 Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 UK Jozy Altidor 100 2010 5 Brad Guzan 500 Canada 2005
Q3/ Write queries in relational algebra 1- Select all employees who either work in department 6 and make over 25,000 per year, or work in department 4 and make over 30,000 2- Find the Fname, Lname, and address of the employees in Dno=8
Consider the library database of Figure 3.20.Write the following queries in SQL.a. Find the member number and name of each member who has borrowedat least one book published by “McGraw-Hill”.b. Find the member number and name of each member who has borrowedevery book published by “McGraw-Hill”.c. For each publisher, find the member number and name of each memberwho has borrowed more than five books of that publisher.d. Find the average number of books borrowed per member. Take into accountthat if a member does not borrow any books, then that member doesnot appear in the borrowed relation at all, but that member still counts inthe average.
consider the following schema and answer the following questions: Write the following queries in relational algebra. Find the names of vendors who are from ‘Suhar’. Find the IDs of products which are supplied at cost greater than 1000. Find IDs of vendors who supplies products with blue color. b. Write SQL queries for the following statements. Display all the product’s details in the decreasing order of their cost. Count and display the number of products supplied by each vendor. Add the given new Product’s data into the Product table. P_ID P_Nam P_color 2546 Picnic bag Brown
onsider the following schema: Product(pid, name, type, manufacturer, price), Buys(cid, pid), Customer(cid, cname, age, gender) Write the following query in relational algebra and SQL a) Find the names of all customers who have purchased all products manufactured by Sears. b) Find the names of all customers who have not purchased the most expensive product c) Find the names and cids of all customers who have purchased the second most expensive product. You can assume that no two products have the same prices.
All parts of this question use the following database schema: Flights(flno, from, to, distance) Aircraft(aid, aname, cruisingrange) Certified(eid, aid) Employees(eid, ename, salary) c) For each cruisingrange held by at least 3 aircraft, give the lowest salary of employees certified to fly one of those aircraft. Express in SQL only:
. Assume the Relations given below.Student( Enrno, name, courseId, emailId, cellno) Course(courseId, course_nm, duration)Write SQL statements for following: a. Find out list of students who have enrolled in “computer” course. b. List name of all courses with their duration.c. List name of all students start with “a”.d. List email Id and cell no of all mechanical engineering students.