DEPARTMENT OF ARTIFICAL INTELLIGENCE AND DATA SCIENCE
ACADEMIC YEAR 2025-2026 (ODD SEMSTER)
ASSIGNMENT II
(MODE: WRITTEN | SEMINAR)
Branch | Year | AI&DS |II|III
Semester
Course Code | AD3391|Database Design and Management
Name
Maximum Marks 20
Rubrics Content Quality 10
Presentation Skills 5
References & Timeliness 5
General Content: Cover the assigned topic thoroughly, including introduction, main
Instructions content, and conclusion. Use clear and precise language.
References: Cite at least 3 credible sources (textbooks, journals, or official
websites
S.No Seminar Title Unit
1 ER to Relational Mapping: Rules and Examples Unit III
2 EER to Relational Mapping and Its Challenges Unit III
3 Understanding and Identifying Update Anomalies Unit III
4 Functional Dependencies: Types and Use Cases Unit III
5 Inference Rules and Armstrong's Axioms Unit III
6 Deriving Minimal Covers in Functional Dependencies Unit III
7 Relational Decomposition: Lossless Join and Dependency Preservation Unit III
8 Normalization: From 1NF to 3NF with Case Study Unit III
9 Boyce-Codd Normal Form (BCNF) Unit III
10 Comparison of Normal Forms: Use and Trade-offs Unit III
11 Introduction to Transaction Concepts and ACID Properties Unit III
12 Transaction Lifecycle and State Transitions Unit III
13 Schedule Types: Serial, Non-serial, Serializable Unit III
14 Conflict and View Serializability: A Comparative Study Unit III
15 Concurrency Control Mechanisms in DBMS Unit III
16 Two-Phase Locking Protocols: Basic and Strict Unit III
17 Deadlock Detection and Prevention in Transactions Unit III
18 Timestamp-Based Concurrency Control Unit III
19 Mapping EER Models to Object-Oriented DB Schema Unit IV
20 Object Identifiers and Reference Types in ORDBMS Unit IV
21 Row Types and Their Use in Complex Structures Unit IV
22 User-Defined Types (UDTs) and Their Applications Unit IV
23 Subtypes and Supertypes in Object Relational Models Unit IV
24 Designing and Using User-Defined Routines Unit IV
25 Collection Types: VARRAY, Nested Tables, and Multisets Unit IV
26 Introduction to Object Query Language (OQL) Unit IV
27 CAP Theorem and Its Implications in NoSQL Systems Unit IV
28 MongoDB Data Model and CRUD Operations Unit IV
29 Column-Based NoSQL: HBase Data Model and Operations Unit IV
30 Practical Implementation of BCNF using Case Studies Unit IV
31 Role of Functional Dependencies in Schema Refinement Unit IV
32 Real-life Database Anomalies and Their Impact Unit IV
33 Tools for Visualizing Relational Decomposition Unit IV
34 Case Study on Decomposing Large Schemas Unit IV
35 Comparison of Dependency Preservation Techniques Unit IV
36 Best Practices for Normalization in Large Databases Unit IV
37 Impact of Serializability on Transaction Efficiency Unit V
38 Case Study on Concurrency Control in Banking Systems Unit V
39 Handling Deadlocks in Distributed Databases Unit V
40 Evaluation of Two-Phase Locking in High-Traffic Systems Unit V
41 Difference between Optimistic and Pessimistic Concurrency Control Unit V
42 Real-world Applications of Transaction Isolation Levels Unit V
43 Use of Polymorphism in Object-Relational Models Unit V
44 Indexing Strategies in MongoDB and HBase Unit V
45 Comparative Study: MongoDB vs. HBase Unit V
46 Data Modeling in NoSQL for E-commerce Platforms Unit V
47 Eventual Consistency in Distributed NoSQL Systems Unit V
48 NoSQL Databases in Real-Time Applications Unit V
49 Designing Scalable Databases with Column Stores Unit V
50 Use of Aggregation Pipelines in MongoDB Unit V
Course Instructor HoD-AD
Mrs.T.Thenmozhi Dr.R.Deepalakshmi
