JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD B.Tech II Year DATABASE MANAGEMENT SYSTEMS Previous Question Paper (December - 2018 - R13)
Note: This question paper contains two parts A and B. Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B consists of 5 Units. Answer any one full question from each unit. Each question carries 10 marks.
Part A
Write short notes on DDL and DML
Answer
DDL (Data Definition Language) is used to define and manage the database schema, including creating, altering, and dropping tables or indexes (e.g., CREATE, ALTER, DROP). DML (Data Manipulation Language) is used to access and manipulate data within those structures, including inserting, updating, deleting, and retrieving records (e.g., SELECT, INSERT, UPDATE, DELETE).
List various symbols used in ER diagrams.
Answer
Common symbols used in ER diagrams include:
- Rectangles: Represent entity sets.
- Ellipses: Represent attributes.
- Diamonds: Represent relationship sets.
- Lines: Link attributes to entity sets and entity sets to relationship sets.
- Double Ellipses: Represent multivalued attributes.
- Dashed Ellipses: Represent derived attributes.
“Relational algebra is procedural and tuple relational calculus is non-procedural language”. Justify.
Answer
Sign in to view the complete answer paper.
Write a note on correlated sub queries.
Answer
Sign in to view the complete answer paper.
Explain about multivalued dependency.
Answer
Sign in to view the complete answer paper.
What are the problems caused by redundancy?
Answer
Sign in to view the complete answer paper.
What do you mean by serializability of a schedule?
Answer
Sign in to view the complete answer paper.
Explain different states of transaction.
Answer
Sign in to view the complete answer paper.
What is local depth?
Answer
Sign in to view the complete answer paper.
What is primary index?
Answer
Sign in to view the complete answer paper.
Part B
With a neat diagram, explain the components of database system structure.
Answer
Sign in to view the complete answer paper.
Draw an ER diagram for hospital management database.
Answer
Sign in to view the complete answer paper.
Explain the process of translating ER diagrams to relations.
Answer
Sign in to view the complete answer paper.
Describe three level architecture of database schema.
Answer
Sign in to view the complete answer paper.
Consider the following relations. Emp(Ename, Street, City), Works(Ename, Cname, Salary), Company(Cname, City), Manages(Ename, Mname). Express the following queries in relational algebra: i) Find names of all employees who earn more than every employee of “Bank Corporation”. ii) List the city of leaving of all the managers.
Answer
Sign in to view the complete answer paper.
Define Trigger. Differentiate row level and statement triggers.
Answer
Sign in to view the complete answer paper.
Differentiate tuple and domain relational calculus.
Answer
Sign in to view the complete answer paper.
Consider the following relations: Suppier(Sid, Sname, Address), Parts(Pid, Pname, Color), Catalog(Sid, Pid, Cost). Write the following queries in SQL: i) Find the Snames of the suppliers who supply every part. ii) For each part, find the Sname of the supplier who charges the most for that part.
Answer
Sign in to view the complete answer paper.
Write the procedure to find minimal cover of functional dependency set.
Answer
Sign in to view the complete answer paper.
Define Normal form. Explain 2NF, 3NF and BCNF with examples.
Answer
Sign in to view the complete answer paper.
What are the properties of decomposition? Explain in detail.
Answer
Sign in to view the complete answer paper.
Explain the following terms: i) Functional dependency. ii) Partial Functional Dependency iii) Transitive Dependency.
Answer
Sign in to view the complete answer paper.
Explain the need for locking and discuss two phase locking protocol in detail.
Answer
Sign in to view the complete answer paper.
What is shadow paging? Explain.
Answer
Sign in to view the complete answer paper.
Explain about multiple granularity.
Answer
Sign in to view the complete answer paper.
Discuss about recoverable schedules and cascadeless schedules.
Answer
Sign in to view the complete answer paper.
Explain the process of inserting a record in to a B+ tree.
Answer
Sign in to view the complete answer paper.
Explain about linear hashing.
Answer
Sign in to view the complete answer paper.
What is the role of global depth in extendible hashing?
Answer
Sign in to view the complete answer paper.
Differentiate clustered and un-clustered index.
Answer
Sign in to view the complete answer paper.