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 01360nam a22002891i 4500 001 991002998469707536 005 20040621162644.0 008 040624s1989 gw |||||||||||||||||ger 020 $a3412099880 035 $ab13009254-39ule_inst 035 $aARCHE-096693$9ExL 040 $aDip.to Beni Culturali$bita$cA.t.i. Arché s.c.r.l. Pandora Sicilia s.r.l. 082 04$a340.538 111 2 $aGesellschaft für griechische und hellenistische rechtsgeschichte Symposion$n<6. ;$d1985 ;$cRingberg>$0487962 245 10$aSymposion 1985 :$bvorträge zur griechischen und hellenistischen Rechtsgeschichte : Ringberg, 24-26 Juli 1985 /$cherausgegeben von Gerhard Thur 260 $aKöln ;$aWien :$bBöhlau,$c1989 300 $aXII, 468 p., 2 p. di tav. ;$c24 cm 440 0$aAkten der Gesellschaft für griechische und hellenistische Rechtsgeschichte ;$v6 650 4$aDiritto$zGrecia antica$xCongressi$y1985 700 1 $aThür, Gerhard 907 $a.b13009254$b02-04-14$c12-07-04 912 $a991002998469707536 945 $aLE001 AN XXI 455a$g1$i2001000076567$lle001$nC. 1$o-$pE0.00$q-$rl$s- $t0$u0$v0$w0$x0$y.i13620289$z12-07-04 945 $aLE016$g1$lle016$nFondo Nenci$on$pE7.00$q-$rn$so $t0$u0$v0$w0$x0$y.i14422992$z06-04-07 996 $aSymposion 1985$9282429 997 $aUNISALENTO 998 $ale001$ale016$b12-07-04$cm$da $e-$fger$ggw $h0$i1