The first lecture, The Six Steps, teaches you how to create implementable relational database models in six steps. It goes through the six steps outlined in the book detailing each step using a case study to reinforce the methodology. This lecture is recommended for persons wanting to learn the details of each step in the six-step relational database design process.
You can preview all of the videos in the lecture below before you purchase them, and in some instances you can watch the entire video. You can also watch these previews and videos directly on my YouTube channel .
The downloadable files for the videos are in the .mov and .mp4 formats, and you are free to use them for your own personal use or as part of classroom teaching and learning activities. The videos are NOT to be shared or distributed in any format or on any medium whatsoever. Instructors, please direct your students to this site if they would like to have their own copies of the videos. ALL SALES ARE FINAL.
The Six Steps
-
Overview of The Six-Steps video lecture
This video covers what six-step relational database design is all about; who six-step relational database design is for; and what the six-step database design video series will teach you.
Watch Video -
Relational Database Design and the Six-Step Process
This video covers relational database design; the relational database design process; and relational database design in six easy steps.
MOV FILE FILE SIZE: 32MB
DIMENSIONS: 1280x720 HD
DURATION: 6:16
PRICE: US$1.99Watch Video MP4 FILE FILE SIZE: 190MB
DIMENSIONS: 1920x1080 HD
DURATION: 6:16
PRICE: US$1.99Watch Video -
Step 1 - Discover Entities and Assign Attributes
Step one of the six-step relational database design process - Discover entities and assign attributes to these entities.
This video lecture covers the first step of the six-step relational database design process, which is divided into three sub-steps:
* Step 1-1: Discover the entities
* Step 1-2: Assign attributes to each entity discovered
* Step 1-3: Select identifiers, keys and primary keys from the attributes of each entity discoveredMOV FILE FILE SIZE: 94MB
DIMENSIONS: 1280x720 HD
DURATION: 17:52
PRICE: US$8.99Watch Preview MP4 FILE FILE SIZE: 628MB
DIMENSIONS: 1920x1080 HD
DURATION: 17:52
PRICE: US$8.99Watch Preview -
Step 2 - Derive Unary and Binary Relationships
Step two of the six-step relational database design process - Derive unary and binary relationships.
This video lecture covers 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 MatrixMOV FILE FILE SIZE: 56MB
DIMENSIONS: 1280x720 HD
DURATION: 10:01
PRICE: US$6.99Watch Preview MP4 FILE FILE SIZE: 319MB
DIMENSIONS: 1920x1080 HD
DURATION: 10:01
PRICE: US$6.99Watch Preview -
Step 3 - Create Simplified Entity-Relationship Diagram
Step three of the six-step relational database design process - Create simplified Entity-Relationship diagram.
In this video 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 E-R diagramMOV FILE FILE SIZE: 35MB
DIMENSIONS: 1280x720 HD
DURATION: 5:57
PRICE: US$4.99Watch Preview MP4 FILE FILE SIZE: 208MB
DIMENSIONS: 1920x1080 HD
DURATION: 5:57
PRICE: US$4.99Watch Preview -
Step 4 - List Assertions for all Relationships
Step four of the six-step relational database design process - List assertions for all relationships.
In this video 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 diagramMOV FILE FILE SIZE: 54MB
DIMENSIONS: 1280x720 HD
DURATION: 9:08
PRICE: US$5.99Watch Preview MP4 FILE FILE SIZE: 344MB
DIMENSIONS: 1920x1080 HD
DURATION: 9:08
PRICE: US$5.99Watch Preview -
Step 5 - Create Detailed E-R Diagram Using Assertions
Step five of the six-step relational database design process - Create detailed E-R diagram using assertions.
In this video 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 simplified E-R diagram to create detailed E-R diagramMOV FILE FILE SIZE: 51MB
DIMENSIONS: 1280x720 HD
DURATION: 8:04
PRICE: US$5.99Watch Preview MP4 FILE FILE SIZE: 317MB
DIMENSIONS: 1920x1080 HD
DURATION: 8:04
PRICE: US$5.99Watch Preview -
Step 6 - Transform Detailed E-R Diagram Into an Implementable R-M Diagram
Step six of the six-step relational database design process - Transform detailed E-R diagram into an implementable R-M diagram.
In this video lecture, we will cover the sixth 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
* Step 6-4: Combine results to create R-M diagramMOV FILE FILE SIZE: 78MB
DIMENSIONS: 1280x720 HD
DURATION: 13:29
PRICE: US$8.99Watch Preview MP4 FILE FILE SIZE: 515MB
DIMENSIONS: 1920x1080 HD
DURATION: 13:29
PRICE: US$8.99Watch Preview -
Summary of the six steps
Summary of the six-step relational database design process - The six steps summarized.
In this video lecture, the six steps of the six-step relational database design process are briefly described and summarized.MOV FILE FILE SIZE: 45MB
DIMENSIONS: 1280x720 HD
DURATION: 5:53
PRICE: US$4.99Watch Preview MP4 FILE FILE SIZE: 219MB
DIMENSIONS: 1920x1080 HD
DURATION: 5:53
PRICE: US$4.99Watch Preview
- 1
Follow