Hansen, Gary W. <br/><br/>
Database management and design / 
Gary W. Hansen and James V. Hansen 
 - New Delhi :  PHI ,  2010. 
 - xxvi, 582 p.  ill. ; 
<br/><br/>Part One<br/>DATABASES AND THEIR CONTEXT I<br/>One<br/>Database Systems and the Evolution of Database Technology<br/>The Evolution of Database Technology<br/>Case: International Product Distribution<br/>Flle- Orlented Systems<br/>Meeting the Need for Random Access Processing<br/>Information as a Resource<br/>Other Limitations off raditional File Systems<br/>Database Systems<br/>Hierarchical and Network Model Systems<br/>Relational Database Systems<br/>Current Directions—Client/Server Platforms<br/>Database Systems: Hardware, Software, Data, People<br/>* Hardware 23 * Software 24 ▼ Data 27 ▼ People<br/>Relationship of the Four System Components<br/>Summary<br/>Review Questions<br/>Two<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Bonhomie Catering: An Introductory Database Application<br/>The Bonhomie Catering Case<br/>Background<br/>Business Operations<br/>Employee Services<br/>Purchasing<br/>Job Scheduling<br/>Promotion<br/>Financial Status<br/>Database Design and Implementation<br/>A Description of the Sales/Cash Receipts Cycle<br/>From Entitles to Tables<br/>Creating aTable<br/>Data Model Diagram Revisited<br/>Setting Validity Checks<br/>Additional DBMS Features<br/>Dap Entry Through Simple Forms<br/>A Multi-Table Form;The Request Form<br/>Obtaining Management Information from Our Database<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Three<br/>Database Systems in the Organization<br/>Data Sharing and Databases<br/>Sharing Data Between Functional Units<br/>Sharing Data Between Different Levels of Users<br/>Sharing Data Between Different Locations<br/>The Role of the Database<br/>Strategic Database Planning<br/>The Need for Database Planning<br/>The Database Planning Project<br/>The Database Development Life Cycle (DDLC)<br/>Databases and Management Control<br/>Four<br/>Database Design<br/>User Training<br/>Database Security and Integrity<br/>Database System Performance<br/>Risks and Costs of Databases<br/>Organizational Conflicts<br/>Development Project Failure<br/>System Failure<br/>Overhead Costs<br/>Need for Sophisticated Personnel<br/>Separating Logical and Physical Data Representation<br/>Three-Level Database Architecture<br/>Use of the Three-Level Architecture In this Book<br/>Database Development<br/>Database Design and the Traditional SDLC<br/>The Database Development Life Cycle (DDLC)<br/>CaseiThe Zeus Corporation<br/>Preliminary Planning<br/>Feasibility Study<br/>Requirements Definition .<br/>Conceptual Design<br/>Implementation<br/>Evaluating and Enhancing the Databasse Schema<br/>Building Skills in Database Developmen t<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Principles of Conceptual Database Design<br/>Reality, Requirements Definition, and Conceptual Data Modeling<br/>Reality and Models<br/>Conceptual Data Models<br/>Fundamentals<br/>Objects<br/>Specialization and Generalization<br/>Five<br/>Relationships<br/>Cardinality<br/>Attributes<br/>Examples<br/>Example I :The Bank Data Model<br/>Example 2: Stratton's Fruit Orchards<br/>«<br/>Example 3:A Logic Problem Involving Mapping<br/>Building Conceptual Data Models from Existing Reports<br/>Case: Manv^aring Consulting Services<br/>A Data Model for Purchases<br/>A Data Model for Project Billing<br/>Aggregation<br/>Example 4: Premier Construction Company<br/>Example 5: Stratton's Fruit Orchards Continued<br/>Example 6: Manv/aring Consulting Services Continued<br/>Modeling Conceptual Objects Versus Physical Objects<br/>The Library Problem<br/>Creating the Library Data Model<br/>Tracking Manu^ctured Parts<br/>Conceptual Objects for Manwaring Consulting Services<br/>View IntegrationiAn Example<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>The Relational Data Model<br/>The Relational Data Model and System Development<br/>The Relational Data Model: Fundamental Concepts<br/>Relations<br/>Null Values<br/>Keys<br/>Foreign Keys<br/>Integrity Constraints<br/>The Normalization Process<br/>First Normal Form<br/>Functional Dependencies<br/>Second Normal Form<br/>Third Normal Form<br/>Six<br/>Fourth Normal Form<br/>Other Normal Forms<br/>Transforming a Conceptual Model to a Relational Model<br/>Transforming Objea Sets and Attributes<br/>Transforming Models Without External Keys<br/>Transforming Specialization and Generalization Object Sets<br/>Transforming Relationships<br/>Transforming Aggregate Object Sets<br/>Transforming Recursive Relationships<br/>Transformation Examples: Manwaring Consulting Services<br/>Comparison of Conceptual and Relational Data Modeling<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Relational Algebra and Calculus<br/>A Reyolutionary Advance In Data Manipulation<br/>Relational Algebra<br/>Union<br/>Intersection<br/>Difference<br/>Product<br/>Select<br/>Project*<br/>Join<br/>Divide<br/>Assignment<br/>An Additional Example<br/>Relational Calculus<br/>Target List and Qualifying Statement<br/>The Existential Quantifier<br/>The Universal Quantifier<br/>Relative Difficulty of Relational Algebra and Relational Calculus<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Seven<br/>Relational Implementation with SQL<br/>Relational ImplementationsiAn Overviefw<br/>Schema and Table Definition<br/>Schema Definition<br/>Data Types and Domains<br/>DefiningTables<br/>Data Manipulation<br/>Simple Queries<br/>Multipie-Table Queries<br/>Subqueries<br/>EXISTS and NOT EXISTS<br/>Built-in Functions<br/>GROUP BY and HAVING<br/>Built-in Funaions with Subqueries<br/>Relational Algebra Operations<br/>Database Change Operations<br/>Using SQL With Data Processing Languages<br/>View Definition<br/>Restriaions on View Queries and Updates<br/>The Information Schema<br/>Summary<br/>Eight<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Relational Implementation with<br/>Graphical Query Languages<br/>Introduction<br/>Data Manipulation<br/>Simple Queries<br/>Multiple-Table Queries<br/>Built-in Functions<br/>GROUP BY<br/>Database Change Operations<br/>Paradox for Windows<br/>Nine<br/>Data Definition and Entry<br/>Data Manipulation<br/>Selecting Attributes and Rows<br/>Conjunctive and Disjunctive Queries<br/>Application Language<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Client/Server Database Systems<br/>Ten<br/>IntroductiomA Review of Client/Server Concepts<br/>Defining Database Tables on Server Database Management Systems<br/>Creating User-Defined Datatypes<br/>Defining Individual Tables<br/>Data Definition Language: A Summary and Final Example<br/>Server Data Manipulation and Programming<br/>Control-of-Flow Language<br/>Stored Procedures<br/>An Introduction toTriggens<br/>Developing Client Applications<br/>PowerBuilder's Approach<br/>Using PowerBuilder<br/>Building an Application<br/>Creating DataWindows<br/>Creating Windows<br/>Some Final Comments<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Professional Issues<br/>Physical Database Systems<br/>Introduction<br/>Physical Access of the Database<br/>Physical Storage Media<br/>Secondary Storage<br/>Physical Storage Blocks<br/>Disk Performance Factors<br/>Access Motion Time<br/>Head Activation Time<br/>Rotational Delay<br/>Data Transfer Rate<br/>Data Transfer Time<br/>Data Storage Formats on Disk<br/>Track Formats<br/>Record Formats<br/>Input/Output Management<br/>File Or^nization and Addressing Methods<br/>Sequential File Organization<br/>Indexed-Sequential File Organization<br/>Direct File Organization<br/>Static Hash Functions<br/>Dynamic Hash Functions<br/>Implementing Logical Relationships<br/>Linked Lists<br/>Inverted Lists<br/>Balanced-Tree Index (B'^-Tree) ■}<br/>Client/Server Implementation of Balanced-Tree Indexing<br/>Mapping Logical Data Structures to Physical Data Structures<br/>Mapping Relational Databases<br/>Mapping Network Databases<br/>Mapping-Hierarchical Databases<br/>Secondary-Key Access<br/>Query Optimization<br/>Combining Selection and Join Operations<br/>Combining Projection, Selection, and Join Operations<br/>Summary<br/>Review Questions ^<br/>Exercises and Problems<br/>Projects and Professional Issues<br/>Part Four<br/>MANAGING THE DATABASE ENVIRONMENT<br/>Eleven<br/>Database Administration and Control<br/>Database Administration: An Overview<br/>DBA Functions<br/>Communicating with Users<br/>Establishing Standards and Procedures<br/>DBA Goals<br/>Database Integrity<br/>Integrity Constraints in SQL<br/>Integrity Constraints in Query-by-Example<br/>Transaction Processing<br/>Concurrency Control<br/>Database Security<br/>Authentication<br/>Authorization and Views<br/>Encryption<br/>Database Recovery<br/>Sources of Failure<br/>Recovery Procedures<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Professional Issues<br/>Twelve<br/>Distributed Database Systems<br/>Why Distributed Databases?<br/>A General DDS Model<br/>Distributed Database System Design<br/>Strategies and Objectives<br/>Distribution of Nonfragmented Files<br/>Distributed Query Processing<br/>Semijoins<br/>Data Integrity in Distributed Database Systems<br/>Two-Phase Commit Protocol<br/>Distributed Locking<br/>Distributed Two-Phase Locking<br/>TImestamping<br/>Database Recovery<br/>Client/Server Systems<br/>General Concepts<br/>Database Applications<br/>SQL Server for Windows NT<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Professional Issues<br/>Thirteen<br/>DBMS Selection and implementation<br/>Analyzing Management Information Needs<br/>Determining Application Requirements<br/>Maintaining Data Consistency<br/>Response-Time Requirepnents<br/>DBMS Functions and Capabilities<br/>The Data Dictionary/Directory<br/>Data Security and Integrity<br/>Query, Data Manipulation, and Reporting Capabilities<br/>Support of Specialized Programming Requirements<br/>Physical Data Organization Options<br/>Classifying DBMS Feature Requirements<br/>Gathering Data on Feature Availability and Performance<br/>Acquiring Data from Vendors<br/>Benchmark Tests<br/>Evaluation Models<br/>Scoring Model<br/>Data Envelopment Analysis<br/>Implementation Issues<br/>Database Administration<br/>Database Testing<br/>Preparing Users for Change<br/>Loading the Database<br/>Database Maintenance<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Part Five<br/>ADVANCED TOPICS<br/>Fourteen<br/>Advanced Systems: Object-Oriented Database Systems and<br/>Knowledge-Base Systems<br/>An Evolution To>^rd Object-Oriented Database Systems<br/>Attempts to Provide More Powerful Data Representation<br/>The Contribution of Object-Oriented Programming (OOP)<br/>Class Abstraction<br/>Derived Classes and Simple Inheritance<br/>Aggregation<br/>An Extended Example Demonstrating Multiple Inheritance<br/>Object-Oriented Database System Developments<br/>GemStone<br/>Vbase<br/>Orion<br/>PDM<br/>IRIS<br/>O2<br/>A Generic Object Database Language<br/>The Data Model of Lerner College<br/>Formulating Queries with Textquery<br/>The Basic Format of Query Solutions InTextQuery<br/>Defining Relationship Directions<br/>Navigating Over Attributes and Relationships<br/>Assigning Names to Derived Siets<br/>Set Comparison Qualifications Expressions<br/>Boolean Connectives<br/>Introduction to Knowledge-Base Systems<br/>Knowledge and Databases<br/>Knowledge Representation with Rules<br/>Rule Formation<br/>Rules in PROLOG<br/>A Simple PROLOG Database Application<br/>More PROLOG Fundamentals<br/>The Structure of a PROLOG Application<br/>Database Application<br/>Datalog<br/>Logic Data Language (LDL)<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Part Six<br/>LEGACY DATABASE SYSTEMS<br/>Fifteen<br/>The Network Data Model<br/>Historical Background<br/>Basic Concepts and Definitions<br/>Three-Level Structure<br/>Records and Sets<br/>The Network Model's Relationship To Conceptual<br/>Modeling Semantics<br/>Transforming Object Sets and One-Many Relationships<br/>Transforming n-ary Relationships<br/>Transforming Many-Many Relationships<br/>The DBTG Data Definition Language (DDL)<br/>From Data Model to Schema<br/>From Schema to Subschema<br/>The DBTG Data Manipulation Language (DML)<br/>DBTG Retrieval arid Update Facilities<br/>DBTG Set-Processing Facility<br/>Set Operations<br/>Set Membership Classification<br/>IDMS/R—A DBTG DBMS<br/>CODASYL DBTG Evaluation<br/>Data Representation<br/>Data Manipulation Language<br/>Integrity Constraints<br/>Implementation<br/>Summary<br/>Review Questions<br/>Problems and Exercises<br/>Projects and Professional Issues<br/>Sixteen<br/>The Hierarchical Data Model<br/>Introduction<br/>Basic Concepts and Definitions<br/>Hierarchical Model's Relationship to Conceptual<br/>Modeling Semantics<br/>Transforming One-Many Relationships<br/>Transforming Many-Many Relationships<br/>The IMS Architecture<br/>Defining the Physical Database—^The DBD<br/>Defining the Logical Database—^The PSB<br/>IMS Access Methods<br/>HSAM<br/>HISAM<br/>HDAM<br/>HIDAM<br/>The IMS Data Manipulation Language<br/>Program Work Area<br/>DL/1: An Overview<br/>Get Unique (GU)<br/>Get Next (GN)<br/>Get Next Within Parent (GNP)<br/>Get Hold<br/>Replace (REPL)<br/>Delete (DLET)<br/>Insert (INSRT)<br/>Hierarchical Data Model Evaluation<br/>Data Representation<br/>Data Manipulation Language<br/>Summary<br/>Review Questions<br/>Problems and ^erclses<br/>Projects and Professional Issues 
<br/><br/><label>ISBN: </label>9788120314658 
<br/><br/><label>Subjects--Topical Terms: </label><br/>Computer Programming
<br/><br/><label>Dewey Class. No.: </label>005.74  / HAN/D