Scribd
Upload
5 views1 page

Library Management System & Database Concepts

Uploaded by

patel7874raj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views1 page

Library Management System & Database Concepts

Uploaded by

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

1 Draw ER diagram for Library Management System

2 What is normalization? Explain 1NF, 2NF, 3NF, 4NF, 5NF and BCNF
3 Explain method of query optimization and steps of query evaluation
4 Discuss various steps of query processing with proper diagram
5 Define Transaction. Explain the transaction properties and transaction states
6 Explain Indices, B-trees, hashing
7 What is a transaction? Explain ACID properties of Transaction with suitable example
8 What is deadlock? Explain deadlock detection and prevention policies
9 Define PL/SQL. Write PL/SQL block to print sum of even numbers
10 What is Relational Algebra? Define Relational Algebra Operation cross product with
example

You might also like