In this talk, C# and Visual Basic author Rod Stephens will walk through a group discussion leading to the design of some practical databases. He’ll first discuss three general approaches to database design: existing data centered, UI centered, and database centered.
Then Rod will lead the group in several attempts to design several databases from scratch. As a group, we’ll think of database scenarios and develop robust and flexible designs to handle them. We’ll normalize (and denormalize) them as necessary to prevent data anomalies as the databases are used and modified over time.
Rod Stephens started out as a mathematician, but while studying at MIT, discovered how much fun programming is and has been programming professionally ever since. During his career, he has worked on an eclectic assortment of applications in such fields as telephone switching, billing, repair dispatching, tax processing, wastewater treatment, concert ticket sales, cartography, and training for professional football players.
Rod has been a Microsoft Visual Basic Most Valuable Professional (MVP) for more than 12 years and has taught introductory programming. He has written 30 books that have been translated into languages from all over the world, and more than 250 magazine articles mostly covering Visual Basic, C#, Visual Basic for Applications, Delphi, and Java.
Rod’s popular VB Helper web site (http://www.vb-helper.com) receives several million hits per month and contains thousands of pages of tips, tricks, and example programs for Visual Basic programmers, as well as example code for this book. His C# Helper web site (http://www.csharphelper.com) contains similar material for C# programmers.