Database concepts / (Record no. 6890)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 07192cam a22001934a 4500 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| ISBN | 0130086509 |
| Terms of availability | TZS 40,162.5 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | MUL |
| Language of cataloging | eng |
| Description conventions | AACR |
| 082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.74 KRO |
| 100 1# - MAIN ENTRY--AUTHOR NAME | |
| Personal name | Kroenke, David M., |
| 245 10 - TITLE STATEMENT | |
| Title | Database concepts / |
| Statement of responsibility, etc | David M. Kroenke. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication | Upper Saddle River, NJ : |
| Name of publisher | Prentice Hall, |
| Year of publication | c2003. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Number of Pages | xvi, 219 p. : |
| Other physical details | ill. ; |
| Dimensions | 28 cm. |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc | Includes bibliographical references and index. |
| 505 ## - Formatted Contents | |
| Formatted contents note | <br/>Preface xiii <br/>PART 1 DATABASE FUNDAMENTALS 1 (84)<br/>Getting Started<br/>2 (28)<br/>Chapter Objectives<br/>2 (1)<br/>Why Use a Database?<br/>3 (13)<br/>Relational Databases<br/>5 (2)<br/>Representing Relationships<br/>7 (1)<br/>The Parts List Example<br/>8 (8)<br/>What Is a Database System?<br/>16 (6)<br/>Functions of an Application Program<br/>17 (1)<br/>Functions of a DBMS<br/>18 (1)<br/>Definition and Components of a Database<br/>19 (2)<br/>Desktop Versus Organizational Database Systems<br/>21 (1)<br/>How to Build a Database System<br/>22 (2)<br/>Building a Data Model<br/>22 (1)<br/>Creating a Database Design<br/>23 (1)<br/>Implementing a Database<br/>24 (1)<br/>Summary<br/>24 (2)<br/>Review Questions<br/>26 (1)<br/>Exercises<br/>27 (1)<br/>Garden Glory Project Questions<br/>28 (1)<br/>James River Jewelry Project Questions<br/>28 (2)<br/>The Relational Model<br/>30 (24)<br/>Chapter Objectives<br/>30 (1)<br/>Relations<br/>31 (2)<br/>A Sample Relation and Two Nonrelations<br/>31 (1)<br/>A Note on Terminology<br/>32 (1)<br/>Types of Keys<br/>33 (8)<br/>Composite Keys<br/>34 (1)<br/>Primary and Candidate Keys<br/>34 (1)<br/>Foreign Keys and Referential Integrity<br/>34 (4)<br/>Surrogate Keys<br/>38 (3)<br/>Functional Dependencies and Normalization<br/>41 (6)<br/>Functional Dependencies<br/>41 (1)<br/>Primary and Candidate Keys Revisited<br/>42 (1)<br/>Normalization<br/>43 (1)<br/>Relational Design Principles<br/>44 (1)<br/>Normalization Examples<br/>44 (3)<br/>The Problem of Null Values<br/>47 (1)<br/>Summary<br/>48 (1)<br/>Review Questions<br/>49 (1)<br/>Exercises<br/>50 (1)<br/>Garden Glory Project Questions<br/>51 (1)<br/>James River Jewelry Project Questions<br/>52 (2)<br/>Structured Query Language<br/>54 (31)<br/>Chapter Objectives<br/>54 (1)<br/>A Sample Database<br/>55 (2)<br/>SQL for Data Definition<br/>57 (4)<br/>Defining Primary Keys with the ALTER TABLE Statement<br/>59 (1)<br/>Defining Foreign Keys with the ALTER TABLE Statement<br/>59 (1)<br/>Submitting SQL to the DBMS<br/>59 (1)<br/>DROP Statements<br/>60 (1)<br/>SQL for Relational Query<br/>61 (14)<br/>Reading Specified Columns from a Single Table<br/>62 (1)<br/>Reading Specified Rows from a Single Table<br/>62 (2)<br/>Reading Specified Columns and Specified Rows from a Single Table<br/>64 (1)<br/>Ranges, Wildcards, and Nulls in WHERE Clauses<br/>65 (1)<br/>Sorting the Results<br/>66 (1)<br/>SQL Built-In Functions<br/>67 (2)<br/>Built-In Functions and Groupings<br/>69 (1)<br/>Querying Multiple Tables with Subqueries<br/>70 (1)<br/>Querying Multiple Tables with Joins<br/>71 (3)<br/>Outer Joins<br/>74 (1)<br/>SQL for Relational Data Modification<br/>75 (3)<br/>Inserting Data<br/>75 (1)<br/>Modifying Data<br/>76 (1)<br/>Deleting Data<br/>77 (1)<br/>Summary<br/>78 (1)<br/>Review Questions<br/>79 (2)<br/>Exercises<br/>81 (1)<br/>Garden Glory Project Questions<br/>81 (1)<br/>James River Jewelry Project Questions<br/>82 (3)<br/>PART 2 DATABASE DESIGN AND MANAGEMENT 85 (80)<br/>Data Modeling and the Entity-Relationship Model<br/>86 (24)<br/>Chapter Objectives<br/>86 (1)<br/>The Requirements Stage<br/>87 (1)<br/>The Entity-Relationship Data Model<br/>88 (6)<br/>Entities<br/>88 (1)<br/>Attributes<br/>89 (1)<br/>Identifiers<br/>89 (1)<br/>Relationships<br/>90 (1)<br/>Three Types of Binary Relationships<br/>90 (1)<br/>Recursive Relationships<br/>91 (1)<br/>Entity-Relationship Diagrams<br/>92 (1)<br/>Weak Entities<br/>92 (2)<br/>Unified Modeling Language Entity-Relationship Diagrams<br/>94 (2)<br/>UML Entities and Relationships<br/>94 (1)<br/>UML Representation of Weak Entities<br/>95 (1)<br/>An Example<br/>96 (10)<br/>Heather Sweeney Designs<br/>96 (1)<br/>The Seminar Customer List<br/>97 (1)<br/>The Customer Form Letter<br/>98 (3)<br/>The Sales Invoice<br/>101 (2)<br/>Attribute Specifications<br/>103 (1)<br/>Business Rules<br/>103 (1)<br/>Validating the Data Model<br/>104 (2)<br/>Summary<br/>106 (1)<br/>Review Questions<br/>107 (1)<br/>Exercises<br/>108 (1)<br/>Garden Glory Project Questions<br/>108 (1)<br/>James River Jewelry Project Questions<br/>109 (1)<br/>Database Design<br/>110 (25)<br/>Chapter Objectives<br/>110 (1)<br/>Representing Entities with the Relational Model<br/>111 (6)<br/>Normalization, Second Verse<br/>112 (1)<br/>Normal Forms<br/>113 (1)<br/>Domain/Key Normal Form<br/>113 (1)<br/>Using Normalization Criteria<br/>114 (1)<br/>Denormalization<br/>115 (1)<br/>Representing Weak Entities<br/>115 (2)<br/>Representing Relationships<br/>117 (10)<br/>Representing One-to-One Relationships<br/>117 (2)<br/>Questionable One-to-One Relationships<br/>119 (1)<br/>Representing One-to-Many Relationships<br/>119 (2)<br/>Representing Many-to-Many Relationships<br/>121 (2)<br/>Representing Recursive Relationships<br/>123 (4)<br/>Database Design at Heather Sweeney Designs<br/>127 (4)<br/>Weak Entities<br/>128 (1)<br/>Relationships<br/>128 (1)<br/>Enforcing Referential Integrity<br/>129 (2)<br/>Summary<br/>131 (1)<br/>Review Questions<br/>131 (2)<br/>Exercises<br/>133 (1)<br/>Garden Glory Project Questions<br/>133 (1)<br/>James River Jewelry Project Questions<br/>134 (1)<br/>Database Administration<br/>135 (30)<br/>Chapter Objectives<br/>135 (1)<br/>The Database Processing Environment<br/>136 (4)<br/>Queries, Forms, and Reports<br/>136 (1)<br/>Internet Application Processing<br/>137 (1)<br/>Client/Server and Traditional Application Processing<br/>138 (1)<br/>Stored Procedures and Triggers<br/>138 (1)<br/>The Need for Control, Security and Reliability<br/>139 (1)<br/>Concurrency Control<br/>140 (10)<br/>The Need for Atomic Transactions<br/>140 (1)<br/>Concurrent Transaction Processing<br/>141 (2)<br/>The Lost Update Problem<br/>143 (1)<br/>Concurrency Problems: Dirty Reads, Inconsistent Reads, Phantom Reads<br/>143 (1)<br/>Resource Locking<br/>144 (1)<br/>Lock Terminology<br/>144 (1)<br/>Serializable Transactions<br/>145 (1)<br/>Deadlock<br/>145 (1)<br/>Optimistic Versus Pessimistic Locking<br/>146 (1)<br/>Declaring Lock Characteristics<br/>147 (1)<br/>Consistent Transactions<br/>148 (1)<br/>Transaction Isolation Level<br/>149 (1)<br/>Database Security<br/>150 (3)<br/>Processing Rights and Responsibilities<br/>150 (1)<br/>DBMS Security<br/>151 (1)<br/>Application Security<br/>152 (1)<br/>Database Backup and Recovery<br/>153 (4)<br/>Recovery via Reprocessing<br/>153 (1)<br/>Recovery via Rollback and Rollforward<br/>154 (3)<br/>Additional DBA Responsibilities<br/>157 (1)<br/>Summary<br/>158 (1)<br/>Review Questions<br/>159 (2)<br/>Exercises<br/>161 (1)<br/>Garden Glory Project Questions<br/>162 (1)<br/>James River Jewelry Project Questions<br/>163 (2)<br/>Appendix Database Processing with Microsoft Access 165 (40)<br/>Appendix Objectives<br/>165 (1)<br/>Database Schema for Carbon River Construction<br/>166 (2)<br/>Carbon River Schema Data Structure Diagram<br/>167 (1)<br/>Column Design<br/>167 (1)<br/>Creating Tables and Relationships Using Access<br/>168 (7)<br/>Creating Tables<br/>170 (1)<br/>Creating Relationships<br/>171 (4)<br/>Creating Queries and SQL Statements<br/>175 (6)<br/>Creating Simple Queries with the Graphical Tool<br/>175 (5)<br/>Action Queries<br/>180 (1)<br/>Creating Access Data Entry Forms<br/>181 (9)<br/>Creating a Simple Form<br/>181 (2)<br/>Using Default Values and Combo Boxes with Forms<br/>183 (5)<br/>Looking Up Nonkey Data<br/>188 (2)<br/>Creating Access Reports<br/>190 (7)<br/>Banded Report Writers<br/>190 (2)<br/>Computations in Reports<br/>192 (1)<br/>Parameterized Reports<br/>193 (4)<br/>Summary<br/>197 (1)<br/>Review Questions<br/>198 (2)<br/>Exercises<br/>200 (1)<br/>Garden Glory Project Questions<br/>201 (1)<br/>James River Jewelry Project Questions<br/>202 (3)<br/>Glossary 205 (9)<br/>Index 214 |
| 546 ## - LANGUAGE NOTE | |
| Language note | eng |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | Database management. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical Term | Relational databases. |
| 942 ## - ADDED ENTRY ELEMENTS | |
| Item type | Book |
| Withdrawn status | Lost status | Damaged status | Not for loan | Permanent Location | Current Location | Date acquired | Source of acquisition | Full call number | Accession Number | Copy number | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mzumbe University Main Campus Library | Mzumbe University Main Campus Library | 03/03/2015 | FST MU | 005.74 KRO | 0079356 | 1 | 12/12/2022 | Book |