02010_ch02 - Database Systems: Design, Implementation, and...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Database Systems, 8 th Edition Database Systems: Design, Implementation, and Management Eighth Edition Chapter 2 Data Models
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Database Systems, 8 th Edition Objectives About data modeling and why data models are important About the basic data-modeling building blocks What business rules are and how they influence database design How the major data models evolved How data models can be classified by level of abstraction
Background image of page 2
3 Database Systems, 8 th Edition Introduction Designers, programmers, and end users see data in different ways Different views of same data lead to designs that do not reflect organization’s operation Data modeling reduces complexities of database design Various degrees of data abstraction help reconcile varying views of same data
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Database Systems, 8 th Edition Data Modeling and Data Models Data models 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
Background image of page 4
5 Database Systems, 8 th Edition The Importance of Data Models Facilitate interaction among the designer, the applications programmer, and the end user End users have different views and needs for data Data model organizes data for various users Data model is an abstraction Cannot draw required data out of the data model
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Database Systems, 8 th Edition Data Model Basic Building Blocks Entity: anything about which data are to be collected and stored Attribute: a characteristic of an entity Relationship: describes an association among entities One-to-many (1:M) relationship Many-to-many (M:N or M:M) relationship One-to-one (1:1) relationship Constraint: a restriction placed on the data
Background image of page 6
7 Database Systems, 8 th Edition Business Rules Descriptions of policies, procedures, or principles within a specific organization Apply to any organization that stores and uses data to generate information Description of operations to create/enforce actions within an organization’s environment Must be in writing and kept up to date Must be easy to understand and widely disseminated Describe characteristics of data as viewed by the company
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 Database Systems, 8 th Edition Discovering Business Rules Sources of business rules: Company managers Policy makers Department managers Written documentation Procedures Standards Operations manuals Direct interviews with end users
Background image of page 8
9 Database Systems, 8 th Edition Discovering Business Rules (continued) Standardize company’s view of data Communications tool between users and designers Allow designer to understand the nature, role, and scope of data Allow designer to understand business processes Allow designer to develop appropriate relationship participation rules and constraints
Background image of page 9

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

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Page1 / 50

02010_ch02 - Database Systems: Design, Implementation, and...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online