• Presentations
  • Presentations
  • IMG 0341
  • Presentations
  • IMG 0409

Lecture 1: The Six Steps

(16 votes, average 5.00 out of 5)

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

    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

    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.99
    Watch Video

    MP4 FILE
    FILE SIZE: 190MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 6:16
    PRICE: US$1.99
    Watch Video

  • Step 1 - Discover Entities and Assign Attributes

    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 discovered

    MOV FILE
    FILE SIZE: 94MB
    DIMENSIONS: 1280x720 HD
    DURATION: 17:52
    PRICE: US$8.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 628MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 17:52
    PRICE: US$8.99
    Watch Preview

  • Step 2 - Derive Unary and Binary Relationships

    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 Matrix

    MOV FILE
    FILE SIZE: 56MB
    DIMENSIONS: 1280x720 HD
    DURATION: 10:01
    PRICE: US$6.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 319MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 10:01
    PRICE: US$6.99
    Watch Preview

  • Step 3 - Create Simplified Entity-Relationship Diagram

    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 diagram

    MOV FILE
    FILE SIZE: 35MB
    DIMENSIONS: 1280x720 HD
    DURATION: 5:57
    PRICE: US$4.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 208MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 5:57
    PRICE: US$4.99
    Watch Preview

  • Step 4 - List Assertions for all Relationships

    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 diagram

    MOV FILE
    FILE SIZE: 54MB
    DIMENSIONS: 1280x720 HD
    DURATION: 9:08
    PRICE: US$5.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 344MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 9:08
    PRICE: US$5.99
    Watch Preview

  • Step 5 - Create Detailed E-R Diagram Using Assertions

    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 diagram

    MOV FILE
    FILE SIZE: 51MB
    DIMENSIONS: 1280x720 HD
    DURATION: 8:04
    PRICE: US$5.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 317MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 8:04
    PRICE: US$5.99
    Watch Preview

  • Step 6 - Transform Detailed E-R Diagram Into an Implementable R-M Diagram

    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 diagram

    MOV FILE
    FILE SIZE: 78MB
    DIMENSIONS: 1280x720 HD
    DURATION: 13:29
    PRICE: US$8.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 515MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 13:29
    PRICE: US$8.99
    Watch Preview

  • Summary of the six steps

    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.99
    Watch Preview

    MP4 FILE
    FILE SIZE: 219MB
    DIMENSIONS: 1920x1080 HD
    DURATION: 5:53
    PRICE: US$4.99
    Watch Preview

  • The Six Steps (bundle)

    The Six Steps (bundle)

    Step 1 to Step 6, the Summary, and Relational Database Design and the Six-Step process are all bundled together and available as one download for your convenience.

    This download contains the following videos lectures:
    * Relational Database Design and the Six-Step Process
    * Step 1 - Discover Entities and Assign Attributes
    * Step 2 - Derive Unary and Binary Relationships
    * Step 3 - Create Simplified Entity-Relationship Diagram
    * Step 4 - List Assertions for all Relationships
    * Step 5 - Create Detailed E-R Diagram Using Assertions
    * Step 6 - Transform Detailed E-R Diagram Into an Implementable R-M Diagram
    * Summary of the six steps

    MOV FILES (ZIP ARCHIVE)
    FILE SIZE: 365MB
    DIMENSIONS: 1280x720 HD
    DURATION: 1:16:40
    PRICE: US$24.99 US$9.99
    MP4 FILES (ZIP ARCHIVE)
    FILE SIZE: 2.3GB
    DIMENSIONS: 1920x1080 HD
    DURATION: 1:16:40
    PRICE: US$24.99 US$9.99

  • 1

The six-step database design video lecture series is designed to compliment the Six-Step Relational Database Design™ book and is divided into the following lectures:

Explore the online courses for a comprehensive eLearning experience:


Follow along in the Book (Kindle Version available at Amazon)
Amazon.com Buy on Amazon.com (paperback - US$24.04 and Kindle - US$9.99)
Amazon (Canada) Buy on Amazon.ca (paperback - CAN$38.75 and Kindle - CAN$9.99)
Amazon (UK) Buy on Amazon.co.uk (paperback - £19.50 and Kindle - £7.69)
Amazon (India) Buy on Junglee (paperback - Rupees 1,917)
Publisher Buy directly from the publishers CreateSpace (paperback - US$19.00)
Use Discount Code VL6T8KU8 at checkout to get US$10.00 off