Six-Step Relational Database Design
4.2 (11 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.
145 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Six-Step Relational Database Design to your Wishlist.

Add to Wishlist

Six-Step Relational Database Design

A step by step approach to relational database design
4.2 (11 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.
145 students enrolled
Created by Fidel Captain
Last updated 8/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create Entity Relationship Model diagrams
  • Create Crow's Foot Relational Model diagrams
View Curriculum
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 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 8 Lectures Collapse All 8 Lectures 01:15:14
+
Relational Databases and Relational Database Design
1 Lecture 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.

Preview 06:02

Relational databases and relational database design

Relational databases and relational database design
5 questions
+
The Six Steps
6 Lectures 01:03:33

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.

Step 1: Discover entities and assign attributes
17:39

Step 1: Discover entities and assign attributes

Step 1
5 questions

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: Derive unary and binary relationships
09:50

Step 2: Derive unary and binary relationships

Step 2
7 questions

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.

Preview 05:43

Step 3: Create simplified Entity-Relationship Diagram

Step 3
6 questions

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.

Step 4: List assertions for all relationships
08:58

Step 4: List assertions for all relationships

Step 4
6 questions

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: Create detailed Entity-Relationship diagram using assertions
07:54

Step 5: Create detailed Entity-Relationship diagram using assertions

Step 5
6 questions

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: Transform the detailed E-R diagram into an implementable R-M diagram
13:29

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

Step 6
6 questions
+
Summary
1 Lecture 05:39

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

Summary
05:39
About the Instructor
Fidel Captain
4.1 Average rating
14 Reviews
173 Students
2 Courses
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.