Designing and Creating a SQL Server Database
Many people believe that database tools are so easy to use that database design is something that they don't need to worry about. I couldn't disagree more! Just as a house without a foundation will fall over, a database with poorly designed tables and relationships will fail to meet the needs of the users. Therefore, before you learn how to create a SQL Server database, you must first learn database design principles.
The History of Relational Database Design
Dr. E.F. Codd first introduced formal relational database design in 1969 while he was at IBM. He based it on set theory and predicate logic. Relational theory applies to both databases and database applications. Codd developed 12 rules that determine ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
