Database Sys
Home > Computing and Information Technology > Computer networking and communications > Networking standards and protocols > Database Sys
Database Sys

Database Sys

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

Powerful database systems running on all platforms from PCs to mainframes are vital for the success of modern companies and institutions. This book will enable users to design database systems that are flexible and efficient, following a proven methodology for both logical and physical database design. Highlights of the book include * A step-by-step methodology for logical database design, integrating the Entity Relationship Model with normalization, and showing how to map this on to a physical implementation * A realistic case study integrated throughout the book, illustrating all stages in the development process * Extensive treatment of formal and de facto standards, including SQL, QBE and the ODMG standard for object databases * A clear introduction to implementation and management aspects, including concurrency and recovery control, security and integrity * Comprehensive chapters on distributed and object-oriented databases, including a preview of SQL3 The practical, hands-on approach will benefit students in computing, information systems, engineering and business, while its industrial-strength methodology can be followed by systems analysts/designers, systems or application programmers, and database adm inistrators. All three authors have experience of database design in industry, and now apply this in their teaching and research at the University of Paisley in Scotland. Thomas Connolly has significant industrial experience and was a designer of RAPPORT, the world's first commercial portable DBMS, and of the LIFESPAN configuration management tool -- a winner of the British Design Award. Carolyn Begg specializes in the application of database systems in the medical domain, while Anne Strachan focuses on problems associated with large diverse data sets in organizations. 0201422778B04062001

Table of Contents:
1. Introduction to Databases. Introduction. Traditional File-based Systems. File-based Approach. Limitations of the File-based Approach. Database Approach. The Database. The Database Management System (DBMS). Components of the DBMS Environment. Database Design - The Paradigm Shift. Roles in the Database Environment. Data and Database Administrators. Database Designers. Application Programmers. End Users. The History of Database Systems. Advantages and Disadvantages of Database Systems. The DreamHome Case Study. Student Project -- The Wellmeadows Hospital Case Study. Chapter Summary. Review Questions. Exercises. 2. Database Environment. The 3-Level ANSI-SPARC Architecture. External Level. Conceptual Level. Internal Level. Schemas, Mappings and Instances. Data Independence. Database Languages. The Data Definition Language (DDL). The Data Manipulation Language (DML). 4GL. Data Models and Conceptual Modelling. Object-based Data Models. Record-based Data Models. Physical Data Models. Conceptual Modelling. Functions of a DBMS. Components of a DBMS. Multi-User DBMS Architectures. Data Dictionaries. Information Resource Dictionary System (IRDS). Chapter Summary. Review Questions. Exercises. 3. Relational Data Model. Brief History of the Relational Model. Terminology. Relational Data Structure. Mathematical Relations. Database Relations. Properties of Relations. Relational Keys. Representing Relational Database Schemas. Relational Integrity. NULLs. Entity Integrity. Referential Integrity. Enterprise Constraints. Relational Languages. Relational Algebra. Relational Calculus. Other Languages. Views. Terminology. Purpose of Views. Updating Views. When is a DBMS Relational? Chapter Summary. Review Questions. Exercises. 4. Database Planning, Design and Administration. Overview of the Information Systems Lifecycle. The Database Application Lifecycle. Database Planning. System Definition. Requirements Collection and Analysis. Database Design. DBMS Selection. Application Design. Prototyping. Implementation. Data Conversion and Loading. Testing. Operational Maintenance. Overview of Database Design. Logical Database Design. Physical Database Design. Application Design. Transaction Design. User Interface Design Guidelines. CASE Support. DBMS Selection. Choosing the Best System. Data and Database Administration. Data Administration Role. Data Administration Functions. Database Administration Role. Database Administration Functions. Comparison of Data and Database Administration Roles. Chapter Summary. Review Questions. Exercises. 5. Entity Relationship Modelling. The Concepts of the Entity-Relationship Model. Entity Types. Attributes. Relationship Types. Attributes on Relationships. Structural Constraints. Cardinality Constraints. Participation Constraints. Problems with ER Models. Fan Traps. Chasm Traps. The Enhanced Entity-Relationship Model. Superclasses and Subclasses of Entity Types. Attribute Inheritance. Specialization. Generalization. Constraints on Specialization and Generalization. The Manager's View of the DreamHome Case Study -- Building an ER Model. The Manager's Requirements Specification. Building an ER Model. CASE Tools for ER Modelling. Chapter Summary. Review Questions. Exercises. 6. Normalization The Purpose of Normalization. Information Redundancy and Update Anomalies. Insertion Anomalies. Deletion Anomalies. Modification Anomalies. Functional Dependencies. Definition of Functional Dependency. The Process of Normalization. First Normal Form (1NF). Second Normal Form (2NF). Full Functional Dependency. Definition of Second Normal Form. Third Normal Form (3NF). Boyce-Codd Normal Form (BCNF). Definition of Boyce-Codd Normal Form. Review of Normalization (1NF to BCNF). First Normal Form (1NF). Second Normal Form (2NF). Third Normal Form (3NF). Boyce-Codd Normal Form (BCNF). Chapter Summary. Review Questions. Exercises. 7. Methodology -- Logical Database Design. Database Design Methodology. What is a Design Methodology? Logical and Physical Database Design. Overview of Methodology. Critical Success Factors in Logical Database Design. The Logical Database Design Methodology. STEP 1: Build Local Conceptual Data Model from User View. STEP 1.1: Identify Entity Types. STEP 1.2: Identify Relationship Types. STEP 1.3: Identify and Associate Attributes with Entity or Relationship Types. STEP 1.4: Determine Attribute Domains. STEP 1.5: Determine Candidate and Primary Key Attributes. STEP 1.6: Specialize / Generalize Entity Types (Optional Step). STEP 1.7: Draw Entity-Relationship Diagram. STEP 2: Build and Validate Local Logical Data Model. STEP 2.1: Map Local Conceptual Data Model to Local Logical Data Model. STEP 2.2: Derive Relations from Local Logical Data Model. STEP 2.3: Validate Model using Normalization. STEP 2.4: Validate Model against User Transactions. STEP 2.5: Draw Entity-Relationship Diagram. STEP 2.6: Identify Integrity Constraints. STEP 2.7: Review Local Logical Data Model with User. STEP 3: Build and Validate Global Logical Data Model. STEP 3.1: Merge Local Logical Data Models into Global Model. STEP 3.2: Validate Global Logical Data Model. STEP 3.3: Check for Future Growth. STEP 3.4: Draw Final Entity-Relationship Diagram. STEP 3.5: Review Global Logical Data Model with Users. Review Questions. 8. Logical Database Design Methodology -- Worked Example. The Supervisor--s Requirements Specification. Database Requirements. Database Transactions. Using the Logical Database Design Methodology for the Relational Data Model. STEP 1: Build Local Conceptual Data Model based on the Supervisor's View. STEP 1.1: Identify Entity Types. STEP 1.2: Identify Relationship Types. STEP 1.3: Identify and Associate Attributes with Entity or Relationship Types. STEP 1.4: Determine Domains. STEP 1.5: Determine Candidate and Primary Key Attributes. STEP 1.6: Specialize / Generalize Entity Types (Optional Step). STEP 1.7: Draw Entity-Relationship (ER) Diagram. STEP 2: Build and Validate Local Logical Data Model. STEP 2.1: Map Local Conceptual Data Model to Local Logical Data Model. STEP 2.2: Derive Relations from Local Logical Data Model. STEP 2.3: Validate Model using Normalization. STEP 2.4: Validate Model against User Transactions. STEP 2.5: Draw Entity-Relationship Diagram. STEP 2.6: Define Integrity Constraints. STEP 2.7: Review Local Logical Data Model with User. STEP 3: Build Global Logical Data Model. STEP 3.1: Merge Local Logical Data Models into Global Model. STEP 3.2: Validate Global Logical Data Model. STEP 3.3: Check for Future Growth. STEP 3.4: Draw Final Entity-Relationship Diagram. 9. Methodology -- Physical Database Design. Introduction. The Database Design Process. Overview of Physical Database Design Methodology. Physical Database Design and Implementation for Relational Databases. STEP 4: Translate Global Logical Data Model for Target DBMS. STEP 4.1: Design Base Relations for Target DBMS. STEP 4.2: Design Enterprise Constraint Rules for Target DBMS. STEP 5: Design Physical Representation. STEP 5.1: Analyze Transactions. STEP 5.2: Choose File Organization. STEP 5.3: Choose Secondary Indexes. STEP 5.4: Consider the Introduction of Controlled Redundancy. STEP 5.5: Estimate Disk Space. STEP 6: Design Security Mechanisms. STEP 6.1: Design User Views. STEP 6.2: Design Access Rules. STEP 7: Monitor and Tune Operational System. Chapter Summary. Review Questions. Exercises. 10. Physical Database Design -- Worked Example. Paradox for Windows DBMS. Using the Physical Database Design and Implementation Methodology for Relational Databases. STEP 4: Translate Global Logical Data Model for Target DBMS. STEP 4.1: Design Base Relations for Target. STEP 4.2: Design Enterprise Rules for Target DBMS. STEP 5: Design and Implement Physical Representation. STEP 5.1: Analyze Transactions. STEP 5.2: Choose File Organization. STEP 5.3: Choose Secondary Indexes. STEP 5.4: Consider the Introduction of Controlled Redundancy. STEP 5.5: Estimate Disk Space. STEP 6: Design and Implement Security Mechanisms. STEP 6.1: Design User Views. STEP 6.2: Design Access Rules. STEP 7: Monitor and Tune the Operational System. 11. SQL. Introduction to SQL. Objectives of SQL. History of SQL. Importance of SQL. Writing SQL Commands. Data Manipulation. Simple Queries. Sorting Results (ORDER BY Clause). Using the SQL Aggregate Functions. Grouping Results (GROUP BY Clause). Restricting Grouping (HAVING Clause). Subqueries. ANY and ALL. Multi-Table Queries. Outer Joins. EXISTS and NOT EXISTS. Combining Result Tables (UNION, INTERSECT, EXCEPT). Database Updates. Adding Data to the Database (INSERT). Modifying Data in the Database (UPDATE). Deleting Data from the Database (DELETE). Data Definition. SQL Identifiers. The ISO SQL Data Types. Creating a Database. Creating a Table (CREATE TABLE). 0201422778T04062001


Best Sellers


Product Details
  • ISBN-13: 9780201422771
  • Publisher: Pearson Education Limited
  • Publisher Imprint: Addison Wesley
  • Language: English
  • ISBN-10: 0201422778
  • Publisher Date: 20 Oct 1995
  • Binding: Paperback
  • Returnable: N


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Database Sys
Pearson Education Limited -
Database Sys
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Database Sys

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!