Question: (b) Consider the following relations: CUSTOMER (C_id, C_name, ( C_{text {_city) }} ) ) BRANCH (Br_name, Br_city, Assets) ACCOUNT (C_id, Act_no, Br_name, Balance) Give Relational

$(b) Consider the following relations: CUSTOMER (C_id, C_name, \( C_{\text {_city)$

(b) Consider the following relations: CUSTOMER (C_id, C_name, $ C_{\text {_city) }} $ ) BRANCH (Br_name, Br_city, Assets) ACCOUNT (C_id, Act_no, Br_name, Balance) Give Relational Algebraic query for the following: (i) Customer names and addresses who have accounts in Noida. (ii) Customers who have accounts in branches with assets more than 10 Lacs. (iii) Customer not having any account in any branch (iv) Customer staying in the same city where he/she is having the account

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

b) Consider the following relations, Item Number ii. 1 iii. 2 3 Shop_ID 84620 45632 86145 Item Name Burger Pizza sandwich Shop_details Name A B C Inventory Available 10 5 6 Address Uttora Gulshan...

3. (a) Define Super Key, Candidate Key, Primary Key and Foreign Key with example data. (b) Consider the following relations: (Note: ID is the primary key of each entity. x(FK[r]) idicates x a foreign...

a. Suppose in relation schema R(acc,name.branch,sal,loc) has the following functional dependencies: [(6) {{acc,loc)-nameB loc-sal; acc--branch). Find out the candidate key(s) and super key(s) which...

1. Required information NOTE: This is a multi-part question. Once an answer is submitted, you will be unable to return to this part. Consider the following relations: R 1 = {( a , b ) R 2 a > b },...

The states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation Select one: O physical data independence NOT NULL constraint O Entity...

Microkernel operating systems aim to address perceived modularity and reliability issues in traditional "monolithic" operating systems. (i) Describe the typical architecture of a microkernel...

class Queue using no other data structures than Item, Boolean, int and Stack. The amortized running time of each Queue meth od must be constant. (Note that you may only use the Stack as a black box:...

Q (a) K5 6. How many vertices and how many edges do each of the following graphs have? (b) CA (C) WS (d) K2,5 7. Does a simple graph that has five vertices each of degree 3 exist? If so, draw such a...

Question 1 Solve the following counting problems: (a) How many license plates can be made by using 3 letters following by 4 digits? (b) How many license plates can be made by using either 3 letters...

Assume that A values his house at $90,000. B is willing to pay $110,000 for As house in order to relocate closer to work. (Forget about person C for purposes of this question). After signing a...

The determination of a DNA sequence requires that the bases are identified in a sequential technique that enables the progressive identification of each base in turn. There are three main...

You will need to fund your retirement expenses. Your retirement expenses are not meant to be covered completely by _ _ _ _ _ _ _ _ _ _ .

Derek can deposit $ 1 5 , 8 7 4 . 0 0 on each birthday beginning with his 2 8 . 0 0 th and ending with his 6 8 . 0 0 th . What will the rate on the retirement account need to be for him to have $ 3 ,...

examine a variety of flexible working arrangements and assess their usefulness and impact for employers and employees

understand the basis of the contract of employment and know what should be in a contract of employment

describe the main employment rights as stated in the law