Database development / (Record no. 940)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 12548nam a22003497a 4500 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | OSt |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20231024054628.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 210324b ||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0536173001 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | CvSU-CCAT Campus Library. |
| Language of cataloging | English |
| Transcribing agency | CvSU-CCAT Campus Library. |
| Description conventions | rda. |
| 050 ## - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | CIR QA 76.9.D3 |
| Item number | F76 2006 |
| 100 ## - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Frost, Raymond, author. |
| 9 (RLIN) | 7899 |
| 245 ## - TITLE STATEMENT | |
| Title | Database development / |
| Statement of responsibility, etc. | Raymond Frost, John Day, Craig Van Slyke. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. | |
| Place of publication, distribution, etc. | Upper Saddle River, New Jersey : |
| Name of publisher, distributor, etc. | Pearson Prentice Hall, |
| Date of publication, distribution, etc. | c2006. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xviii, 508 pages : |
| Other physical details | illustrations ; |
| Dimensions | 28 cm |
| 500 ## - GENERAL NOTE | |
| General note | Taken from: Database Design and Development; A visual approach -- T.p.<br/> |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc. note | Includes index. |
| 505 ## - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Preface xv <br/>The Role of Databases in Electronic Business<br/>1 (14)<br/>Learning Objectives<br/>1 (1)<br/>Introduction<br/>1 (1)<br/>Components of an Organizational System<br/>2 (6)<br/>Network<br/>2 (1)<br/>Hardware<br/>2 (2)<br/>Software<br/>4 (1)<br/>Content<br/>5 (3)<br/>What Is a Database?<br/>8 <br/>Why Are Databases Important to Business?<br/>7 (3)<br/>General Business Example<br/>7 (1)<br/>E-business Example<br/>8 (2)<br/>Organization of the Text<br/>10 (1)<br/>Summary<br/>11 (1)<br/>Key Terms<br/>11 (1)<br/>Exercises<br/>12 (3)<br/>Review<br/>12 (1)<br/>Discuss<br/>12 (1)<br/>Practice<br/>12 (3)<br/>Relational Theory<br/>15 (14)<br/>Learning Objectives<br/>15 (1)<br/>Introduction<br/>15 (1)<br/>Relational Model<br/>16 (1)<br/>Relational Database Management System (RDBMS)<br/>16 (1)<br/>Database Administrator (DBA)<br/>16 (1)<br/>Entity Relationship Diagrams<br/>16 (6)<br/>Primary Keys<br/>18 (2)<br/>Creating Relationships: Foreign Keys<br/>20 (1)<br/>Data Integrity<br/>21 (1)<br/>First Normal Form<br/>22 (1)<br/>Types of Database Systems<br/>22 (3)<br/>Relational Advantages<br/>24 (1)<br/>Logical Rather Than Physical Links<br/>24 (1)<br/>Fourth-Generation Language (4GL)<br/>24 (1)<br/>Data Independence<br/>24 (1)<br/>Summary<br/>25 (1)<br/>Key Terms<br/>26 (1)<br/>Exercises<br/>27 (1)<br/>Review<br/>27 (1)<br/>Discuss<br/>27 (1)<br/>Practice<br/>27 (1)<br/>References<br/>27 (2)<br/>Conceptual Design<br/>29 (38)<br/>Learning Objectives<br/>29 (1)<br/>Introduction<br/>29 (2)<br/>Step 1: Represent Entities as Tables<br/>29 (1)<br/>Step 2: Determine Relationships<br/>30 (1)<br/>Step 3: List Fields<br/>30 (1)<br/>Step 4: Identify Keys<br/>30 (1)<br/>Step 5: Determining Data Types<br/>31 (1)<br/>Designing a Single-Table Database<br/>31 (2)<br/>Problem Statement<br/>31 (1)<br/>Process<br/>32 (1)<br/>Designing a Database with a One-to-Many Relationship<br/>33 (3)<br/>Problem Statement<br/>33 (1)<br/>Process<br/>33 (3)<br/>Database with Many-to-Many Relationships<br/>36 (6)<br/>Problem Statement<br/>36 (6)<br/>Other Multitable Database Examples<br/>42 (18)<br/>The Hospital Database<br/>43 (5)<br/>The ACME Database<br/>48 (5)<br/>The Amazon Database<br/>53 (7)<br/>Summary<br/>60 (1)<br/>Key Terms<br/>61 (1)<br/>Exercises<br/>61 (6)<br/>Review<br/>61 (1)<br/>Discuss<br/>62 (1)<br/>Practice<br/>62 (5)<br/>Normalization<br/>67 (22)<br/>Learning Objectives<br/>67 (1)<br/>Introduction<br/>67 (1)<br/>Normal Forms<br/>68 (1)<br/>Denormalized Designs<br/>68 (1)<br/>Normalizing the Arcade Database<br/>68 (4)<br/>Update Problem<br/>70 (1)<br/>Insert Problem<br/>71 (1)<br/>The Normal Forms<br/>72 (14)<br/>First Normal Form (1NF)<br/>73 (1)<br/>Determinants<br/>74 (1)<br/>Second Normal Form (2NF)<br/>75 (2)<br/>Third Normal Form (3NF)<br/>77 (3)<br/>Boyce-Codd Normal Form (BCNF)<br/>80 (3)<br/>Fourth Normal Form (4NF)<br/>83 (2)<br/>Detecting Normalization Violations<br/>85 (1)<br/>Summary<br/>86 (1)<br/>Key Terms<br/>86 (1)<br/>Exercises<br/>86 (3)<br/>Review<br/>86 (1)<br/>Discuss<br/>87 (1)<br/>Practice<br/>87 (2)<br/>Advanced Database Designs<br/>89 (30)<br/>Learning Objectives<br/>89 (1)<br/>Introduction<br/>89 (1)<br/>Recursive Relationships<br/>90 (5)<br/>An Example Recursive Relationship<br/>90 (1)<br/>Creating the Mentor Recursive Relationship<br/>91 (1)<br/>A Many-to-Many Recursive Relationship<br/>92 (3)<br/>Hierarchies: Supertypes and Subtypes<br/>95 (6)<br/>A Supertype/Subtype Hierarchy Example<br/>97 (3)<br/>A Second Supertype/Subtype Hierarchy Example<br/>100 (1)<br/>Complex Designs<br/>101 (12)<br/>Problem Statement: Summer Reading Fun<br/>101 (6)<br/>Problem Statement: Swampland Real Estate<br/>107 (6)<br/>Summary<br/>113 (1)<br/>Key Terms<br/>114 (1)<br/>Exercises<br/>114 (5)<br/>Review<br/>114 (1)<br/>Discuss<br/>115 (1)<br/>Practice<br/>115 (4)<br/>Creating Databases with Oracle Using SQL<br/>119 (26)<br/>Learning Objectives<br/>119 (1)<br/>Introduction<br/>119 (1)<br/>Physical Table Design<br/>120 (1)<br/>Data Types and Column Widths<br/>120 (1)<br/>The Sky Member Database<br/>120 (7)<br/>Reserved Words<br/>121 (1)<br/>Implementation<br/>122 (5)<br/>The Arcade Database<br/>127 (3)<br/>The Enrollment Database<br/>130 (4)<br/>Creating a Concatenated Key<br/>132 (1)<br/>Referential Integrity Controls the Order of Drop and Create<br/>132 (2)<br/>Troubleshooting<br/>134 (3)<br/>Invalid Identifer<br/>135 (1)<br/>Missing or Invalid Option<br/>136 (1)<br/>Invalid User.table.column, Table.column, or Column Specification<br/>136 (1)<br/>Missing Expression<br/>137 (1)<br/>Integrity Constraint Violated -- Parent Key Not Found<br/>137 (1)<br/>Summary<br/>137 (1)<br/>Key Terms<br/>138 (1)<br/>Exercises<br/>138 (7)<br/>Review<br/>138 (1)<br/>Discuss<br/>138 (1)<br/>Practice<br/>139 (6)<br/>Retrieving Data with Oracle<br/>145 (58)<br/>Learning Objectives<br/>145 (1)<br/>Introduction<br/>145 (1)<br/>Basic Retrieval Operations in SQL<br/>146 (23)<br/>Displaying All Columns and Rows<br/>146 (2)<br/>Using a Column List<br/>148 (1)<br/>Sorting with Order By<br/>149 (2)<br/>Sorting on Multiple Columns<br/>151 (2)<br/>Selecting Rows with Where<br/>153 (2)<br/>Where Clauses Involving Text Data<br/>155 (1)<br/>The LIKE Operator<br/>155 (1)<br/>Complex Where Clauses<br/>156 (4)<br/>Multiple Conditions on the Same Column<br/>160 (2)<br/>Using the IN Operator<br/>162 (1)<br/>Using the Between Operator<br/>163 (1)<br/>The NOT Operator<br/>164 (1)<br/>Combining AND and OR<br/>165 (4)<br/>Aggregate Functions<br/>169 (5)<br/>The Count Function<br/>171 (1)<br/>Using Where with Aggregate Functions<br/>172 (2)<br/>Grouping Data in a Query<br/>174 (7)<br/>Using Distinct<br/>174 (1)<br/>Grouping and Aggregate Functions<br/>174 (3)<br/>Limiting Groups with the Having Clause<br/>177 (2)<br/>Combining Having and Where<br/>179 (2)<br/>Combining Data from Different Tables<br/>181 (8)<br/>Combining Joins with Other Where Conditions<br/>184 (3)<br/>Joining More Than Two Tables<br/>187 (2)<br/>Subqueries<br/>189 (5)<br/>Summary<br/>194 (1)<br/>Key Terms<br/>195 (1)<br/>Exercises<br/>195 (8)<br/>Review<br/>195 (1)<br/>Discuss<br/>196 (1)<br/>Practice<br/>196 (7)<br/>Creating Databases with Microsoft Access<br/>203 (28)<br/>Learning Objectives<br/>203 (1)<br/>Introduction<br/>203 (1)<br/>Physical Table Design<br/>204 (1)<br/>Data Types and Column Widths<br/>204 (1)<br/>The Sky Member Database<br/>205 (9)<br/>Creating an Access Database with a Single Table<br/>206 (6)<br/>Using a Query to Display Table Data<br/>212 (2)<br/>The Arcade Database<br/>214 (4)<br/>Create the Database and Tables<br/>215 (1)<br/>Create the Relationship Between the Tables<br/>215 (2)<br/>Entering the Data for the Arcade Database<br/>217 (1)<br/>Displaying the Data<br/>218 (1)<br/>The Enrollment Database<br/>218 (4)<br/>Creating the Enroll Database<br/>221 (1)<br/>Creating a Concatenated Key<br/>221 (1)<br/>Relationships for the Enroll Database<br/>221 (1)<br/>Summary<br/>222 (1)<br/>Key Terms<br/>223 (1)<br/>Exercises<br/>223 (8)<br/>Review<br/>223 (1)<br/>Discuss<br/>223 (1)<br/>Practice<br/>224 (7)<br/>Retrieving Data with Microsoft Access<br/>231 (66)<br/>Learning Objectives<br/>231 (1)<br/>Introduction<br/>231 (1)<br/>Basic Retrieval Operations in SQL<br/>232 (30)<br/>Displaying All Columns and Rows<br/>232 (4)<br/>Using a Column List<br/>236 (2)<br/>Sorting with Order By<br/>238 (2)<br/>Sorting on Multiple Columns<br/>240 (2)<br/>Selecting Rows with Where<br/>242 (2)<br/>Where Clauses Involving Text Data<br/>244 (1)<br/>The LIKE Operator<br/>245 (1)<br/>Complex Where Clauses<br/>246 (6)<br/>Multiple Conditions on the Same Column<br/>252 (5)<br/>The NOT Operator<br/>257 (1)<br/>Combining AND and OR<br/>258 (4)<br/>Aggregate Functions<br/>262 (4)<br/>The COUNT Function<br/>264 (1)<br/>Using Where with Aggregate Functions<br/>264 (2)<br/>Grouping Data in a Query<br/>266 (8)<br/>Using DISTINCT<br/>266 (1)<br/>Grouping and Aggregate Functions<br/>267 (3)<br/>Limiting Groups with the Having Clause<br/>270 (2)<br/>Combining Having and Where<br/>272 (2)<br/>Combining Data from Different Tables<br/>274 (10)<br/>Combining Joins with Other Where Conditions<br/>278 (2)<br/>Joining More Than Two Tables<br/>280 (4)<br/>Subqueries<br/>284 (5)<br/>Summary<br/>289 (1)<br/>Key Terms<br/>290 (1)<br/>Exercises<br/>291 (6)<br/>Review<br/>291 (1)<br/>Discuss<br/>291 (1)<br/>Practice<br/>292 (5)<br/>Creating Databases with Microsoft SQL Server<br/>297 (36)<br/>Learning Objectives<br/>297 (1)<br/>Introduction<br/>297 (1)<br/>Physical Table Design<br/>298 (2)<br/>Data Types and Column Widths<br/>298 (2)<br/>The Sky Member Database<br/>300 (13)<br/>Creating an SQL Server Database with a Single Table<br/>301 (10)<br/>Using Query Analyzer to Insert Data<br/>311 (2)<br/>The Arcade Database<br/>313 (5)<br/>Create the Database and Tables<br/>314 (2)<br/>Create the Relationship Between the Tables<br/>316 (1)<br/>Entering the Data for the Arcade Database<br/>317 (1)<br/>The Enrollment Database<br/>318 (6)<br/>Creating a Concatenated Key<br/>321 (1)<br/>Relationships for the Enroll Database<br/>321 (3)<br/>Summary<br/>324 (1)<br/>Key Terms<br/>325 (1)<br/>Exercises<br/>325 (8)<br/>Review<br/>325 (1)<br/>Discuss<br/>325 (1)<br/>Practice<br/>325 (8)<br/>Retrieving Data with SQL Server<br/>333 (74)<br/>Learning Objectives<br/>333 (1)<br/>Introduction<br/>333 (1)<br/>Basic Retrieval Operations in SQL<br/>334 (1)<br/>Displaying All Columns and Rows<br/>335 (32)<br/>The SQL Server Query Analyser<br/>337 (1)<br/>Using a Column List<br/>338 (3)<br/>Sorting with Order By<br/>341 (3)<br/>Sorting on Multiple Columns<br/>344 (2)<br/>Selecting Rows with Where<br/>346 (2)<br/>Where Clauses Involving Text Data<br/>348 (1)<br/>The LIKE Operator<br/>349 (1)<br/>Where Clauses with Multiple Conditions<br/>350 (6)<br/>Multiple Conditions on the Same Column<br/>356 (3)<br/>Using the IN Operator<br/>359 (1)<br/>Using the BETWEEN Operator<br/>360 (1)<br/>The NOT Operator<br/>361 (2)<br/>Combining AND and OR<br/>363 (4)<br/>Aggregate Functions<br/>367 (12)<br/>Creating Column Aliases<br/>371 (2)<br/>Using DISTINCT<br/>373 (1)<br/>Creating Subaggregations with Group By<br/>374 (3)<br/>Limiting Groups with the Having Clause<br/>377 (2)<br/>Combining Data from Different Tables<br/>379 (13)<br/>Errors Resulting from Omitting the Join Condition<br/>382 (1)<br/>Combining Joins with Other Where Conditions<br/>383 (4)<br/>Joining More Than Two Tables<br/>387 (5)<br/>Subqueries<br/>392 (7)<br/>Summary<br/>399 (1)<br/>Key Terms<br/>399 (1)<br/>Exercises<br/>400 (7)<br/>Review<br/>400 (1)<br/>Discuss<br/>400 (1)<br/>Practice<br/>400 (7)<br/>Accessing Databases from Web Applications with Microsoft ASP.NET<br/>407 (54)<br/>Learning Objectives<br/>407 (1)<br/>Introduction<br/>407 (1)<br/>What Is ASP.NET?<br/>408 (2)<br/>ASP.NET Web Forms<br/>408 (2)<br/>An Example Web Application<br/>410 (8)<br/>An Introduction to Web Developer Express<br/>410 (1)<br/>Creating a Web Site<br/>411 (7)<br/>Example 1: Displaying the Contents of a Table<br/>418 (13)<br/>Creating the SqlDataSource Control<br/>419 (1)<br/>Selecting the Data Provider<br/>420 (1)<br/>Setting up a Data Connection<br/>421 (1)<br/>Choosing a Connection for the Data Source<br/>422 (2)<br/>Configuring the Data Source<br/>424 (1)<br/>Creating a GridView Control<br/>425 (2)<br/>Finishing the Application<br/>427 (1)<br/>Setting Up a Connection to an Oracle Database<br/>428 (3)<br/>Example 2: Displaying Single Records from a Table<br/>431 (9)<br/>Creating the Web Site and Adding the Database<br/>431 (2)<br/>Adding the Textbox<br/>433 (1)<br/>Adding and Configuring the Data Source<br/>433 (2)<br/>Creating the Query for the Data Source<br/>435 (1)<br/>Setting up the Where Clause for the Query<br/>436 (1)<br/>Adding the GridView<br/>437 (1)<br/>Finishing the Application<br/>438 (2)<br/>Example 3: Retrieving Data with Multiple Conditions<br/>440 (11)<br/>Summary<br/>451 (1)<br/>Key Terms<br/>452 (1)<br/>Exercises<br/>453 (8)<br/>Review<br/>453 (1)<br/>Discuss<br/>453 (1)<br/>Practice<br/>453 (8)<br/>Maintaining Databases from Web Applications with Microsoft ASP.NET<br/>461 (34)<br/>Learning Objectives<br/>461 (1)<br/>Introduction<br/>461 (1)<br/>The DetailsView Server Control<br/>462 (1)<br/>Creating a Member Maintenance Web Application<br/>462 (18)<br/>Configuring the Data Source<br/>463 (2)<br/>Configuring the DetailsView Control<br/>465 (1)<br/>Adding the Ability to Insert New Rows<br/>466 (8)<br/>Adding the Ability to Update Rows<br/>474 (3)<br/>Adding the Ability to Delete Rows<br/>477 (3)<br/>Automatically Generating Insert, Update, and Delete Statements<br/>480 (2)<br/>Creating a Member Maintenance Application with a GridView<br/>482 (3)<br/>Summary<br/>485 (1)<br/>Key Terms<br/>486 (1)<br/>Exercises<br/>486 (9)<br/>Review<br/>486 (1)<br/>Discuss<br/>487 (1)<br/>Practice<br/>487 (8)<br/>Glossary 495 (4)<br/>Index 499 |
| 520 ## - SUMMARY, ETC. | |
| Summary, etc. | "Database Design and Development: A Visual Approach simplifies the design process but not the end result. It bridges the gap between theory, business problem solving, and hands-on practice. With this text, you will learn how to design and actually develop a database that solves business problems."--Jacket |
| 546 ## - LANGUAGE NOTE | |
| Language note | In English text. |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Electronic commerce |
| Form subdivision | Databases. |
| 9 (RLIN) | 2738 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Business |
| Form subdivision | Databases. |
| 9 (RLIN) | 2739 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Database design. |
| 9 (RLIN) | 586 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Database management. |
| 9 (RLIN) | 310 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Management information systems. |
| 9 (RLIN) | 311 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Business. |
| 9 (RLIN) | 1410 |
| 650 ## - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name entry element | Electronic commerce. |
| 9 (RLIN) | 1365 |
| 700 ## - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Day, John, author. |
| 9 (RLIN) | 2740 |
| 700 ## - ADDED ENTRY--PERSONAL NAME | |
| Personal name | Van Slyke, Craig, author. |
| 9 (RLIN) | 2741 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Book |
| Classification part | QA 76.9.D3 F76 2006 |
| Call number prefix | CIR |
| Source of classification or shelving scheme | Library of Congress Classification |
| Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Collection code | Home library | Current library | Shelving location | Date acquired | Source of acquisition | Coded location qualifier | Full call number | Barcode | Date last seen | Copy number | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | Book | Cavite State University - CCAT Campus | Cavite State University - CCAT Campus | GCS | 08/18/2011 | Donated by Mr. Arminio Grepo | GCS | CIR QA 76.9.D3 F76 2006 | R0010212 | 10/15/2025 | c.1 | 03/24/2021 | Book | ||||
| Library of Congress Classification | Book | Cavite State University - CCAT Campus | Cavite State University - CCAT Campus | GCS | 08/18/2011 | Donated by Mr. Arminio Grepo | GCS | CIR QA 76.9.D3 F76 2006 | R0010213 | 10/15/2025 | c.2 | 10/23/2023 | Book | ||||
| Library of Congress Classification | Book | Cavite State University - CCAT Campus | Cavite State University - CCAT Campus | GCS | 08/18/2011 | Donated by Mr. Arminio Grepo | GCS | CIR QA 76.9.D3 F76 2006 | R0010214 | 10/15/2025 | c.3 | 10/23/2023 | Book | ||||
| Library of Congress Classification | Book | Cavite State University - CCAT Campus | Cavite State University - CCAT Campus | GCS | 08/18/2011 | Donated by Mr. Arminio Grepo | GCS | CIR QA 76.9.D3 F76 2006 | R0010215 | 10/15/2025 | c.4 | 10/23/2023 | Book | ||||
| Library of Congress Classification | Book | Cavite State University - CCAT Campus | Cavite State University - CCAT Campus | GCS | 08/18/2011 | Donated by Mr. Arminio Grepo | GCS | CIR QA 76.9.D3 F76 2006 | R0010216 | 10/15/2025 | c.5 | 10/23/2023 | Book | ||||
| Library of Congress Classification | Book | Cavite State University - CCAT Campus | Cavite State University - CCAT Campus | GCS | 08/18/2011 | Donated by Mr. Arminio Grepo | GCS | CIR QA 76.9.D3 F76 2006 | R0010217 | 10/15/2025 | c.6 | 10/23/2023 | Book | ||||
| Library of Congress Classification | Book | Cavite State University - CCAT Campus | Cavite State University - CCAT Campus | GCS | 08/18/2011 | Donated by Mr. Arminio Grepo | GCS | CIR QA 76.9.D3 F76 2006 | R0010218 | 10/15/2025 | c.7 | 10/23/2023 | Book |