May 2010
Intermediate to advanced
815 pages
21h 55m
English
book
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
by Tom Carpenter
Content preview from SQL Server® 2008 Administration: Real World Skills for MCITP Certification and BeyondBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Relational Database Theory
You do not have to be a relational-database design guru to administer and implement SQL Server 2008 servers and databases, but having a solid foundational understanding of relational database theory will help you make better decisions when creating databases. In this section, you will delve deeper into the concepts of data, information, tables, and table components. You'll also explore the common relationship types that exist between database tables.
Data
Data should not be confused with information. For example, the following list represents data:
- 45908
- Thomas
- 43.27
When you look at this list, you cannot be certain what it represents. Is 43.27 a price, a percentage, or simply a precise value? Is the value 45908 a ...