DBMS 16 marks

1. Explain the architecture of DBMS with a neat block diagram 
•  Storage manager
• Query processor
• Block diagram

2. Explain ER model in detail 
• Attribute set
• Entity set
• Mapping cardinalities
• Relationship sets
• Keys

3. Explain the design issues of ER-model 
• Use of entity sets Vs Attribute sets
• Use of Entity sets Vs Relationship sets
• Binary Vs Nary relationship sets
• Placement of relationship sets

4. Explain the various relational algebra operations 
• Select operations
• Project operations
• Union operation
• Set difference operations
• Cartesian product operations
• Rename operations

5. Draw an ER diagram for a banking enterprise 
• Data requirements
• Entity sets
• Relationship sets
• ER diagram


Unit II
1. Explain nested Queries with examples
•Set membership
•Set comparison
•Test for empty relations

2. Explain embedded SQL and dynamic SQL in detail
•Explanation

3. Explain the integrity constraints supported by SQL
•Domain constraints
•Referential integrity

4. Explain triggers with example.
•Need for triggers
•Explanations
•When not to use triggers

5. Explain security and authorization and Security in SQL
•Security violations
•Authorization
•Privileges
•Roles

6. Explain the different normal forms in detail
•1 normal form
•2 nd normal form
•3 rd normal form
•4 th normal form
•BCNF


UNIT III

1. Explain RAID levels in detail
•RAID LEVEL0
•RAID LEVEL1
•RAID LEVEL2
•RAID LEVEL3
•RAID LEVEL4
•RAID LEVEL5
•RAID LEVEL6

2. Explain file organization in details.
•Sequential file organization
•Clustering file organization
•Heap file organization
•Hash file organization

3. Explain indexing and hashing
•Primary index
•Multilevel index
•Secondary index
•Hash functions
•Dynamic hashing

4. Explain B+ tree index in detail
•Structure
•Queries
•Updates

5. Explain Query processing in detail.
•Parsing and translation
•Optimization
•Evaluation




Unit IV
1. Explain ACID in detail.
•Atomicity
•Consistency
•Isolation
•Durability

2. Explain serializability
•Conflict serializability
•View serializability

3. Explain lock based protocols
•Shared
•Exclusive

4. Explain two phase locking in detail.
•Strict two phase locking
•Rigorous two phase locking

5. Explain log based recovery in detail.
•Immediate database modifications
•Deferred modification


UNIT V
1. Explain XML in detail
•Structure
•Document schema
•Xml schema

2. Explain distributed Database in detail
•Data replication
•Fragmentation
•Transparency

3. Explain Data mining in detail
•Classification
•Decision tree classifiers
•Regression
•Association

4. Explain Data warehousing in detail
•Components
•Schema

5. Explain OODM in detail
•Object structure
•Object classes
•Inheritance
•Multiple inheritence identity