Instructor Profile:
Dr. Monika Sharad Deshmukh
Assistant Professor, Computer Engineering, Sandip University, Nashik
Dr. Monika Sharad Deshmukh is an accomplished academician with over 11 years of experience in the field of Computer Engineering. She obtained her Bachelor of Engineering (B.E.) degree in Computer Engineering from K. K. Wagh College of Engineering, Nashik, affiliated with Savitribai Phule Pune University (SPPU). She further advanced her education by earning a Master of Engineering (M.E.) degree in Computer Engineering from Siddhant College of Engineering, Pune, also under SPPU. Dr. Deshmukh culminated her academic journey with a Ph.D. degree in Computer Engineering from Sandip University, Nashik, where she has since taken on the role of Assistant Professor.
Dr. Deshmukh has a strong commitment to research, evidenced by her prolific publication record. She has authored approximately 15 research papers in various international journals and conferences, with several of her works featured in prestigious SCI/Scopus indexed journals. Her research interests lie primarily in the domains of Machine Learning, Deep Learning, and Network Security, making significant contributions to these rapidly evolving fields.
In her role as an educator, Dr. Deshmukh is dedicated to fostering a dynamic learning environment, guiding students in their academic pursuits while inspiring them to explore the frontiers of technology. Her extensive expertise and practical insights into contemporary technological challenges equip her to deliver comprehensive and engaging courses that meet the needs of learners in the digital age.
Dr. Deshmukh’s combination of teaching experience, research acumen, and passion for the field positions her as a valuable asset to the academic community and a mentor to aspiring engineers in the realm of Computer Science.
Course Outline: DBMS – Database Anomalies & Normalization
This course provides a comprehensive understanding of database management systems (DBMS) with a specific focus on database anomalies and normalization techniques. Students will learn how to identify various anomalies in database design and apply normalization principles to optimize database structures for efficiency and integrity.
Module 1: Introduction to Database Management Systems
- Overview of DBMS: Definition and importance of DBMS, Types of DBMS: Hierarchical, Network, Relational, and Object-oriented
- Database Models: Entity-Relationship Model, Relational Model
- Introduction to Data Integrity: Importance of data integrity in databases, Constraints: Primary Key, Foreign Key, Unique, and Check Constraints
Module 2: Understanding Database Anomalies
- Types of Database Anomalies: Insertion Anomalies, Deletion Anomalies, Update Anomalies
- Examples and Case Studies: Real-world scenarios illustrating each type of anomaly, Impact of anomalies on data integrity and reliability
- Identifying Anomalies in Database Design: Techniques for detecting anomalies in existing databases, Tools and methods for analysis
Module 3: Database Normalization Techniques
- Introduction to Normalization: Definition and goals of normalization, Benefits of normalization in DBMS
- Normal Forms: First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF)
- Normalization Process: Steps to normalize a database, Techniques for transforming relations into higher normal forms
- Trade-offs in Normalization: When to normalize vs. denormalize, Balancing normalization with performance considerations
Module 4: Advanced Normalization and Practical Applications
- Higher Normal Forms: Fourth Normal Form (4NF), Fifth Normal Form (5NF), Domain-Key Normal Form (DKNF)
- Denormalization Strategies: Understanding denormalization, Scenarios where denormalization is beneficial
- Practical Applications and Case Studies: Analyzing real-world databases: Identifying anomalies and applying normalization, Hands-on exercises: Normalizing a sample database
- Conclusion and Future Trends: Emerging trends in database design and management, The role of normalization in modern database technologies
Course Objectives: By the end of this course, students will be able to:
- Understand the fundamental concepts of DBMS and its importance.
- Identify and analyze database anomalies.
- Apply normalization techniques to design efficient and reliable databases.
- Evaluate real-world database designs and suggest improvements based on normalization principles.
