Download PTU B.Tech 2020 March ECE 6th Sem BTEC 901 Relational Data Base Management System Question Paper

FirstRanker.com

Roll No. Total No. of Pages : 02
Total No. of Questions : 09

--- Content provided by FirstRanker.com ---

--- Content provided by‍ FirstRanker.com ---

INSTRUCTION TO CANDIDATES :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.
2. SECTION-B contains FIVE questions carrying FIVE marks each and students have to attempt any FOUR questions.
3. SECTION-C contains THREE questions carrying TEN marks each and students have to attempt any TWO questions.

SECTION-A

--- Content provided by‍ FirstRanker.com ---

1) Answer briefly :

1. What do you understand by Entity and Entity set? Explain.
2. What are the structure of projection? Explain.
3. Explain the find statement.
4. Give example using SQL for the retrieval using exist.

--- Content provided by‌ FirstRanker.com ---

5. What is second normal form?
6. What is a query language?
7. What do you understand by get? Explain
8. Give example using SQL for the retrieval using union
9. Give example using SQL for the retrieval using where clause

--- Content provided by‌ FirstRanker.com ---

10. What are the log files?

SECTION-B

2) What are the various objective of a data base system? Explain the architecture for a relational data Model.

3) What are the various components of DBMS? Explain the role of DBA in a data base environment.

4) Write short notes on the following :

--- Content provided by⁠ FirstRanker.com ---

• Conceptual Schema.
• Entity integrity
• Functional dependency

5) What are the construct used in the relational calculus? Explain each of them with example.

6) What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?

--- Content provided by‌ FirstRanker.com ---

SECTION-C

Consider the following relational database :

EMPLOYEE (emp name, street, city)
WORKS (emp-name, comp-name, salary)
COMPANY (comp name, city)

--- Content provided by​ FirstRanker.com ---

For each of the following queries, give the relational algebraic expression and relational calculus expression :

1. Find the names of all the employees who work for XYZ Bank Corporation.
2. Find the names of those employees who earn more than every employee of the XYZ Bank Corporation.
3. Find the names of managers who work in a bank located in Delhi.

--- Content provided by FirstRanker.com ---

7) Compare and contrast the features of simple locking, intention mode locking and time stamping mechanism from the viewpoint of transaction control under concurrent transitions.

8) What is the purpose of Audit Trails? How can they be used in a Banking Database System? Describe in the context of Banking System of India.

NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any page of Answer Sheet will lead to UMC against the Student.

FirstRanker.com

--- Content provided by‍ FirstRanker.com ---