Consider the following Account table and express in Relational Algebra each of the questions below: accountID amount accountType customer ID ac200 5000 current 100 ac201 8800 Saving 104 ac202 3900...


Consider the followingAccount table and express in Relational Algebra each of the questions below:

















































accountID




amount




accountType




customer
ID



ac200



5000



current



100



ac201



8800



Saving



104



ac202



3900



current



103



ac203



2000



current



101



ac204



15700



Saving



105



ac205



9655



Saving



106





  1. List the details of all the accounts of type ‘Saving’.

  2. Find the balance amount of the account that is owned by the customer whose id is 106.

  3.  List the ids of customers who own an account of type “current” and its balance amounts is less than 7000 Omani rials.



Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here