What you'll learn

Identify entities and their corresponding attributes for a given relational database design problem
Derive relationships between entities for a given relational database design problem
Create Entity Relationship Model diagrams for a given relational database design problem
Create Crow's Foot Relational Model diagrams for a given relational database design problem

Course content

3 sections • 14 lectures • 1h 30m total length

Relational databases and relational database design4:10
This lectures covers relational database design; the relational database design process; and relational database design in six easy steps.

At the end of the lecture you will be able to describe relational database design and explain the relational database design process. You will also understand how six-step relational database design fits into the relational database design process.
Relational databases and relational database design

Step 1-1: Discover the entities6:41
In this lecture, we will cover the first sub-step of the first step of the six-step relational database design process, Step 1-1: Discover the entities. This is the first part of three sub-steps of Step 1 of the six-step relational database design process.
At the end of the lecture you would be able to discover the entities in the problem domain.
Step 1-2: Assign attributes to each entity discovered5:32
In this lecture, we will cover the second sub-step of the first step of the six-step relational database design process, Step 1-2: Assign attributes to each entity discovered. This is the second part of three sub-steps of Step 1 of the six-step relational database design process.
At the end of the lecture you would be able to assign attributes to each entity discovered in the problem domain.
Step 1-3: Create primary keys and select identifiers6:16
In this lecture, we will cover the third sub-step of the first step of the six-step relational database design process, Step 1-3: Create primary keys and select identifiers. This is the third part of three sub-steps of Step 1 of the six-step relational database design process.
At the end of the lecture you would be able to reate primary keys and select identifiers for each entity discovered in the problem domain.
Step 1
Step 2: Derive unary and binary relationships8:05
In this lecture, we will cover the second step of the six-step relational database design process, which is divided into two sub-steps: Step 2-1: Build the Matrix; Step 2-2: Fill in the Matrix.

At the end of the lecture you would be able to find all of the relationships that exist between any pair of entities in the database. You will also learn how to use an Entity-Entity Matrix to find these relationships, and definitions for the terms relationship, unary relationship and binary relationship.
Step 2
Step 3: Create simplified Entity-Relationship diagram5:56
In this lecture, we will cover the third step of the six-step relational database design process, which has only one sub-step: Step 3-1: Create simplified Entity-Relationship Diagram.

At the end of the lecture you would be able to use the information gathered in the previous two steps to construct a simplified E-R diagram using the notation presented in this lecture series. This simplified diagram only contains information about the entities and the relationships that exist between the entities. It does not contain information about the Optionality and Cardinality of the relationships.
Step 3
Step 4: List assertions for all relationships12:24
In this lecture, we will cover the fourth step of the six-step relational database design process, which has only one sub-step: Step 4-1: List assertions using the simplified E-R Diagram.
At the end of the lecture you would be able to use the simplified E-R diagram created in Step 3 of the six-step process to create a list of assertions for the database that is being designed. These assertions give definitive information about the entities in the database and their relationships with each other.
Step 4
Step 5: Create detailed Entity-Relationship diagram using assertions5:28
In this lecture, we will cover the fifth step of the six-step relational database design process, which has only one sub-step: Step 5-1: Use assertions and the simplifed E-R diagram to create detailed E-R diagram.

At the end of the lecture you would be able to combine the assertions listed in Step 4 of the six-step process with the simplified E-R diagram created in Step 3 of the six-step process to create a detailed E-R diagram. This detailed E-R diagram contains information about optionalities and cardinalities.
Step 5
Step 6: Transform the detailed E-R diagram into an implementable R-M diagram3:45
In this lecture, we will begin to look at the last step of the six-step relational database design process, which involves transforming the detailed E-R diagram into an implementable R-M Diagram.
At the end of the lecture you would be introduced to Crow’s Foot Relational Model diagrams and the notation used on these diagrams.
Step 6-1: Many-to-many relationships5:16
In this lecture, we will cover the first sub-step of the sixth step of the six-step relational database design process, Step 6-1: Many-to-Many relationships. This is the first of four sub-steps of Step 6 of the six-step relational database design process, and it describes how to transform many-to-many relationships in the detailed Entity Relationship diagram into their appropriate representation on the crow's foot Relational Model diagram.
At the end of the lecture you would be able to transform many-to-many relationships in the detailed Entity Relationship diagram into their appropriate representation on the crow's foot Relational Model diagram.
Step 6-2: One-to-many relationships4:32
In this lecture, we will cover the first sub-step of the sixth step of the six-step relational database design process, Step 6-2: One-to-Many relationships. This is the second of four sub-steps of Step 6 of the six-step relational database design process, and it describes how to transform one-to-many relationships in the detailed Entity Relationship diagram into their appropriate representation on the crow's foot Relational Model diagram.
At the end of the lecture you would be able to transform one-to-many relationships in the detailed Entity Relationship diagram into their appropriate representation on the crow's foot Relational Model diagram.
Step 6-3: One-to-one relationships3:38
In this lecture, we will cover the first sub-step of the sixth step of the six-step relational database design process, Step 6-3: One-to-one relationships. This is the third of four sub-steps of Step 6 of the six-step relational database design process, and it describes how to transform one-to-one relationships in the detailed Entity Relationship diagram into their appropriate representation on the crow's foot Relational Model diagram.
At the end of the lecture you would be able to transform one-to-one relationships in the detailed Entity Relationship diagram into their appropriate representation on the crow's foot Relational Model diagram.
Step 6: All relationships13:29
In this lecture, we will cover the last step of the six-step relational database design process, which is divided into four sub-steps: Step 6-1: Many-to-many relationships; Step 6-2: One-to-many relationships; Step 6-3: One-to-one relationships; and Step 6-4: Combine results to create R-M Diagram.

At the end of the lecture you would be able to convert the detailed E-R diagram created in Step 5 of the six-step process into a Crow's Foot R-M diagram. This diagram can then be implemented on any relational database management system.
Step 6

Requirements

Knowledge of basic information systems terms and terminology

Description

Database design is the most important task performed by application developers because the resulting database and all applications that access it are based on this design. Therefore, if the data for the application is modeled incorrectly and the resulting database poorly designed, poor and difficult to use applications will result.

Learn how to design databases in six easy steps

Create implementable database models
Create Crow's Foot Relational Model (R-M) diagrams
Create Entity Relationship Model (E-R) diagrams
Case studies to reinforce the instructions
Easy to follow, step by step instructions

Learn how to create sturdy, reliable and accurate data models for your databases

A database is the backbone of any application, and therefore it must be sturdy, reliable, and accurate. Having a well-designed database is the key to having your database meet these criteria, and the six-step technique taught by this course ensures that the data model upon which your database is built is sturdy, reliable, and accurate.

The six steps outlined in this course are simple, easy to follow, and precise. It teaches you how to quickly and accurately model the data that your application will use, and shows you how to do so in the shortest possible time. Extensive knowledge of database theory is not required and the theory is kept to a minimum.

Video lectures are used to present the material, and case studies are incorporated into the lectures thus reinforcing the steps of the database design technique taught by this course. There is also a lot of supplemental material that you can download and read, which explains each of the steps in further detail.

Who this course is for:

This course is meant for IT/Computer Science individuals who, as part of their portfolio, have to develop and implement relational databases.
This is a database design course and is for persons who need to learn how to design databases and document them using Crow's Foot Relational Model diagrams. It does not teach you how to implement the derived design.

What you'll learn

Explore related topics

Course content

Relational Databases and Relational Database Design1 lecture • 4min

The Six Steps12 lectures • 1hr 21min

Summary1 lecture • 6min

Requirements

Description

Who this course is for: