DATABASE MANAGEMENT - Chapter 2 Week 3 - (DATA MODELS)

Iterative and progressive process of creating a specific data model for a determined problem domain

• Data

• Data modeling

• Data models

• Models

Simple representations of complex real-world data structures

• Data models

• Model

• Data modeling

• Data

Abstraction of a real-world object or event.

• Abstract Model

• Data models

• Model

• Data modeling

Useful for supporting a specific problem domain.

• Model

• Data

• Data models

• Data modeling

What are the importance of Data Models?

• Are a communication tool

• Are an abstraction for the creation of good database

• Organize data for various users

• Give an overall view of the database

Unique and distinct object used to collect and store data

• Data

• Entity

• Relationship

• Contraint

Characteristic of an entity

• Entity

• Relationship

• Attribute

• Constraint

Describes an association among entities

• Attribute

• Data model

• Constraint

• Relationship

Set of rules to ensure data integrity

• Data integrity

• Constraint

• Attribute

• Entity

Relationships can be

• One-to-many (1:M)

• Many-to-many (M:N or M:M)

• One-to-one (1:1)

• Many-to-one (M:1)

• All of the above