Data Modeling EssentialsWritten by leading practitioners, this guide to data analysis, design and innovation is a tutorial and reference for systems analysts, business analysts, specialist data modelers, database designers, and students requiring a practical understanding of a project. It includes many practical examples to illustrate choices available to modelers and criteria for selecting the best model. The book explores the difference between modeling business data requirements and designing and maintaining the resulting database, including the impact of universal server and data distribution. A revision of the first successful edition published by Coriolis in 1994, this book contains numerous updates and additional chapters to illustrate real world data modeling for commercial information systems. |
Contents
What is Data Modeling? | 3 |
Basic Normalization | 35 |
The EntityRelationship Approach | 67 |
Copyright | |
13 other sections not shown
Other editions - View all
Common terms and phrases
allocated allow application approach attribute basic BCNF Branch business rules candidate key Chapter classify Client Code columns common complex concepts constraints convention corporate data model corporate model Customer data management data marts data structure data warehouse database management systems datatype Date DBMS definition delete denormalization diagram discussed Employee Number enforce entity instance Entity-Relationship Model example Figure foreign key function model handle hierarchy Hospital Number identify implement important information systems involve logical database design look look-up table many-to-many relationships nontransferable Normal Form one-to-many relationships one-to-one relationships Operation Number Operation Type option performance Person physical database designer Policy primary key problem Product program logic Qualification queries real world record redundancy referential integrity repeating group represent requirements result Salesperson self-referencing Share Holding specify subject areas subtypes and supertypes Surgeon Number surrogate keys technique third normal form transaction transferable update users usually weak entity