Relational Database Design
This course is for anyone who wants to understand relational database design, or data modeling in general. You will learn how to gather requirements, model them, normalize the model, and transform that model into a fully normalized relational database design.
What you'll learn
In this course, you will learn all the skills required to design good relational databases. This starts with information gathering: how to find all required information, and how to ask questions without miscommunications. You will learn how to abstract the information gathered into a data model, how to normalize the data model so that your database will be free of anomalies, and how to transform the final, normalized data model into a relational database design - ready to be implemented.
Table of contents
- Outline 1m
- Different Representations 5m
- Representing a Relational Design 4m
- ER to Relational: Entity Types 5m
- ER to Relational: Candidate Keys 4m
- ER to Relational: One-to-many Relationships 6m
- ER to Relational: Many-to-many Relationships 4m
- ER to Relational: Other Constraints 6m
- ER to Relational: Demo 10m
- Relational to ER: First Draft 7m
- Relational to ER: Variations 4m
- Relational to ER: Demo 7m
- Summary 3m
- Outline 2m
- Why Normalize? 10m
- Functional Dependencies 9m
- First Normal Form 10m
- Find Functional Dependencies 1: Are Candidate Keys Minimal 9m
- Find functional Dependencies 2: Missing Candidate Keys 9m
- Demo: Verify that Attributes are Atomic 6m
- Demo: Verify that Candidate Keys are Minimal 11m
- Demo: Check for Missing Candidate Keys 14m
- Summary 2m
Course FAQ
There are many types of database models, but some of the more popular ones are the relational model, network model, object-oriented model, and Hierarchical model
Relational database design, or RDD, is the process of formatting information and data into various tables, each with rows and columns. The columns define an attribute of the data and the rows indicate individual records. Relational databases are edited and revised through use of SQL - Structured Query Language.
About the author
Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums; reading and writing books and blogs; and attending and speaking at conferences. Hugo is a SQL Server M... more