Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Database design and SQL for DB2 [[electronic resource] /] / James Cooper
| Database design and SQL for DB2 [[electronic resource] /] / James Cooper |
| Autore | Cooper James |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Boise, ID, : MC Press, c2013 |
| Descrizione fisica | 1 online resource (505 p.) |
| Disciplina | 005.75/6 |
| Soggetto topico |
Database design
SQL (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-58347-719-5 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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
Key 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 Functional 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 Database, 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 Adding 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 Defining Check Constraints |
| Record Nr. | UNINA-9910462898103321 |
Cooper James
|
||
| Boise, ID, : MC Press, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database design and SQL for DB2 [[electronic resource] /] / James Cooper
| Database design and SQL for DB2 [[electronic resource] /] / James Cooper |
| Autore | Cooper James |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Boise, ID, : MC Press, c2013 |
| Descrizione fisica | 1 online resource (505 p.) |
| Disciplina | 005.75/6 |
| Soggetto topico |
Database design
SQL (Computer program language) |
| ISBN | 1-58347-719-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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
Key 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 Functional 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 Database, 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 Adding 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 Defining Check Constraints |
| Record Nr. | UNINA-9910786222603321 |
|
Cooper James
|
||
| Boise, ID, : MC Press, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database design and SQL for DB2 / / James Cooper
| Database design and SQL for DB2 / / James Cooper |
| Autore | Cooper James |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Boise, ID, : MC Press, c2013 |
| Descrizione fisica | 1 online resource (505 p.) |
| Disciplina | 005.75/6 |
| Soggetto topico |
Database design
SQL (Computer program language) |
| ISBN | 1-58347-719-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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
Key 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 Functional 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 Database, 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 Adding 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 Defining Check Constraints |
| Record Nr. | UNINA-9910827799703321 |
|
Cooper James
|
||
| Boise, ID, : MC Press, c2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
A diplomatic meeting : Reagan, Thatcher, and the art of summitry / / James Cooper [[electronic resource]]
| A diplomatic meeting : Reagan, Thatcher, and the art of summitry / / James Cooper [[electronic resource]] |
| Autore | Cooper James |
| Pubbl/distr/stampa | Lexington : , : University Press of Kentucky, , [2021] |
| Descrizione fisica | 1 online resource , 1 online resource |
| Disciplina | 658.456 |
| Collana |
Studies in conflict, diplomacy, and peace
Kentucky scholarship online |
| Soggetto topico |
Presidents - United States - Professional relationships
Prime ministers - Great Britain - Professional relationships Summit meetings - History - 20th century |
| ISBN | 0-8131-5437-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Before Power, 1969-1981 -- A Political "Special Relationship," 1981 -- Conflicts at Home and Abroad, 1982 -- Reelections, 1983-1984. |
| Record Nr. | UNINA-9910795602503321 |
|
Cooper James
|
||
| Lexington : , : University Press of Kentucky, , [2021] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
A diplomatic meeting : Reagan, Thatcher, and the art of summitry / / James Cooper [[electronic resource]]
| A diplomatic meeting : Reagan, Thatcher, and the art of summitry / / James Cooper [[electronic resource]] |
| Autore | Cooper James |
| Pubbl/distr/stampa | Lexington : , : University Press of Kentucky, , [2021] |
| Descrizione fisica | 1 online resource , 1 online resource |
| Disciplina | 658.456 |
| Collana |
Studies in conflict, diplomacy, and peace
Kentucky scholarship online |
| Soggetto topico |
Presidents - United States - Professional relationships
Prime ministers - Great Britain - Professional relationships Summit meetings - History - 20th century |
| ISBN | 0-8131-5437-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Before Power, 1969-1981 -- A Political "Special Relationship," 1981 -- Conflicts at Home and Abroad, 1982 -- Reelections, 1983-1984. |
| Record Nr. | UNINA-9910812802903321 |
|
Cooper James
|
||
| Lexington : , : University Press of Kentucky, , [2021] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Ronald Reagan’s 1984 : Politics, Policy, and Culture / / by James Cooper, R.J. Richardson, Bailey Schwab
| Ronald Reagan’s 1984 : Politics, Policy, and Culture / / by James Cooper, R.J. Richardson, Bailey Schwab |
| Autore | Cooper James |
| Edizione | [1st ed. 2024.] |
| Pubbl/distr/stampa | Cham : , : Springer Nature Switzerland : , : Imprint : Palgrave Macmillan, , 2024 |
| Descrizione fisica | 1 online resource (112 pages) |
| Disciplina |
973.927
970 |
| Altri autori (Persone) |
RichardsonR. J
SchwabBailey |
| Soggetto topico |
United States - History
World politics America - Politics and government International relations - History Civilization - History History, Modern US History Political History American Politics Diplomatic and International History Cultural History Modern History |
| ISBN | 3-031-53677-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Chapter 1: Introduction -- Chapter 2: 1984 -- Chapter 3: Conclusion. |
| Record Nr. | UNINA-9910842493103321 |
|
Cooper James
|
||
| Cham : , : Springer Nature Switzerland : , : Imprint : Palgrave Macmillan, , 2024 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||