Six-Step Relational Database Design

A step by step approach to relational database design
4.5 (6 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
99 students enrolled
Instructed by Fidel Captain IT & Software / Other
$30
Take This Course
  • Lectures 8
  • Contents Video: 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2015 English

Course 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.

What are the requirements?

  • Knowledge of basic information systems terms and terminology

What am I going to get from this course?

  • Create Entity Relationship Model diagrams
  • Create Crow's Foot Relational Model diagrams

What is the target audience?

  • 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 get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Relational Databases and Relational Database Design
06:02

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.

5 questions

Relational databases and relational database design

Section 2: The Six Steps
17:39

In this lecture, we will cover 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; and Step 1-3: Select identifiers, keys and primary keys from the attributes of each entity discovered.

At the end of the lecture you would be able to discover the entities in the problem domain, assign attributes to each entity discovered, and select identifiers and keys for each entity from the attributes of that entity. You will also learn definitions for the terms entity, attribute, identifier, key and primary key.

5 questions

Step 1: Discover entities and assign attributes

09:50

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.

7 questions

Step 2: Derive unary and binary relationships

05:43

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.

6 questions

Step 3: Create simplified Entity-Relationship Diagram

08:58

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 relationship with each other.

6 questions

Step 4: List assertions for all relationships

07:54

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.

6 questions

Step 5: Create detailed Entity-Relationship diagram using assertions

13: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.

6 questions

Step 6: Transform the detailed E-R Diagram into an implementable R-M Diagram

Section 3: Summary
05:39

A summary of the six-step relational database design process.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Fidel Captain, Database Developer, Web Developer, Lecturer and Consultant

Fidel A. Captain has over fifteen years of experience designing, implementing, and maintaining databases, and over ten years of experience as a lecturer.

He has worked as a systems analyst and systems engineer with the Ministry of Finance in Guyana, as a computer studies lecturer at the H. Lavity Stoutt Community College in the British Virgin Islands, and as a freelance consultant.

Captain has developed several database-based applications that include an online bill- payment system, a logistics and cargo-tracking system, a student-tracking and evaluation system, and a freight and duty calculation system.

He currently lectures at the H. Lavity Stoutt Community College in the British Virgin Islands in areas such as database design and development, website design and development, and Java programming.

Captain is a Queen’s College Guyana Scholar, who received his Bachelor’s of Engineering degree from the University of Manchester Institute of Science and Technology (UMIST) in Computer Systems Engineering and his Master’s in Information Technology from Capella University. He is also a certified MySQL developer and administrator.

Ready to start learning?
Take This Course