Table Of ContentPreface. 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 Relationships. Unary Many-to-Many Relationships. Ternary Relationships. Referential Integrity. The Referential Integrity Concept. Three Delete Rules. Chapter 7. Logical Database Design. Converting E-R Diagrams into Relational Tables. Introduction. Converting a Simple Entity. Converting Entities in Binary Relationships. Converting Entities in Unary Relationships. Converting Entities in Ternary Relationships. Designing the General Hardware Company Database. Designing the Good Reading Bookstores Database. Designing the World Music Association Database. Designing the Lucky Rent-A-Car Database. The Data Normalization Process. Introduction to the Data Normalization Technique. Steps in the Data Normalization Process. General Hardware Company Example. Good Reading Bookstores Example. World Music Association Example. Lucky Rent-A-Car Example. Testing Tables Converted from E-R Diagrams with Data Normalization. Chapter 8. Physical Database Design. Inputs to Physical Database Design. The Tables Produced by the Logical Database Design Process. Business Environment Requirements. Data Characteristics. Application Characteristic
SynopsisProvides readers with an understanding of database fundamentals while offering a survey of the major topics of the field., This lean, focused book concentrates on giving readers 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., * 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, GET ALL YOUR DUCKS IN A ROW!What does database management have to do with ducks? A lot more than you might think. Ducks Unlimited, the world's largest wetlands conservation organization, relies on a major relational database application to manage both the operational and financial aspects of its wetlands conservation projects.This is just one of the many exciting, real-world examples of database management you'll find in Mark Gillenson's FUNDAMENTAL OF DATABASE MANAGEMENT SYSTEMS. Offering a highly focused and applied approach, this new text will help you master the fundamentals of database management, so you can immediately apply what you've learned to real business situations.Features This compact, practical introduction emphasizes fundamental database concepts and presents them in a clear, easy-to-understand way. Coverage starts with basic concepts of data, and then proceeds in a step-by-step manner to present all of the major aspects of database management. A complete chapter covers data retrieval with SQL, which is applicable to Oracle, Microsoft Access, and all other relational database management systems. Every chapter starts with a short story, complete with a photo, of how real company use database for a real application. Throughout, the text makes heavy use of examples, including four major examples that are repeatedly used to drive home key concepts.