Fundamentals of Database Management Systems /
Gillenson, Mark L.
Fundamentals of Database Management Systems / Mark L. Gillenson. - Hoboken, NJ : Wiley, 2005. - xvii, 366 p. : ill. ; 26 cm.
Includes index.
Preface.About the Author.Chapter 1. Data: The New Corporate Resource.The History of Data.The Origins of Data.Data Through the Ages.Early Data Problems Spawn Calculating Devices.Swamped with Data.Modern Data Storage Media.Data in Today's Information Systems Environment.Using Data for Competitive Advantage.Problems in Storing and Accessing Data.Data as a Corporate Resource.The Database Environment.Chapter 2. Simple File Storage and Retrieval.What Is Data?Important Objects and Facts.Records and Files.Basic Concepts in Storing and Retrieving Data.Retrieving and Manipulating Data.Disk Storage.The Need for Disk Storage.How Disk Storage Works,File Organizations and Access Methods.The Goal: Locating a Record.The Index.Hashed Files.Chapter 3. Data Modeling.Introduction.Binary Relationships.What Is a Binary Relationship?Cardinality.Modality.More About Many-to-Many Relationships.Unary Relationships.One-to-One Unary Relationship.One-to-Many Unary Relationship.Many-to-Many Unary Relationship.Ternary Relationships.Examples.The General Hardware Company.Good Reading Bookstores.World Music Association.Lucky Rent-A-Car.Chapter 4. The Database Management System Concept.The Database Concept.Data as a Manageable Resource.Data Integration and Data Redundancy.Multiple Relationships.Data Control Issues.Data Independence.DBMS Approaches.Chapter 5. The Relational Database Model: Introduction.The Relational Database Concept.Relational Terminology.Primary and Candidate Keys.Foreign Keys and Binary Relationships.Data Retrieval from a Relational Database.Extracting Data from a Relation.The Relational Select Operator.The Relational Project Operator.Combination of the Relational Select and Project Operators.Extracting Data Across Multiple Relations: Data Integration.Example: Good Reading Bookstores.Example: World Music Association.Example: Lucky Rent-A-Car.Chapter 6. The Relational Database Model: Additional Concepts.Relational Structures for Unary and Ternary Relationships.Unary One-to-Many Relat
A compact, practical introduction that concentrates on providing readers with a clear understanding of database fundamentals while providing a broad survey of all the major topics of the field Written in a clear, friendly style that progresses step-by-step through all of the major database topics When readers finish the book, they will be able to immediately apply what they've learned Makes heavy use of examples, including four major examples that are used throughout the text
0471262978 (US) 0471659258 (WIE)
Database management.
QA76.9.D3 / G5225 2005
Fundamentals of Database Management Systems / Mark L. Gillenson. - Hoboken, NJ : Wiley, 2005. - xvii, 366 p. : ill. ; 26 cm.
Includes index.
Preface.About the Author.Chapter 1. Data: The New Corporate Resource.The History of Data.The Origins of Data.Data Through the Ages.Early Data Problems Spawn Calculating Devices.Swamped with Data.Modern Data Storage Media.Data in Today's Information Systems Environment.Using Data for Competitive Advantage.Problems in Storing and Accessing Data.Data as a Corporate Resource.The Database Environment.Chapter 2. Simple File Storage and Retrieval.What Is Data?Important Objects and Facts.Records and Files.Basic Concepts in Storing and Retrieving Data.Retrieving and Manipulating Data.Disk Storage.The Need for Disk Storage.How Disk Storage Works,File Organizations and Access Methods.The Goal: Locating a Record.The Index.Hashed Files.Chapter 3. Data Modeling.Introduction.Binary Relationships.What Is a Binary Relationship?Cardinality.Modality.More About Many-to-Many Relationships.Unary Relationships.One-to-One Unary Relationship.One-to-Many Unary Relationship.Many-to-Many Unary Relationship.Ternary Relationships.Examples.The General Hardware Company.Good Reading Bookstores.World Music Association.Lucky Rent-A-Car.Chapter 4. The Database Management System Concept.The Database Concept.Data as a Manageable Resource.Data Integration and Data Redundancy.Multiple Relationships.Data Control Issues.Data Independence.DBMS Approaches.Chapter 5. The Relational Database Model: Introduction.The Relational Database Concept.Relational Terminology.Primary and Candidate Keys.Foreign Keys and Binary Relationships.Data Retrieval from a Relational Database.Extracting Data from a Relation.The Relational Select Operator.The Relational Project Operator.Combination of the Relational Select and Project Operators.Extracting Data Across Multiple Relations: Data Integration.Example: Good Reading Bookstores.Example: World Music Association.Example: Lucky Rent-A-Car.Chapter 6. The Relational Database Model: Additional Concepts.Relational Structures for Unary and Ternary Relationships.Unary One-to-Many Relat
A compact, practical introduction that concentrates on providing readers with a clear understanding of database fundamentals while providing a broad survey of all the major topics of the field Written in a clear, friendly style that progresses step-by-step through all of the major database topics When readers finish the book, they will be able to immediately apply what they've learned Makes heavy use of examples, including four major examples that are used throughout the text
0471262978 (US) 0471659258 (WIE)
Database management.
QA76.9.D3 / G5225 2005