chapter2 part1 - Outline Chapter 2 Data modeling Their...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Chapter 2 Data Models part 1 BUS 173 Winter 2011 Dr. Hamouda 2 Outline Data modeling Their importance Basic data-modeling building blocks Business rules They influence on database design History of data models Classification of data models based on their level of abstraction 3 Introduction Designers, programmers, and end users see data in different ways Diverse groups of users Difficult to obtain acceptance of a common vocabulary Different views of same data lead to designs that do not reflect organization’s operation Marketing Customer buying habit Customer buying motivation call planning Accounting Assets Liabilities ledgers Production Inventory Lead time Customer order 4 Introduction Compromise to find least objectionable solution Unify organization by establishing a common vocabulary This is achieved through data abstraction and modeling Data modeling reduces complexities of database design Various degrees of data abstraction help reconcile varying views of same data 5 Data Modeling and Data Models Data models (blueprint) Relatively simple representations of complex real-world data structures Often graphical Model: an abstraction of a real-world object or event Useful in understanding complexities of the real-world environment Data modeling is iterative and progressive 6 Data Model A data model should contain the following components: A description of the data structure that will store the end-user data A set of enforceable rules to guarantee the integrity of the data A data manipulation methodology to support the real world data transformation
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon