Instructor Profile:
Dr. Rais Abdul Hamid Khan
Professor & Academic Dean, School of Computer Science and Engineering (CSE), Sandip University, Nashik, Maharashtra, India
Dr. Rais Abdul Hamid Khan is an accomplished academician and researcher, currently serving as a Professor and Academic Dean at the School of Computer Science and Engineering (CSE), Sandip University, Nashik, Maharashtra, India. With a robust educational background and over 23 years of teaching and research experience at various reputed universities in India, Dr. Khan has made significant contributions to the field of Computer Science.
Dr. Khan completed his Ph.D. in Computer Science and Engineering (CSE) in 2018 from NIMS University, Jaipur, Rajasthan. Prior to this, he obtained his M.Tech. in CSE from RGTU, Bhopal, in 2009, and his B.E. in CSE from NMU, Jalgaon, in 2002.
His research interests span a wide range of topics in Computer Networks, Operating Systems, Artificial Intelligence, and Machine Learning. Dr. Khan’s dedication to these fields is evident through his extensive body of work, which includes over 11 Indian patents and 48 research publications in reputed Scopus-indexed journals, international conferences, and book chapters. One of his noteworthy papers, titled “Denauley Triangulation Algorithm,” was referenced by NASA, USA, further highlighting the global impact of his work. His research contributions have garnered over 2,078 citations, underscoring his influence in the academic community.
In addition to his academic and research pursuits, Dr. Khan is a passionate educator, keen on disseminating knowledge through various platforms, including Massive Open Online Courses (MOOCs). His deep expertise in Artificial Intelligence, Machine Learning, and Computer Networks continues to inspire and shape the next generation of engineers and researchers.
Key Research Areas:
- Computer Networks
- Operating Systems
- Artificial Intelligence (AI)
- Machine Learning (ML)
Achievements:
- 11 Indian patents
- 48 research publications in Scopus-indexed journals, international conferences, and book chapters
- Over 2,078 research citations
- “Denauley Triangulation Algorithm” paper referred by NASA, USA
Dr. Rais Abdul Hamid Khan is committed to advancing the frontiers of Computer Science through innovative research, teaching excellence, and impactful academic leadership.
Course Outline: DBMS – 3NF & BCNF
Module 1: Introduction to Database Management Systems (DBMS)
- Overview of DBMS: Definition and importance of DBMS, Types of DBMS: Hierarchical, Network, Relational, and Object-oriented, Key components of a DBMS
- Relational Database Model: Introduction to relational databases, Tables, attributes, and relationships, Primary keys, foreign keys, and integrity constraints
- Database Normalization: Definition and objectives of normalization, Benefits of normalization in database design, Introduction to functional dependencies
Module 2: First, Second, and Third Normal Forms (1NF, 2NF, 3NF)
- First Normal Form (1NF): Definition and requirements for 1NF, Identifying and converting unnormalized relations to 1NF
- Second Normal Form (2NF): Definition and requirements for 2NF, Understanding partial dependency, Converting 1NF relations to 2NF
- Third Normal Form (3NF): Definition and requirements for 3NF, Understanding transitive dependency, Converting 2NF relations to 3NF
Module 3: Boyce-Codd Normal Form (BCNF)
- Understanding BCNF: Definition and significance of BCNF, Differences between 3NF and BCNF, Conditions for a relation to be in BCNF
- Normalizing to BCNF: Steps to convert a relation from 3NF to BCNF, Handling anomalies and redundancy in BCNF
- Practical Applications of BCNF: Real-world scenarios where BCNF is essential, Analyzing database design problems and solutions, Tools and techniques for normalization
Module 4: Advanced Normalization Techniques and Case Studies
- Higher Normal Forms: Introduction to Fourth Normal Form (4NF) and Fifth Normal Form (5NF), Understanding multivalued and join dependencies, Comparison of 3NF, BCNF, 4NF, and 5NF
- Case Studies in Normalization: In-depth analysis of database normalization in real-world applications, Group projects on normalizing sample databases, Presentations on normalization challenges and solutions
- Tools for Database Design and Normalization: Overview of tools and software for database design, Hands-on training on popular DBMS tools (e.g., MySQL, PostgreSQL), Best practices for maintaining normalized databases
This course outline aims to provide students with a comprehensive understanding of database normalization concepts, focusing on 3NF and BCNF, along with practical skills to apply these principles in real-world database design scenarios.
