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.