Database Management SystemPU Spring 2023
a) Suppose we have the following relation. [<3 imployee(person name, street, city) iti diced Bo! tr Works (person name, company name, salary) Company (company name, city) Write relational algebraic…
8- a) Suppose we have the following relation. [<3 | imployee(person_name, street, city) iti diced Bo! tr Works (person_name, company_name, salary) Company (company_name, city) Write relational algebraic expressions for the following queries:
- i) List the name and city of employee who work in “pokhara” and have salary greater than Rs. 50,000.
- ii) Find the names of all employees who work for “ABC bank”.
- iii) Delete all employee who come from “Chitwan”.
- iv) Increase salary of all employee by 15%.
- b) What are different kinds of joins? Explain in brief. i
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
a) Differentiate between database schema and instances. Briefly describe DDL, DML and DCL. b) Define relational data model. Draw an E R diagram for a Library…PU Spring 202315a) Write SQL statements for the following queries using the given Employees relation: 1 i) Create a database named Company and Employees relation. ii) Create…PU Spring 202315a) What is database normalization? Explain in detail about INF, 2NF, 3NF with suitable examples. b) What are authorization and authentication? Why are they…PU Spring 202315a) What are the steps in query processing? Make an operator tree for the following SQL expression: Select customer name FROM branch, account, depositor WHERE…PU Spring 20237a) Explain Log based recovery system with an appropriate log record example. b) Why should the transactions’ schedule be serialized? Explain conflict and view…PU Spring 20237Write short notes on: (Any two) 2x5 a) Data Dictionary kM eroEn otes b) Stored procedure ———— c) Object oriented Database 2PU Spring 2023