Database concepts:
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Boston [u.a.]
Pearson
2010
|
| Ausgabe: | 4. ed., internat. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | 477 S. Ill., graph. Darst. |
| ISBN: | 9780137016167 0137016166 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV035474721 | ||
| 003 | DE-604 | ||
| 005 | 20090527 | ||
| 007 | t | ||
| 008 | 090507s2010 xxuad|| |||| 00||| eng d | ||
| 020 | |a 9780137016167 |c pbk |9 978-0-13-701616-7 | ||
| 020 | |a 0137016166 |c pbk |9 0-13-701616-6 | ||
| 035 | |a (OCoLC)438639526 | ||
| 035 | |a (DE-599)GBV583918247 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-29T | ||
| 050 | 0 | |a QA76.9.D3 | |
| 080 | |a 004.6 | ||
| 082 | 0 | |a 005.74 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a Kroenke, David M. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database concepts |c David M. Kroenke ; David J. Auer |
| 250 | |a 4. ed., internat. ed. | ||
| 264 | 1 | |a Boston [u.a.] |b Pearson |c 2010 | |
| 300 | |a 477 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Relational databases | |
| 650 | 0 | 7 | |a Datenbankentwurf |0 (DE-588)4127613-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Relationale Datenbank |0 (DE-588)4049358-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Relationale Datenbank |0 (DE-588)4049358-1 |D s |
| 689 | 0 | 1 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 0 | 2 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 700 | 1 | |a Auer, David J. |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m Digitalisierung UB Bamberg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017394362&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-017394362 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Datensatz im Suchindex
| _version_ | 1804138935608147968 |
|---|---|
| adam_text | Brief Contents
PARTI DATABASE
FUNDAMENTALS
21
1
Getting Started
23
2
The Relational Model
75
3
Structured Query Language
125
ЗА
SQL Views
219
PART II DATABASE DESIGN
237
4
Data Modeling and the Entity-Relationship Model
239
5
Database Design
277
PART III DATABASE MANAGEMENT
313
6
Database Administration
315
7
Database Processing Applications
375
8
Database Processing for Business Intelligence Systems
421
Glossary
467
Index
473
ONLINE APPENDIGES: SEE PAGE
465
FOR INSTRUCTIONS
Appendix A The Access Workbench
—
Section A
—
Getting Started with the Microsoft
Access
2007
Office Fluent User Interface
Appendix
В
Getting Started with Microsoft SQL Server Express Edition
Appendix
С
Getting Started with Sun Microsystems MySQL
Appendix
D
The Access Workbench
—
Section
D
—
Microsoft Access
2003
User-Level
Database Security in Access
2007
Contents
PARTI DATABASE FUNDAMENTALS
21
1
Getting Started
23
Why Use a Database?
24
What Is a Database System?
33
The Access Workbench Section
1—
Getting Started with Microsoft Access
39
Summary
68
Key Terms
69
Review Questions
69
Exercises
71
Access Workbench Key Terms
71
Access Workbench Exercises
72
Garden Glory Project Questions
73
James River Jewelry Project Questions
73
The Queen Anne Curiosity Shop Project Questions
74
2
TheRelationalModel
75
Relations
76
Types of Keys
79
The Problem of Null Values
85
Functional Dependencies and Normalization
87
The Access Workbench Section
2—
Working with Multiple Tables in Microsoft
Access
98
Summary
113
Key Terms
114
Review Questions
114
Exercises
116
Access Workbench Key Terms
117
Access Workbench Exercises
117
Garden Glory Project Questions
120
James River Jewelry Project Questions
122
The Queen Anne Curiosity Shop Project Questions
123
8
Contents
3
Structured Query Language
125
An Example Database
126
SQL for Data Definition
130
SQL for Inserting Relational Data
141
SQL for Relational Queries
143
SQL for Relational Data Modification and Deletion
170
SQL for Table and Constraint Modification and Deletion
173
SQL Views
174
The Access Workbench Section
3—
Working with Queries in Microsoft
Access
175
Summary
202
Key Terms
203
Review Questions
204
Exercises
208
Access Workbench Key Terms
209
Access Workbench Exercises
209
Garden Glory Project Questions
213
James River Jewelry Project Questions
215
The Queen Anne Curiosity Shop Project Questions
216
ЗА
SQL Views
219
Creating SQL Views
220
Using SQL Views
223
The Access Workbench Section
3Ä—
Working with Views in Microsoft
Access
228
Summary
232
Key Terms
232
Review Questions
232
Exercises
233
Access Workbench Key Terms
233
Access Workbench Exercises
234
Garden Glory Project Questions
235
James River Jewelry Project Questions
235
The Queen Anne Curiosity Shop Project Questions
236
PARTII
DATABASE DESIGN
237
4
Data Modeling and the Entity-Relationship Model
239
The Requirements Stage
240
The Entity-Relationship Data Model
241
Contents 9
Entity-Relationship Diagrams
245
Developing an Example
Е
-R
Diagram
253
The Access Workbench Section
4—
Prototyping Using Microsoft Access
263
Summary
271
Key Terms
272
Review Questions
272
Exercises
273
Access Workbench Key Terms
274
Access Workbench Exercises
274
Garden Glory Project Questions
275
James River Jewelry Project Questions
275
The Queen Anne Curiosity Shop Project Questions
276
Database Design
277
Transforming a Data Model into a Database Design
278
Representing Entities with the Relational Model
278
Representing Relationships
287
Database Design at Heather Sweeney Designs
298
The Access Workbench Section
5—
Relationships in Microsoft Access
302
Summary
307
Key Terms
308
Review Questions
308
Exercises
310
Access Workbench Key Terms
310
Access Workbench Exercises
311
Garden Glory Project Questions
311
James River Jewelry Project Questions
312
The Queen Anne Curiosity Shop Project Questions
312
PARTIU
DATABASE
MANAGEMENT 313
6
Database Administration
315
The Heather Sweeney Designs Database
316
The Need for Control, Security, and Reliability
316
Concurrency Control
322
Cursor Types
331
Database Security
332
Database Backup and Recovery
339
Additional DBA Responsibilities
342
Distributed Database Processing
343
10
Contents
Object-Relational Databases
345
The Access Workbench Section
6—
Database Administration
in Microsoft Access
345
Summary
366
Key Terms
367
Review Questions
368
Exercises
370
Access Workbench Key Terms
370
Access Workbench Exercises
371
Garden Glory Project Questions
371
James River Jewelry Project Questions
372
The Queen Anne Curiosity Shop Project Questions
374
7
Database Processing Applications
375
The Database Processing Environment
376
Web Database Processing
379
Database Processing and XML
397
The Access Workbench Section
7—
Web Database Processing
Using Microsoft Access
405
Summary
413
Key Terms
414
Review Questions
415
Exercises
416
Access Workbench Exercises
418
Garden Glory Project Questions
419
James River Jewelry Project Questions
419
The Queen Anne Curiosity Shop Project Questions
420
8
Database Processing for Business Intelligence Systems
421
Business Intelligence Systems
423
The Relationship Between Operational and Bl Systems
424
Reporting Systems and Data Mining Applications
424
Data Warehouses and Data Marts
425
Reporting Systems
434
Data Mining
440
The Access Workbench Section
8—
Business Intelligence Systems
Using Microsoft Access
444
Summary
457
Key Terms
458
Review Questions
458
Exercises
460
Contents
11
Access
Workbench
Exercises
462
Garden Glory
Project Questions
462
James River
Jewelry
Project Questions
463
The
Queen
Anne
Curiosity Shop
Project Questions
464
Glossary
467
Index
473
ONLINE APPENDICES:
SEE PAGE
465
FOR INSTRUCTIONS
Appendix
A; The Access
Workbench
—
Section A
—
Getting Started with the Microsoft Access
2007
Office Fluent User Interface
Appendix B: Getting Started with Microsoft SQL Server
Express Edition
Appendix C: Getting Started with Sun Microsystems
MySQL
Appendix D: The Access Workbench
—
Section
D
—
Microsoft Access
2003
User-Level Database
Security in Access
2007
|
| any_adam_object | 1 |
| author | Kroenke, David M. Auer, David J. |
| author_facet | Kroenke, David M. Auer, David J. |
| author_role | aut aut |
| author_sort | Kroenke, David M. |
| author_variant | d m k dm dmk d j a dj dja |
| building | Verbundindex |
| bvnumber | BV035474721 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)438639526 (DE-599)GBV583918247 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 4. ed., internat. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01811nam a2200481zc 4500</leader><controlfield tag="001">BV035474721</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20090527 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">090507s2010 xxuad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780137016167</subfield><subfield code="c">pbk</subfield><subfield code="9">978-0-13-701616-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0137016166</subfield><subfield code="c">pbk</subfield><subfield code="9">0-13-701616-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)438639526</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV583918247</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-29T</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="080" ind1=" " ind2=" "><subfield code="a">004.6</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kroenke, David M.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database concepts</subfield><subfield code="c">David M. Kroenke ; David J. Auer</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">4. ed., internat. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boston [u.a.]</subfield><subfield code="b">Pearson</subfield><subfield code="c">2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">477 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Relationale Datenbank</subfield><subfield code="0">(DE-588)4049358-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Relationale Datenbank</subfield><subfield code="0">(DE-588)4049358-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Auer, David J.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017394362&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-017394362</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection> |
| id | DE-604.BV035474721 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T21:36:06Z |
| institution | BVB |
| isbn | 9780137016167 0137016166 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-017394362 |
| oclc_num | 438639526 |
| open_access_boolean | |
| owner | DE-29T |
| owner_facet | DE-29T |
| physical | 477 S. Ill., graph. Darst. |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | Pearson |
| record_format | marc |
| spelling | Kroenke, David M. Verfasser aut Database concepts David M. Kroenke ; David J. Auer 4. ed., internat. ed. Boston [u.a.] Pearson 2010 477 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Database management Relational databases Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf Relationale Datenbank (DE-588)4049358-1 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf Relationale Datenbank (DE-588)4049358-1 s Datenbankentwurf (DE-588)4127613-9 s Datenbankverwaltung (DE-588)4389357-0 s 1\p DE-604 Auer, David J. Verfasser aut Digitalisierung UB Bamberg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017394362&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Kroenke, David M. Auer, David J. Database concepts Database management Relational databases Datenbankentwurf (DE-588)4127613-9 gnd Relationale Datenbank (DE-588)4049358-1 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| subject_GND | (DE-588)4127613-9 (DE-588)4049358-1 (DE-588)4389357-0 |
| title | Database concepts |
| title_auth | Database concepts |
| title_exact_search | Database concepts |
| title_full | Database concepts David M. Kroenke ; David J. Auer |
| title_fullStr | Database concepts David M. Kroenke ; David J. Auer |
| title_full_unstemmed | Database concepts David M. Kroenke ; David J. Auer |
| title_short | Database concepts |
| title_sort | database concepts |
| topic | Database management Relational databases Datenbankentwurf (DE-588)4127613-9 gnd Relationale Datenbank (DE-588)4049358-1 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| topic_facet | Database management Relational databases Datenbankentwurf Relationale Datenbank Datenbankverwaltung |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=017394362&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT kroenkedavidm databaseconcepts AT auerdavidj databaseconcepts |