Case Studies in Six-Step Relational Database Design

Illustrating the six-step relational database design process using case studies.
4.3 (2 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.
57 students enrolled
Instructed by Fidel Captain IT & Software / Other
$19
$20
5% off
Take This Course
  • Lectures 7
  • Length 1 hour
  • Skill Level Intermediate 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 8/2015 English

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

What are the 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.

What am I going to get from this course?

  • Create Crow's Foot Relational Database Models
  • Create Entity-Relationship Diagrams

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

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: Introduction
02:52

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

Section 2: Six-Step Relational Database Design
04:31

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.

5 questions

Quiz for Lecture 1.

05:32

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.

5 questions

Quiz for Lecture 2.

Section 3: Case Studies
08:38

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

5 questions

Quiz for Case Study 1

08:56

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

5 questions

Quiz for Case Study 2

08:56

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

5 questions

Quiz for Case Study 3

Section 4: Summary
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.

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