LEADER 05138nam 2200613Ia 450 001 9910462898103321 005 20200520144314.0 010 $a1-58347-719-5 035 $a(CKB)2670000000341856 035 $a(EBL)1158870 035 $a(OCoLC)833765288 035 $a(SSID)ssj0001075994 035 $a(PQKBManifestationID)11569130 035 $a(PQKBTitleCode)TC0001075994 035 $a(PQKBWorkID)11251850 035 $a(PQKB)10413807 035 $a(MiAaPQ)EBC1158870 035 $a(Au-PeEL)EBL1158870 035 $a(CaPaEBR)ebr10679030 035 $a(CaONFJC)MIL535275 035 $a(EXLCZ)992670000000341856 100 $a20130415d2013 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aDatabase design and SQL for DB2$b[electronic resource] /$fJames Cooper 205 $a1st ed. 210 $aBoise, ID $cMC Press$dc2013 215 $a1 online resource (505 p.) 300 $aIncludes index. 311 $a1-58347-357-2 327 $aCover; Copyright; Dedication; Acknowledgments; Contents At A Glance; Contents; Introduction; Intended Audience; Companion Website; Instructors; Students; Contributors; Chapter 1: Database Concepts; Chapter Objectives; Introduction to Database and Database Management System; Relational Database Model; The DB2 Database; Database Terminology; The Importance of Database Design; Database Development Process; Database Planning; Requirements Analysis; Database Design; DBMS Selection; Database Implementation; Testing and Evaluation; Database Maintenance; Operation; End-of-Chapter; Chapter Summary 327 $aKey Terms Chapter 2: Conceptual Design Using ER Diagrams; Introduction to Database Design; Developing Entity Relationship Diagrams; ERD Case Study; Step 1: Identify Entities; Step 2: Identify Attributes; Step 3: Identify Unique Identifier (UID); Step 4: Determine Relationships; Step 5: Determine Optionality and Cardinality; Step 6: Eliminate Many-to-Many Relationships; Step 7: Named Relationships; Step 8: Determine Data Types; Recursive Relationship; Entity Subtypes; End-of-Chapter; Chapter Summary; Key Terms; Chapter 3: Normalization; Normalization; Normal Forms; Representing Database Tables 327 $aFunctional Dependency First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); Boyce-Codd Normal Form (BCNF); Fourth Normal Form (4NF); Practical Example; First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); End-of-Chapter; Chapter Summary; Key Terms; Chapter 4: Physical Database Design: Creating Tables; Physical Database Design; Transforming Conceptual Design To Physical Design; Primary, Candidate, and Foreign Keys; Specify View Implementation; Specify Security Implementation; Specifying Additional Indexes for Performance; Hierarchy of Data; Variables 327 $aDatabase, Tables, Rows, and Columns Internal Binary Representation of Data; Data Types; Character Data Type; Numeric Data Types; Simulating a Boolean Data Type; Date Format; Timestamp Fields; Sample Data from a Table; Introduction to SQL; Running SQL Commands; Editor Pane; SQL Results Pane; Creating a Schema; Changing the Default Schema; Creating a Table; CREATE TABLE Command; Verify Syntax of SQL Script; Run SQL Script; Constraints; Qualified Names; Comments; NULL Values; Default Values; VARCHAR Data Type; ALTER Table Command; DROP (Delete) Table Command; Saving SQL Scripts; Edit SQL Scripts 327 $aAdding Data to a Table The INSERT Command; Displaying Data in a Table; Display Table Description Information; Rename a Database Object; End-of-Chapter; Chapter Summary; Key Terms; Chapter 5: Database Constraints; Introduction to Constraints; Data Integrity; Entity Integrity; Referential Integrity; Constraint Types; Primary Key Constraints; Unique Constraints; Foreign Key Constraints; Defining Foreign Key Constraints; Foreign Key Actions; Additional Foreign Key Constraint Considerations; Avoid Foreign Key Constraints for Read-Only Tables; Check Constraints; Check Constraint Guidelines 327 $aDefining Check Constraints 330 $aThorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instruction or self-study, this book explains the most widely used database language and the way that language is implemented on a variety of computer platforms. Topics covered include database concepts, SQL inquiries, web applications, and database security, and the material is reinforced by numerous illustrations, examples, and exercises. 606 $aDatabase design 606 $aSQL (Computer program language) 608 $aElectronic books. 615 0$aDatabase design. 615 0$aSQL (Computer program language) 676 $a005.75/6 700 $aCooper$b James$0116741 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910462898103321 996 $aDatabase design and SQL for DB2$92137587 997 $aUNINA LEADER 02961oam 2200589I 450 001 9910502683103321 005 20241204164427.0 010 $a0-367-23775-X 010 $a0-367-80663-0 010 $a1-4200-5700-6 035 $a(CKB)3400000000002021 035 $a(SSID)ssj0000477597 035 $a(PQKBManifestationID)11913397 035 $a(PQKBTitleCode)TC0000477597 035 $a(PQKBWorkID)10503097 035 $a(PQKB)10014798 035 $a(OCoLC)1107880627 035 $a(OCoLC-P)1107880627 035 $a(FlBoTFG)9780367806637 035 $a(MiAaPQ)EBC6721316 035 $a(Au-PeEL)EBL6721316 035 $a(OCoLC)1267761534 035 $a(oapen)https://directory.doabooks.org/handle/20.500.12854/72200 035 $a(oapen)doab72200 035 $a(EXLCZ)993400000000002021 100 $a20190711d2004 uy 0 101 0 $aeng 135 $aurcnu|||unuuu 181 $ctxt 182 $cc 183 $acr 200 10$aCosmology in gauge field theory and string theory /$fD. Bailin and A. Love 210 $cTaylor & Francis$d2004 210 1$aBoca Raton :$cCRC Press,$d2004. 215 $a1 online resource 225 0 $aGraduate student series in physics Cosmology in gauge field theory and string theory 300 $aBibliographic Level Mode of Issuance: Monograph 311 08$a1-138-45656-X 311 08$a0-7503-0492-8 320 $aIncludes bibliographical references and index. 330 $aCosmology in Gauge Field Theory and String Theory focuses on the cosmological implications of the gauge theories of particle physics and of string theory. The book first examines the universe's series of phase transitions in which the successive gauge symmetries of the higher-temperature phase were spontaneously broken after the big bang, discussing relics of these phase transitions, more generic relics (baryons, neutrinos, axions), and supersymmetric particles (neutralinos and gravitinos). The author next studies supersymmetric theory, supergravity theory, and the constraints on the underlying field theory of the universe's inflationary era. The book concludes with a discussion of black hole solutions of the supergravity theory that approximates string theory at low energies and the insight that string theory affords into the microscopic origin of the Bekenstein-Hawking entropy.Cosmology in Gauge Field Theory and String Theory provides a modern introduction to these important problems from a particle physicist's perspective. It is intended as an introductory textbook for a first course on the subject at a graduate level. 606 $aGauge fields (Physics) 615 0$aGauge fields (Physics) 676 $a530.1435 700 $aBailin$b David$044542 702 $aLove$b Alexander 801 0$bOCoLC-P 801 1$bOCoLC-P 906 $aBOOK 912 $a9910502683103321 996 $aCosmology in gauge field theory and string theory$92250486 997 $aUNINA