Pro SQL Server relational database design and implementation. ([2016])

• Record Type: Book
• 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 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.
• 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.