{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 5 Notes - DataResource Management Chapter5...

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

View Full Document Right Arrow Icon
Data Resource  Management Chapter 5 Instructed By Jing Yang
Background image of page 1

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

View Full Document Right Arrow Icon
Learning Objectives Principles of Information Systems, Fifth Edition Definition of Database Comparison between traditional DBMT and contemporary DBMT Data Modeling and Database Models Database Basics Database Management
Background image of page 2
Fundamental Data Concepts Character Single alphabetic, numeric, or other symbol Field or data item Attribute (characteristic or quality) of some entity (object, person, place, event) Record Grouping of all the fields about an entity File A table or flat file Database An integrated collection of logically related data elements
Background image of page 3

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

View Full Document Right Arrow Icon
Key field, Entity and Attribute
Background image of page 4
For example…
Background image of page 5

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

View Full Document Right Arrow Icon
Electric Utility Database
Background image of page 6
The Traditional versus the Database Approach  to Data Management
Background image of page 7

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

View Full Document Right Arrow Icon
Fig 5.3
Background image of page 8
Problems with the “Traditional” Approach Data redundancy Program-data dependence Inflexibility
Background image of page 9

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

View Full Document Right Arrow Icon
Fig 5.4
Background image of page 10
The advantages of Database Approach
Background image of page 11

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

View Full Document Right Arrow Icon
Table 5.2
Background image of page 12
Data Modeling & Database Models
Background image of page 13

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

View Full Document Right Arrow Icon
Data Design Issues Content: What data should be collected? Access: What data should be given to what users? Logical structure: How will the data be organized to make sense to a particular user? Physical organization: Where will the data actually be located?
Background image of page 14
Data Modeling Logical design shows how data are grouped together and how that are related to one another, in a way that makes sense to users Physical design involves combining or splitting some of the groups identified in the logical design, deciding to maintain summary data in the database, and intentionally storing a data item more than one time. Planned data redundancy is done to improve system performance so that users can get information more quickly Data model a diagram used by a database designer to show the logical relationships among the entities in the database
Background image of page 15

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

View Full Document Right Arrow Icon
Entity-Relationship (ER) Diagrams Fig 5.5
Background image of page 16
Database Models Hierarchical Structure Network Structure Relational Structure Object-oriented Structure Multidimensional Structure
Background image of page 17

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

View Full Document Right Arrow Icon
Hierarchical Structure Principles of Information Systems, Fifth Edition A hierarchical database model is a data model in which the data is organized into a tree-like structure. The structure allows representing information using parent/child relationships : each parent can have many children, but each child has only one parent (also known as a 1-to-many relationship ). All attributes of a specific record are listed under an entity type.
Background image of page 18
For example…
Background image of page 19

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

View Full Document Right Arrow Icon
Network Structure The network model is a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.
Background image of page 20
Image of page 21
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}