Case Studies in Six-Step Relational Database Design
4.5 (3 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.
74 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Case Studies in Six-Step Relational Database Design

Illustrating the six-step relational database design process using case studies.
4.5 (3 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.
74 students enrolled
Created by Fidel Captain
Last updated 2/2016
English
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create Crow's Foot Relational Database Models
  • Create Entity-Relationship Diagrams
View Curriculum
Requirements
  • The Six-Step Relational Database Design course is a prerequisite, but not necessary if you are familiar with other database design techniques. A summary of the six steps taught in the prerequisite course is covered in lecture 2.
Description

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 database design technique ensures that the data model upon which your database is based is sturdy, reliable, and accurate.

Review case studies on designing relational databases in six easy steps

  • Review the Six-Step Relational Database Design technique
  • Learn by example using case studies that go through designing a database in six easy steps
  • Each case study goes through each of the six steps
  • Each case study starts with a problem statement and ends with a Crow's Foot R-M diagram
  • Challenge yourself with case studies increasing in complexity

Case studies demonstrating the Six-Step Relational Database Design technique

After a brief overview of the six-step database design process, three case studies are used to demonstrate how the technique works. Each case study starts with a concise statement of the problem and then goes through each of the six steps that are part of the six-step database design technique, ending with a Crow's Foot relational database model.

Some knowledge of database design terminology and techniques is required, and while this course does delve into the details of the six-step relational database design technique, you will learn, from examples, how this technique can be used to create a sturdy, reliable, and accurate relational database model. The extensive supplemental resources (handouts) that compliment the video tutorials allow you to fully understand how the six-step relational database design technique works.

You will learn what the six steps of Six-Step Relational Database Design are, and how they work to transform a problem statement into a Crow's Foot relational database model using three examples.

Who is the target audience?
  • This course is designed for students who have a basic understanding of database design and want to learn how to quickly and easily create a Crow's Foot relational database model from any given problem specification.
Curriculum For This Course
Expand All 7 Lectures Collapse All 7 Lectures 45:01
+
Introduction
1 Lecture 02:52

This lecture introduces the course and outlines what you will learn from Case Studies in Six-Step Relational Database Design.

Preview 02:52
+
Six-Step Relational Database Design
2 Lectures 10:03

This lectures covers 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 the relational database design process, and explain how six-step relational database design fits into the relational database design process.

Preview 04:31

Quiz for Lecture 1.

The Relational Database Design Process
5 questions

This lecture reviews the six steps that make up Six-Step Relational Database Design.

At the end of this lecture you will be able to describe the six steps that make up Six-Step Relational Database Design and list the sub-steps for each of these steps. You will also be able to identify the outcomes of each of these steps.

Preview 05:32

Quiz for Lecture 2.

The Six Steps
5 questions
+
Case Studies
3 Lectures 26:30

This lecture goes through the first case study demonstrating the six-step relational database design technique.

"A small accounting firm wants a simple HR application that will help it to keep track of its employees, their positions, allowances, salary scales, and which company vehicles their employees drive."

Case Study 1
08:38

Quiz for Case Study 1

Case Study 1
5 questions

This lecture goes through the second case study demonstrating the six-step relational database design technique.

"The owners of a small computer repair shop would like to keep track of the repair jobs for computers they repair, the items used for each repair job, the labor costs for each repair job, the repairmen performing each repair job, and the total cost of each repair job."

Case Study 2
08:56

Quiz for Case Study 2

Case Study 2
5 questions

This lecture goes through the third case study demonstrating the six-step relational database design technique.

"The registrar at a small college wants an application that will help their department keep track of the schedule of classes, the courses and lecturers appearing in the schedule, and the students registering for courses according to the schedule."

Case Study 3
08:56

Quiz for Case Study 3

Case Study 3
5 questions
+
Summary
1 Lecture 05:36

This lecture summarizes the six-step relational database design process by listing each of the six steps and showing an example of what the outputs are for that step.

Summary
05:36
About the Instructor
Fidel Captain
4.1 Average rating
14 Reviews
176 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.