A relational database has the following schema:Customer (Cno, name, address, age, loan_type, loan_amount, year)Solve following queries in relational algebra:Select the records where loan_type is 'Personal'.Select the records where age is geater than 30 and loan_type is ‘soft’.Select records from Customer table where loan_type is ‘Personal' and loan_amount is Rs200000 or those customers who opened an account after 2017.Project the columns name and address from the Customer table.

Sigma operator is used for selecting record. Project operator

Answered: A relational database has the following…

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

Related questions

Question

A relational database has the following schema:

Customer (Cno, name, address, age, loan_type, loan_amount, year)

Solve following queries in relational algebra:

Select the records where loan_type is 'Personal'.
Select the records where age is geater than 30 and loan_type is ‘soft’.
Select records from Customer table where loan_type is ‘Personal' and loan_amount is Rs200000 or those customers who opened an account after 2017.
Project the columns name and address from the Customer table.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions