Mehr lesen
Klappentext This lean, focused text concentrates on giving students a clear understanding of database fundamentals while providing a broad survey of all the major topics of the field. The result is a text that is easily covered in one semester, and that only includes topics relevant to the database course.Mark Gillenson, an associate editor of the Journal of Database Management, has 15 years experience of working with and teaching at IBM Corp. and 15 years of teaching experience at the college level. He writes in a clear, friendly style that progresses step-by-step through all of the major database topics. Each chapter begins with a story about a real company's database application, and is packed with examples. When students finish the text, they will be able to immediately apply what they've learned in business. Zusammenfassung This lean, focused text concentrates on giving students a clear understanding of database fundamentals while providing a broad survey of all the major topics of the field. The result is a text that is easily covered in one semester, and that only includes topics relevant to the database course.Mark Gillenson, an associate editor of the Journal of Database Management, has 15 years experience of working with and teaching at IBM Corp. and 15 years of teaching experience at the college level. He writes in a clear, friendly style that progresses step-by-step through all of the major database topics. Each chapter begins with a story about a real company's database application, and is packed with examples. When students finish the text, they will be able to immediately apply what they've learned in business. Inhaltsverzeichnis Preface xiiiAbout The Author xviiCHAPTER 1 DATA: THE NEW CORPORATE RESOURCE 1Introduction 2The History of Data 2The Origins of Data 2Data Through the Ages 5Early Data Problems Spawn Calculating Devices 7Swamped with Data 8Modern Data Storage Media 9Data in Today's Information Systems Environment 12Using Data for Competitive Advantage 12Problems in Storing and Accessing Data 12Data as a Corporate Resource 13The Database Environment 14Summary 15CHAPTER 2 DATA MODELING 19Introduction 20Binary Relationships 20What is a Binary Relationship? 20Cardinality 23Modality 24More About Many-to-Many Relationships 25Unary Relationships 28One-to-One Unary Relationship 28One-to-Many Unary Relationship 29Many-to-Many Unary Relationship 29Ternary Relationships 31Example: The General Hardware Company 31Example: Good Reading Book Stores 34Example: World Music Association 35Example: Lucky Rent-A-Car 36Summary 37CHAPTER 3 THE DATABASE MANAGEMENT SYSTEM CONCEPT 41Introduction 42Data Before Database Management 43Records and Files 43Basic Concepts in Storing and Retrieving Data 46The Database Concept 48Data as a Manageable Resource 48Data Integration and Data Redundancy 49Multiple Relationships 56Data Control Issues 58Data Independence 60DBMS Approaches 60Summary 63CHAPTER 4 RELATIONAL DATA RETRIEVAL: SQL 67Introduction 68Data Retrieval with the SQL SELECT Command 68Introduction to the SQL SELECT Command 68Basic Functions 70Built-In Functions 81Grouping Rows 83The Join 85Subqueries 86A Strategy for Writing SQL SELECT Commands 89Example: Good Reading Book Stores 90Example: World Music Association 92Example: Lucky Rent-A-Car 95Relational Query Optimizer 97Relational DBMS Performance 97Relational Query Optimizer Concepts 97Summary 99CHAPTER 5 THE RELATIONAL DATABASE MODEL: INTRODUCTION 105Introduction 106The Relational Database Concept 106Relational Terminology 106Primary and Candidate Keys 109Foreign Keys and Binary Relationships 111Data Retrieval from a Relational Database 124Extracting Data from a Relation 124The Relational Select Operator 125The Relational Project Operator 125Combination of the Relational Select and Project Operators...
