ITM 500 Chapter Notes - Chapter 2: Database Model, Database Design, Data Management

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 500
• Professor: Upal Nath

Document Summary

Data modeling: the process of creating a specific data model for a determined problem domain. Data model: a simple representation, usually graphic, of a complex real-world" data structure: used in database design phase of the database life cycle. Model: abstraction of a real-world object or event. Problem domain: a clearly defined area within the real-world environment with a well-defined scope and boundaries that will be systematically addressed. Importance of data models: are a communication tool, give an overall view of the database, organize data for various users, are an abstraction for the creation of good database. Entity: a person, place, thing, concept or event for which data can be stored; distinguishable. Attribute: a characteristic of an entity or object; has a name and data type. Relationship: an association between entities: one-to-many (1:m or 1*) relationship, many-to-many (m:n or **) relationship, one-to-one (1:1 or 11) relationship. Constraint: a restriction placed on data, usually expressed in the form of rules.