Scribd
Upload
3 views1 page

Assignment

The document outlines a comprehensive assignment covering various aspects of Database Management Systems (DBMS). Key topics include data abstraction levels, DBMS architecture, data manipulation languages, keys, data models, integrity constraints, normalization, query processing, concurrency control, security measures, and database types. Each section requires detailed explanations, examples, and comparisons to demonstrate understanding of DBMS concepts.

Uploaded by

seeke49
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
3 views1 page

Assignment

The document outlines a comprehensive assignment covering various aspects of Database Management Systems (DBMS). Key topics include data abstraction levels, DBMS architecture, data manipulation languages, keys, data models, integrity constraints, normalization, query processing, concurrency control, security measures, and database types. Each section requires detailed explanations, examples, and comparisons to demonstrate understanding of DBMS concepts.

Uploaded by

seeke49
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

Assignment

1. Explain the three levels of data abstraction in DBMS with a neat diagram. What is data
independence? Differentiate between logical and physical data independence.
2. Describe the architecture of a DBMS and its components.
3. Explain DDL, DML, DCL and TCL with suitable examples.
4. What is key in Dbms? Explain Primary key, Candidate key, Alternative key, Foreign key and
Super key with proper example.
5. Compare different data models: ER, network, relational, and object-oriented.
6. Describe the concept of integrity constraints in Relational database. Explain different types of
integrity constraints with the help of example.
7. Explain relational algebra operations with examples. Describe tuple relational calculus and
domain relational calculus.
8. Explain various types of joins in SQL with examples. Discuss aggregate functions and
GROUP BY clause in SQL.
9. Explain functional dependency and its types with examples.
10. Describe Armstrong’s axioms and their significance.
11. Explain normalization and its importance in database design. Differentiate between 1NF,
2NF, 3NF, BCNF, 4NF and 5NF with examples.
12. Explain lossless join and dependency preservation with examples.
13. Explain query processing steps in DBMS. What is query optimization? Discuss different
optimization techniques.
14. Explain equivalence rules in relational algebra. Describe different join strategies used in
query processing. Discuss cost estimation in query optimization.
15. Explain indexing and its types in DBMS. Describe B-Tree and B+ Tree indexing with
diagrams.
16. Compare hashing and indexing techniques. Explain static and dynamic hashing methods.
17. What is concurrency control? Explain ACID properties with real-life examples.
18. Discuss locking protocols. Explain serializability and its types. Describe timestamp-based
concurrency control methods.
19. Explain database recovery techniques. Define authentication and authorization. How do they
differ in the context of system security?
20. What is access control? Explain DAC, MAC and RBAC models.
21. Discuss 2 phase commit(2PC) protocol and time stamp-based protocol with suitable example.
How the validation-based protocol differs from 2PC?
22. What are the components of an intrusion detection system (IDS)? Briefly describe each.
23. Explain how SQL injection attacks work? Provide a simple example.
24. Differentiate between Data Warehousing and Data Mining with appropriate examples.
25. Define Object oriented databases, Object relational databases, Logical databases, Web
databases and Distributed databases.

You might also like