Cargando…
Database Design and SQL for DB2.
Thorough 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 lang...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Chicago :
MC Press,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn833765288 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr un||||||||| | ||
| 008 | 130330s2013 ilu o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d OCLCQ |d VALIL |d YDXCP |d VALIL |d N$T |d OCLCQ |d OCLCO |d OCLCQ |d IDEBK |d MEAUC |d OCLCQ |d DEBSZ |d OCLCQ |d OCLCF |d TEFOD |d E7B |d OCLCQ |d TEFOD |d OCLCQ |d LVT |d COCUF |d CNNOR |d MOR |d MERUC |d OCLCQ |d ZCU |d OCLCO |d U3W |d D6H |d STF |d WRM |d ICG |d INT |d VT2 |d OCLCQ |d OCLCO |d WYU |d OCLCQ |d OCLCO |d A6Q |d DKC |d OCLCQ |d OCLCO |d UKCRE |d VLY |d UKAHL |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 846986192 |a 972080682 |a 988444860 |a 1029505256 |a 1037708314 |a 1038589899 |a 1055333696 |a 1081240231 |a 1083597632 |a 1153495717 |a 1162072915 | ||
| 020 | |a 9781583477199 |q (electronic bk.) | ||
| 020 | |a 1583477195 |q (electronic bk.) | ||
| 020 | |a 9781583477472 |q (electronic bk.) | ||
| 020 | |a 1583477470 |q (electronic bk.) | ||
| 020 | |a 1583473572 | ||
| 020 | |a 9781583473573 | ||
| 020 | |z 9781583473573 | ||
| 029 | 1 | |a AU@ |b 000055882876 | |
| 029 | 1 | |a CHNEW |b 000610656 | |
| 029 | 1 | |a CHNEW |b 001051455 | |
| 029 | 1 | |a CHVBK |b 567702758 | |
| 029 | 1 | |a DEBBG |b BV044189104 | |
| 029 | 1 | |a DEBSZ |b 397511868 | |
| 035 | |a (OCoLC)833765288 |z (OCoLC)846986192 |z (OCoLC)972080682 |z (OCoLC)988444860 |z (OCoLC)1029505256 |z (OCoLC)1037708314 |z (OCoLC)1038589899 |z (OCoLC)1055333696 |z (OCoLC)1081240231 |z (OCoLC)1083597632 |z (OCoLC)1153495717 |z (OCoLC)1162072915 | ||
| 037 | |a FF1D6E03-2A9D-4F62-94A5-2E17958554EF |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.73 .S67 | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.75/6 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Cooper, James. | |
| 245 | 1 | 0 | |a Database Design and SQL for DB2. |
| 260 | |a Chicago : |b MC Press, |c 2013. | ||
| 300 | |a 1 online resource (505 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 500 | |a Defining Check Constraints. | ||
| 520 | |a Thorough 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. | ||
| 505 | 0 | |a Cover; 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. | |
| 505 | 8 | |a Key TermsChapter 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. | |
| 505 | 8 | |a Functional DependencyFirst 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. | |
| 505 | 8 | |a Database, Tables, Rows, and ColumnsInternal 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. | |
| 505 | 8 | |a Adding Data to a TableThe 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. | |
| 588 | 0 | |a Print version record. | |
| 546 | |a English. | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a SQL server. |
| 630 | 0 | 7 | |a SQL server |2 fast |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Database design. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données |x Conception. | |
| 650 | 7 | |a COMPUTERS |x General. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Database design |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Cooper, James. |t Database Design and SQL for DB2. |d Chicago : MC Press, ©2013 |z 9781583473573 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1158870 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH25480540 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1158870 | ||
| 938 | |a ebrary |b EBRY |n ebr10679030 | ||
| 938 | |a EBSCOhost |b EBSC |n 562574 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis26536519 | ||
| 938 | |a YBP Library Services |b YANK |n 10391282 | ||
| 994 | |a 92 |b IZTAP | ||