Case Studies in Six-Step Relational Database Design

Course details

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.