SET-1

I.A. 1) Distinguish between database systems and file systems

2) What is data independence and how does a DBMS support it? Explain

I.B. 1) Describe the client server architecture for the database with necessary diagram.
2) Discuss about database users and explain the role of database administrator.

II.A. 1) Explain in detail about various key constraints used in database system.
2) Describe the concept of Integrity CONSTRAINTS.

II.B. 1) List and explain the common data types available in SQL.
2) Write a short notes on i) Foreign Key ii) Primary key iii) SQL schema.

III.A. 1) Write and explain the structure of SQL SELECT statement with suitable example
2) Write short notes on i) DDL ii) DML iii) DCL

III.B. 1) Explain about Conceptual Database Design With The ER Model (ER Design Issues)
2) What is Entity set? Explain in detail

IV.A. 1) Explain insertion, deletion and modification anomalies with suitable examples.
2) State BCNF. How does it differ from 3NF?

IV.B. 1) Why normalization is needed? Explain the process of normalization.

2) Explain insertion, deletion, and modification anomalies.

V.A. 1) Discuss the different types of ACID properties and its implementation.
2) Write short notes on: i) Primary index ii) Clustered index iii) Secondary index

V.B. 1) Define dynamic multilevel indexing how to implement it with the help of B+ trees? Explain.
2) Construct a B+ tree of order 4(m) with Max keys=3 (m-1)per node with the following data
1,4,6,12,19,21,31.
 SET-2
I.A. 1) What is a Database model? List out various database models and explain any two of
them
2) Who are the different database users? Explain their interfaces to database
management system.

I.B. 1) Briefly explain about functions and applications of DBMS.

2) Define Schema. Explain three level architecture in DBMS.

II.A. 1) Describe all operators of relational algebra.

2) Discuss the importance of entity integrity and referential integrity constraints.

II.B. 1) What is a relation? Describe the characteristics of a relation.

2) Discuss GROUPBY and HAVING clauses with an example. And also give the
constraints related to their usage.

III.A. 1) By considering an example describe various data update operations in SQL.

2) Differentiate between independent and correlated nested queries.

III.B. 1) Describe ER-Model concepts.

2) Draw an ER diagram for library management system.

IV.A. 1) What is meant by the closure of functional dependencies? Illustrate with an example.
2) State 1NF and 2NF explain with examples.

IV.B. 1) List and explain the inference rules of functional dependencies.

2) What is dependency preservation property for decomposition? Explain why it is
important.
V.A. 1) When does a collision occur in hashing?
2) Discuss about sparse index and dense index.

V.B. 1) What is a transaction? Explain the Implementation of atomicity property of a

transaction.
2) Explain insertion and deletion operations on a B+tree, By considering relevant example.
 SET-3

I.A. 1) Define DBMS. Explain database users in detail.

2) Draw and explain the detailed system architecture of DBMS.

I.B. 1) Discuss the main characteristics of the database approach and specify how it differs from
traditional file system.
2) Compare and contrast various Data Models.

II.A. 1) Explain about the following clauses with example queries. (i)Group by (ii) Order by
(iii) Aggregation functions iv) where.
2) List the SQL functions for string conversions

II.B. 1) write and explain the structure of sql DML statements with examples
2) Explain relational algebra and relational calculus.

III.A. 1) Differentiate specialization and generalization

2) Write short notes on nested queries.

III.B. 1) Discuss in detail about the concepts of E-R model.

2) D Define Relationship set. List and explain the symbols used to draw ER Diagram.

IV.A. 1) State the functional dependency. Explain types of functional dependencies.

2) How to compute closure of set of functional dependency?

IV.B. 1) What is multi valued dependency? State and explain fourth normal form based on this
concept.
2) Explain normal forms with examples.

V.A. 1) What is serializability? Explain conflict serializability with the help of example?.
2) Explain view serializability with the help of example.

V.B. 1) Explain the differences between static hashing and dynamic hashing.
2) What is static hashing? What rules are followed for index selection?
 SET-4
I.A. 1) Describe the concept of client/server model.
2) Define the following terms i). Schema ii). Instance iii). Database
iv).DBMS v). Information.

I.B. 1) it differs from traditional file system.

2) Discuss the activities of different database users.

II.A. 1) Discuss the main characteristics of the database approach and specify how
it differs from traditional file system.
2) Discuss the activities of different database users.

II.B. 1) C Consider the following schema: Suppliers (sid, sname, address) ,Parts (pid, pname,
color),Catalog (sid, pid, cost)
Write the relational algebraic queries for the following:
i)Find the sids of suppliers who supply some red or green part
ii) Find the sids of suppliers who supply every red or green part
iii) Find the pids of parts supplied by at least two different suppliers.
2) Explain about the integrity constraints in SQL.

III.A. 1) Explain about degree and cardinality in ER-model.

2) Define the following terms with an examples
i). Entities ii). Attributes iii).Relationships

III.B. 1) What is SQL single row function? By means of suitable examples illustrate the
usage of SQL date, character and number functions.
2) Distinguish between independent and correlated nested queries. Provide
appropriate e examples to support your explanation.

IV.A. 1) Discuss the problems caused by redundancy and the purpose of normalization.
2) What is a surrogate key? How can it be used for schema refinement?

IV.B. 1) Explain about Boyce Codd normal form with an example.

2) Differentiate between first normal form and second normal form.
 V.A. 1) Define transaction and explain desirable properties of transactions.
2) Explain about testing serializability with suitable example.

V.B. 1) Write about the transaction management with SQL using commit, rollback, and save
point.
2) Justify B+ tree as a multi-level indexing? How does it differ from B-tree?

SET-5
I.A. 1) List and explain various data models used for database design.
2) Describe in detail about one-tier, two-tier and three-tier client-server architectures

I.B. 1) Demonstrate data abstraction implementation in DBMS

2) Describe schema instance and data independence.

II.A. 1) Explain relational algebra with example

2) Write a schema to Implement relational set operations using sql.

II.B. 1) How would you use the operators IN, EXISTS, UNIQUE, ANY and ALL in writing nested
Queries? Why are they useful? Explain with an example
2) Explain the following:
i) Key constraints ii) Integrity constraints iii) relation

III.A. 1) Explain about SQL joins in brief

2) Distinguish between union and joins in SQL.

III.B. 1) Discuss database design overview in detail

2) Discuss about types of relationships

IV.A. 1) What is Functional Dependency? Explain types and properties of FD’s.

2) What are the problems caused by redundantly storing information? Explain

IV.B. 1) List and explain the inference rules of functional dependencies

 2) State and explain Fourth normal form.

V.A. 1) Discuss about Concurrent Execution and Schedules with example.

2) List and explain various issues while transactions are running concurrently in DBMS.

V.B. 1) Discuss about transaction states with diagram

2) What are the benefits of using dynamic indexing? Explain in detail B+ tree file organization.