Relational Database Design

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.