000771352 000__ 04827cam\a2200541Ii\4500 000771352 001__ 771352 000771352 005__ 20230306142602.0 000771352 006__ m\\\\\o\\d\\\\\\\\ 000771352 007__ cr\un\nnnunnun 000771352 008__ 170103s2016\\\\xxu\\\\\o\\\\\001\0\eng\d 000771352 019__ $$a967877958 000771352 020__ $$a9781484219737$$q(electronic book) 000771352 020__ $$a1484219732$$q(electronic book) 000771352 020__ $$z9781484219720 000771352 035__ $$aSP(OCoLC)ocn967511996 000771352 035__ $$aSP(OCoLC)967511996$$z(OCoLC)967877958 000771352 040__ $$aN$T$$beng$$erda$$epn$$cN$T$$dGW5XE$$dEBLCP$$dYDX$$dIDEBK 000771352 049__ $$aISEA 000771352 050_4 $$aQA76.73.S67 000771352 08204 $$a005.75/85$$223 000771352 1001_ $$aDavidson, Louis,$$eauthor. 000771352 24510 $$aPro SQL Server relational database design and implementation /$$cLouis Davidson with Jessica Moss ; foreward by Kalen Delaney. 000771352 250__ $$aFifth edition. 000771352 264_1 $$a[United States] :$$bApress,$$c2016. 000771352 264_2 $$aNew York, NY :$$bDistributed to the book trade worldwide by Springer, 000771352 264_4 $$c©2016 000771352 300__ $$a1 online resource. 000771352 336__ $$atext$$btxt$$2rdacontent 000771352 337__ $$acomputer$$bc$$2rdamedia 000771352 338__ $$aonline resource$$bcr$$2rdacarrier 000771352 500__ $$aIncludes index. 000771352 5050_ $$aAt 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 000771352 5058_ $$aRule 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 000771352 5058_ $$aWorking 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? 000771352 5058_ $$aWill 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 000771352 5058_ $$aRecursive 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 000771352 506__ $$aAccess limited to authorized users. 000771352 588__ $$aOnline resource; title from PDF title page (SpringerLink, viewed January 9, 2017). 000771352 63000 $$aSQL server. 000771352 650_0 $$aClient/server computing. 000771352 650_0 $$aRelational databases. 000771352 650_0 $$aDatabase management. 000771352 7001_ $$aMoss, Jessica M.,$$eauthor. 000771352 77608 $$iPrint version:$$aDavidson, Louis$$tPro SQL Server Relational Database Design and Implementation$$dBerkeley, CA : Apress,c2016$$z9781484219720 000771352 852__ $$bebk 000771352 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-1973-7$$zOnline Access$$91397441.1 000771352 909CO $$ooai:library.usi.edu:771352$$pGLOBAL_SET 000771352 980__ $$aEBOOK 000771352 980__ $$aBIB 000771352 982__ $$aEbook 000771352 983__ $$aOnline 000771352 994__ $$a92$$bISE