Relational Database Design 101


Presenter: Diana Dee


Session Details


Are you an "accidental” DBA who has learned to administer SQL Server but does not understand the structure of relational databases? Do you know how to design a relational database but would like to learn how to explain the basics of database design to others? Have you ever wondered how you can flawlessly decide whether two tables have a one-to-many, many-to-many, or one-to-one relationship? Do you want to understand the basics of top-down and bottom-up database design? Do you want to be able to explain normalization to third normal form? Then this presentation is for you!


Keys and dependencies / determinants

What are the entities? (Top-down design)

Table connectivity (one-to-many or many-to-many)

What are the attributes? (Bottom-up design)



About the Speaker


Diana has been a Microsoft Certified Trainer since 1995.  She has taught Microsoft courses in Windows Server and SQL Server at the college level since 1996.  She has taught Microsoft courses to IT professionals since 2000.  Diana has been a course developer throughout her computer teaching career.  She has revised and developed database courses for an on-line University and for a major training company. Diana has been a SQL Server consultant, specializing in performance optimization, disaster recovery, replication, and Transact-SQL programming. She presented "How Indexes Optimize Query Performance" at SQL Saturday #44, April 2010.

In a previous lifetime, Diana earned a Ph.D. in Chemistry.  She lives in Huntington Beach, California, with her husband. They enjoy walking every day with their two Labrador Retrievers.  




Copyright 2013 by PASS | Terms of Use | Privacy | Login