Database Management Essentials

Module 7 builds on your knowledge of database development using basic ERD symbols and relationship variations. You will be practicing precise usage of ERD notation and basic problem solving skills. You will learn about diagram rules and work problems to help you gain confidence using and creating ERDs. The concept quiz provides an assessment of your understanding of the video lessons and associated notes. You should complete the concept quiz before starting practice problems and the graded assignment to ensure your conceptual understanding of the material.

Now that you have practiced data modeling techniques, you’ll get to wrestle with narrative problem analyses and transformations for generating alternative database designs in Module 9. At the end of this module, you’ll learn guidelines for documentation and detection of design errors that will serve you well as you design databases for business situations. The concept quiz provides an assessment of your understanding of the video lessons and associated notes. You should complete the concept quiz before starting practice problems and the graded assignment to ensure your conceptual understanding of the material.

Module 11 covers normalization, the second part of the logical database design process. Normalization provides tools to remove unwanted redundancy in a table design. You’ll discover the motivation for normalization, constraints to reason about unwanted redundancy, and rules that detect excessive redundancy in a table design. You’ll practice integrating and applying normalization techniques in the final lesson of this course. The concept quiz provides an assessment of your understanding of the video lessons and associated notes. You should complete the concept quiz before starting practice problems and the graded assignment to ensure your conceptual understanding of the material.

Module 12 provides optional advanced material on query formulation for learners who seek expert level knowledge and skills. Advanced query formulation can provide an edge in the workplace helping learners reach expert status with more value to an organization. Due to the advanced material, Module 12 provides Lesson 6 as honors with problems, quiz, assignment, and self evaluation. Module 12 covers four somewhat independent topics (outer joins, nested queries, membership exceptions, and containment exceptions) so learners can study these topics separately. These specialized problem areas, more difficult than combining tables with joins, provide important value to organizations when occurring in practice. To aid learners, Module 12 provides unique pedagogy with two problem-solving aids, text patterns to recognize elements of in problem statements and statement patterns to write template SELECT statements as an initial step to a complete SELECT statement. Lesson 5 provides a convenient summary of the text and statement patterns to provide learners a platform for the practice problems and assignment. The concept quiz provides an assessment of your understanding of the video lessons and associated notes. You should complete the concept quiz before starting practice problems and the graded assignment to ensure your conceptual understanding of the material.