[go: up one dir, main page]
Scribd
Upload
91 views2 pages

Dbms Model Question Set-2

Uploaded by

sindhusrrcetsoftware
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
91 views2 pages

Dbms Model Question Set-2

Uploaded by

sindhusrrcetsoftware
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

SRI RAAJA RAAJAN COLLEGE OF ENGINEERING AND TECHNOLOGY

AMARAVATHIPUTHUR, KARAIKUDI
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
MODEL EXAM
SET-2

Reg. Date:
Year/Dept: II/CSE
No: Time:

CS8492 DATABASE MANAGEMENT SYSTEMS 100 Marks

Answer ALL Questions


PART A – 20 Marks
1. What is a data model? List the types of data model used.
2. Define the terms i) Entity set ii) Relationship set.
3. Define the terms i) DDL ii) DML
4. What is embedded SQL? What are its advantages?
5. What are two pitfalls (problem) of lock-based protocols?
2
6. What are the time stamps associated with each data item?
7. What are the advantages and disadvantages of indexed sequential file?
8. What is database tuning?
9. Define average latency time.
10. What is meant by Spatial database?
PART B –(5*13=65 Marks)
11.a.i) Explain about various data models.
ii) Explain about the Purpose of Database system. 13
(OR)
b. i) Consider the universal relation R={ A,B,C,D,E,F,G,H,I} and the set of functional
dependencies F={(A,B)->{C],{A}>{D,E},{B}->{F},{F}->{G,H},{D}->[I,J}.what is the
key for Decompose R into 2NF,the 3NF relations.
ii) What is normalization? Explain all Normal forms.
12.a. i)Explain Embedded and Dynamic SQL.
ii) Explain briefly about the steps required in query processing. 13
(OR)
b. i) Write down in detail about Deadlock.
ii) Write down in detail about serializability.
13.a.i) Explain in detail about Lock based protocols and Timestamp based protocols.
13
ii) Explain Two phase locking protocol in detail.
(OR)
b.How concurrency is performed? Explain the protocol that is used to maintain the concurrency
concept.
14.a. How the records are represented and organized in files . Explain with suitable example.
13
(OR)
b. Write about the various levels of RAID with neat diagrams.

15.a. Explain in detail about mobile databases with example.


Explain in detail about web databases with example. 13
(OR)
b.Explain the terms i) Information retrieval and crawling and indexing the web
ii) Association rule and clustering.

PART C – (1*15=15 Marks)

16.a)i) Draw an E – R Diagram for Library Management system.


ii)Consider the following ta-
bles: Employee (Emp_no,
Name, Emp_city)
Company (Emp_no, Company_name, Salary)
i. Write a SQL query to display Employee name and company name.

ii. Write a SQL query to display employee name, employee city ,company name and salary
of all the employees whose salary >10000

iii) Write a query to display all the employees working in “XYZ company

(OR)
16.b)i) Draw an E – R Diagram for Hospital Management S. (15
)
ii) Consider the following relational schema
Employee (empno,name,office,age)
Books(isbn,title,authors,publisher)
Loan(empno, isbn,date)

Write the following queries in relational algebra.

a. Find the names of employees who have borrowed a book Published by McGraw-Hill. (15
)
b. Find the names of employees who have borrowed all books Published by McGraw-Hill.

c. Find the names of employees who have borrowed more than five different books pub-
lished by McGraw-Hill.
d. For each publisher, find the names of employees who have borrowed more than five
books of that publisher.

******HANDLED BY M.SINDHU(AP/CSE)******
**********ALL THE BEST***********

You might also like