Relational Database Design

Course Overview

This course provides you with the opportunity to learn about relational database design. You will be provided an in-depth understanding of the design principles and methodologies involved in creating well-structured, normalized, and efficient relational databases to manage data for small, medium, and large-scale enterprises. Possessing database design skills will enable you to excel in careers such as Database Administrators, Data Analysts, Software Developers, Data Engineers, and Business Intelligence Developers; capitalizing on the ability to create robust and efficient data solutions for any organization. These are one of the top sought-after careers across many industries today. At the end of this course, you will be able to: - Describe the process and the design aspects involved in relational database design. - Interpret the main components of an Entity-Relationship diagram (ERD) using unified modeling language (UML) notation. - Develop entity-relationship diagrams using basic and extended Entity-relationship features in relational design. - Translate Entity-Relationships diagrams into logical schemas (relation schemas). - Describe the theory and practical application of functional dependencies in relational database design. - Use the theory to recognize candidate keys and primary keys. - Derive minimal and canonical covers of functional dependencies. - Describe the principles of database normalization. - Identify and apply normalization techniques.