• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. SQL Server Basics > Designing and Creating a SQL Server Database

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 how well an application and its data adhere to the relational model. Since Codd first conceived these 12 rules, the number of rules has expanded into the hundreds!


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint