Pro SQL Server relational database design and implementation. ([2016])
- Record Type:
- Book
- Title:
- Pro SQL Server relational database design and implementation. ([2016])
- Main Title:
- Pro SQL Server relational database design and implementation
- Further Information:
- Note: Louis Davidson with Jessica Moss ; foreward by Kalen Delaney.
- Authors:
- Davidson, Louis
Moss, Jessica M - Contents:
- At a Glance; Contents; Foreword; About the Authors; About the Technical Reviewers; Acknowledgments; Introduction; Chapter 1: The Fundamentals; Taking a Brief Jaunt Through History; Introducing Codd's Rules for an RDBMS; Rule 1: The Information Principle; Rule 2: Guaranteed Access; Rule 3: Systematic Treatment of NULL Values; Rule 4: Dynamic Online Catalog Based on the Relational Model; Rule 5: Comprehensive Data Sublanguage Rule; Rule 6: View Updating Rule; Rule 7: High-Level Insert, Update, and Delete; Rule 8: Physical Data Independence; Rule 9: Logical Data Independence. Rule 10: Integrity IndependenceRule 11: Distribution Independence; Rule 12: Nonsubversion Rule; Nodding at SQL Standards; Recognizing Relational Data Structures; Introducing Databases and Schemas; Understanding Tables, Rows, and Columns; Working with Missing Values (NULLs); Defining Domains; Storing Metadata; Defining Uniqueness Constraints (Keys); Types of Keys; Choosing Keys; Natural Keys; Smart Keys; Surrogate Keys; Understanding Relationships; Working with Binary Relationships; One-to-Many Relationships; One-to-Many (The General Case); One-to-N Relationship; Many-to-Many Relationships. Working with Nonbinary RelationshipsUnderstanding Functional Dependencies; Understanding Functional Dependencies; Finding Determinants; Relational Programming; Outlining the Database-Specific Project Phases; Conceptual Phase; Logical Phase; Physical; Engine Adjustment Phase; Summary; Chapter 2: Introduction toAt a Glance; Contents; Foreword; About the Authors; About the Technical Reviewers; Acknowledgments; Introduction; Chapter 1: The Fundamentals; Taking a Brief Jaunt Through History; Introducing Codd's Rules for an RDBMS; Rule 1: The Information Principle; Rule 2: Guaranteed Access; Rule 3: Systematic Treatment of NULL Values; Rule 4: Dynamic Online Catalog Based on the Relational Model; Rule 5: Comprehensive Data Sublanguage Rule; Rule 6: View Updating Rule; Rule 7: High-Level Insert, Update, and Delete; Rule 8: Physical Data Independence; Rule 9: Logical Data Independence. Rule 10: Integrity IndependenceRule 11: Distribution Independence; Rule 12: Nonsubversion Rule; Nodding at SQL Standards; Recognizing Relational Data Structures; Introducing Databases and Schemas; Understanding Tables, Rows, and Columns; Working with Missing Values (NULLs); Defining Domains; Storing Metadata; Defining Uniqueness Constraints (Keys); Types of Keys; Choosing Keys; Natural Keys; Smart Keys; Surrogate Keys; Understanding Relationships; Working with Binary Relationships; One-to-Many Relationships; One-to-Many (The General Case); One-to-N Relationship; Many-to-Many Relationships. Working with Nonbinary RelationshipsUnderstanding Functional Dependencies; Understanding Functional Dependencies; Finding Determinants; Relational Programming; Outlining the Database-Specific Project Phases; Conceptual Phase; Logical Phase; Physical; Engine Adjustment Phase; Summary; Chapter 2: Introduction to Requirements; Documenting Requirements; Gathering Requirements; Interviewing Clients; Asking the Right Questions; What Data Is Needed?; How Will the Data Be Used?; What Rules Govern the Use of the Data?; What Data Is Reported On?; Where Is the Data Now? Will the Data Need to Be Integrated with Other Systems?How Much Is This Data Worth?; Who Will Use the Data?; Are Existing Systems Being Replaced?; Utilizing Other Types of Documentation; Early Project Documentation; Contracts or Client Work Orders; Level of Service Agreement; Audit Plans; Prototypes; Following Best Practices; Summary; Chapter 3: The Language of Data Modeling; Introducing Data Modeling; Entities; Attributes; Primary Keys; Alternate Keys; Foreign Keys; Domains; Relationships; Identifying Relationships; Nonidentifying Relationships; Role Names; Relationship Cardinality. Recursive RelationshipsSubtypes; Many-to-Many Relationships; Verb Phrases (Relationship Names); Descriptive Information; Alternative Modeling Methodologies; Information Engineering; Chen ERD; Best Practices; Summary; Chapter 4: Conceptual and Logical Data Model Production; Example Scenario; Building the Conceptual Model; Identifying Entities; Persons; Places; Objects; Ideas; Documents; Groups; Other Entities; Audit Trails; Events; Records and Journals; Entity Recap; Identifying Relationships Between Entities; One-to-N Relationships; Simple Relationships; Connection; Transactions. … (more)
- Edition:
- Fifth edition
- Publisher Details:
- United States : Apress
- Publication Date:
- 2016
- Copyright Date:
- 2016
- Extent:
- 1 online resource
- Subjects:
- 005.75/85
Computer science
Client/server computing
Relational databases
Database management
COMPUTERS -- Client-Server Computing
Client/server computing
Database management
Relational databases
Computer Science
Database Management
Computers -- Database Management -- General
Databases
Electronic books - Languages:
- English
- ISBNs:
- 9781484219737
1484219732 - Related ISBNs:
- 9781484219720
1484219724 - Notes:
- Note: Includes bibliographical references and index.
Note: Online resource; title from PDF title page (SpringerLink, viewed January 9, 2017). - Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.368847
- Ingest File:
- 02_348.xml