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
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.
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.
Quiz for Lecture 1.
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.
Quiz for Lecture 2.
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."
Quiz for Case Study 1
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."
Quiz for Case Study 2
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."
Quiz for Case Study 3
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.
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.