Your cart is empty.
Keep shoppingCase Studies in Six-Step Relational Database Design
251 students
Case Studies in Six-Step Relational Database Design
Illustrating the six-step relational database design process using case studies.
Created byFidel Captain
Last updated 2/2016
English
What you'll learn
- Create Crow's Foot Relational Database Models
- Create Entity-Relationship Diagrams
Explore related topics
Course content
4 sections • 7 lectures • 45m total length
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 this course is for:
- 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.