Rent Textbook
New Textbook
We're Sorry
Sold Out
Used Textbook
We're Sorry
Sold Out
eTextbook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Table of Contents
| Preface | |
| Introduction | |
| THE SOFTWARE ENGINEERING PROCESS AND RELATIONAL DATABASES | |
| What is the software engineering process? | |
| ER Diagrams and the Software Engineering Life Cycle | |
| Data Models | |
| Functional Dependencies | |
| A Brief Look at Normal Forms | |
| Summary of Chapter | |
| Exercises for Chapter 1 | |
| References | |
| THE BASIC ER DIAGRAM ? A DATA MODELING SCHEMA | |
| What is a data modeling schema? | |
| Defining the database ? some definitions: entity, relationship, attribute | |
| A Beginning Methodology | |
| ER Design Methodology | |
| A First "Entity only" ER Diagram | |
| More about Attributes | |
| English Description of the Entity | |
| Mapping the Entity Diagram to a Relational Database | |
| Summary of Chapter | |
| Exercises for Chapter 2 | |
| References | |
| Case Study | |
| BEYOND THE FIRST ENTITY DIAGRAM | |
| Examining an Entity - Changing An Attribute to be an entity | |
| Defining a relationship for our new entity | |
| A Preliminary Grammar for the ER diagrams | |
| Defining a Second Entity | |
| Does a Relationship Exist? | |
| Attribute or relationship? | |
| Summary of Chapter | |
| Exercises for Chapter 3 | |
| References | |
| Case Study | |
| EXTENDING RELATIONSHIPS/STRUCTURAL CONSTRAINTS | |
| The Cardinality Ratio of a Relationship | |
| Participation - Full/Partial | |
| English Descriptions | |
| Tighter English | |
| Some examples of other relationships | |
| One Final Example | |
| Exercises for Chapter 4 | |
| References | |
| Case Study | |
| THE WEAK ENTITY | |
| Strong and Weak Entities | |
| Weak Entities and Structural Constraints | |
| Weak Entities and the Identifying Owner | |
| Weak Entities connected to other Weak Entities | |
| Revisiting the Methodology | |
| Weak Entity Grammar | |
| Mapping Weak Entities to a relational database | |
| Summary of Chapter | |
| Exercises for Chapter 5 | |
| Reference | |
| Case Study | |
| Further Extensions for ER Diagrams with Binary Relationships | |
| Attributes of Relationships | |
| Relationships developing into Entities: The M:N Relationship Revisited | |
| More Entities and Relationships | |
| More Evolution of the Database | |
| Attributes That Evolve into Entities | |
| Recursive Relationships | |
| Multiple Relations | |
| The Derived or Redundant Relation | |
| An alternative ER Notation for specifying Structural Constraints on Relationships | |
| Review of the Methodology | |
| Mapping rules for Recursive Relationships | |
| Summary of Chapter | |
| Exercises for Chapter 6 | |
| References | |
| Case Study | |
| TERNARY AND HIGHER ORDER ER DIAGRAMS | |
| Binary or Ternary Relationship? | |
| Ternary Relationships and Structural Constraints | |
| n-ary Relations do not preclude binary relations | |
| Methodology and Grammar for the n-ary Relationship | |
| Ternary Relationships from relationship-relationship situations | |
| n-ary Relationships May be Resolved into Binary Relationships | |
| Mapping to ternary diagrams to a relational database | |
| Summary of Chapter | |
| Exercises for Chapter 7 | |
| References | |
| GENERALIZATIONS AND SPECIALIZATIONS | |
| What is a Generalization or Specialization? | |
| A Problem with Variants | |
| Example of a Generalization/Specialization | |
| Methodology and Grammar in Generalization/Specialization relationships | |
| Mapping rules for EER Diagrams | |
| Summary of Chapter | |
| Exercises for Chapter 8 | |
| References | |
| Case Study | |
| RELATIONAL MAPPING AND REVERSE ENGINEERING ER DIAGRAMS | |
| Steps used to map an ER diagram to a Relational Database | |
| Reverse Engineering | |
| Summary of Chapter | |
| References | |
| A BRIEF OVERVIEW OF THE BARKER/ORACLE-LIKE MODEL | |
| A First "Entity only" ER Diagram - An Entity with Attributes | |
| Attributes in the Barker/Oracle-like model | |
| Relationships in the Barker/Oracle-like model | |
| Structural constraints in the Barker/Oracle-like model | |
| Dealing with the concept of the weak entity in the Barker/Oracle-like model | |
| Dealing with the concept of multivalued attributes in the Barker/Oracle-like model | |
| Treatment of Foreign keys | |
| Recursive relationships in the Barker/Oracle-like model | |
| Mapping M:N relations | |
| Summary of Chapter | |
| Exercises for Chapter 10 | |
| References | |
| Glossary | |
| Index |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.