Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1of 1
Part A
1. Differentiate between stored and derived attributes.
2. Describe the entity-relationship model and its components. 3. Identify the main properties of transactions in databases. 4. Explain the concept of atomicity with examples. 5. Illustrate the various transaction states 6. Define and examine the concept of serializability in transactions 7. Compare SQL and NoSQL databases 8. Summarize the CAP theorem principles 9. Distinguish between different MongoDB CRUD operations. 10. Outline the functions of CRUD operations.
Part B
1. Explain the concept of functional dependencies in a database schema and
discuss their significance. 2. Describe the process of normalization and outline the steps for 1NF, 2NF, 3NF, and BCNF. 3. Summarize the key concepts and states in transaction management within databases. 4. Explain why recovery mechanisms are essential in databases, and discuss two common recovery techniques. 5. Apply the concept of serializability in databases and explain its types with examples. 6. i) Apply concurrency control mechanisms in database operations. ii) Discuss the two-phase locking protocol and discuss its advantages. 7. Apply the principles of CAP theorem to explain its components and their impact on distributed databases. 8. Demonstrate how HBase is used in database management by describing its basic concepts, purpose, and practical use cases 9. Explain the CRUD operations in HBase and their significance in database management. 10. Summarize the CRUD operations in MongoDB, focusing on their use and importance Part C 1. Construct RAID systems and Explain how the improve performance and reliability 2. Illustrate the use of NoSQL databases by explaining their core concepts and discussing examples of their applications in real-world scenarios 3. Identify the SQL Injection Methods with an example.