Database Management SystemTU Board 2080
Consider a banking database with three tables and primary keys underlined as given below: Customer(CustomerID, CustomerName, Address, Phone, Email) Owns(CustomerID, AccountNumber)…
10Consider a banking database with three tables and primary keys underlined as given below:
Customer(CustomerID, CustomerName, Address, Phone, Email)
Owns(CustomerID, AccountNumber)
Account(AccountNumber, AccountType, Balance)
Write both relational algebra and SQL queries:
a) To display name of all customers who live in "Kathmandu".
b) To count total number of customers.
c) To find name of those customers who have balance greater than or equal to 100000.
d) To find average balance of each account type.
This question was also asked in TU Board 2080 (new course). Read the worked answer →
Discussion
Loading…
More Database Management System questions
Consider an online Bookstore, from which customers can buy books. Each customer can place multiple orders. Each order has one or more books. The Bookstore…TU Board 208210Consider the following relational schema: Student( SID , SName, Dept, Year) Course( CID , CName, Credit) Enroll( SID , CID, Grade) Specify the following…TU Board 208210Define Normalization. Explain 1NF, 2NF and 3NF with a suitable example.TU Board 208210Differentiate between traditional file processing system and database approach.TU Board 20825Explain the concepts of schema, instance, and data independence.TU Board 20825Define relational constraints. Explain domain, entity integrity, and referential integrity with examples.TU Board 20825