ITM500 Chapter Notes - Chapter 2: Database Model, Nosql, Data Definition Language

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM500
• Professor: All

Document Summary

Database design focuses on how the database structure will be used to store and manage end-user data. Data modeling: the process of creating a specific data model for a determined problem domain. Data model: a representation, usually graphic, of a complex real-world data structure. Data models are used in the database design phase of the database life cycle. Data models can facilitate interaction among the designer, the applications programmer, and the end user. The basic building blocks of all data models are entities, attributes, relationships, and constraints. Entity: a person, place, thing, concept, or event for which data can be stored. Attribute: a characteristic of an entity or object. An attribute has a name and a data type. The following examples illustrate the distinctions among the three relationships: one-to-many (1:m or 1*) relationship: associations among two or more entities that are used by data models.