Part 2: Applied Modeling from Idea to Deployment

This part focuses on the practical application of data modeling techniques across different stages of the database design process. You will learn how to put conceptual modeling into practice by gaining a solid understanding of the data entities, relationships, and business rules that define the underlying data structure. You will also learn how to enrich these details and add nuance using a logical model that cannot be captured in a physical database. This part also delves into the critical concept of database normalization, essential for minimizing data redundancy and ensuring accurate and consistent data storage. After covering database naming and structure and exploring the best practices for creating intuitive, meaningful, and scalable database schemas, you will learn how to put physical modeling into practice while optimizing database performance.

This part has the following chapters:

• Chapter 7, Putting Conceptual...