Data Models Flashcards

1
Q

Data modeling

A

The process of creating a specific data model for a determined problem domain.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data model

A

A representation, usually graphic, of a complex “real-world” data structure

Data models are used in the database design phase of database life cycle.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The importance of data models

A

Data models can facilitate interaction among the designer, the applications progammer, and the end user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

entity

A

A person, place, thing, concept, or event for which data can be stored.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

attribute

A

A characteristic of an entity or object.

an attribute has a name and a data type.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

relationship

A

An association between entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

One-to-many(1:M) relationship

A

Associations among two or more entites that are used by data

In a 1:M relationship, one entity instance is associated with many instances of the related entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

many-to-many relationship(M:N)

A

Association among two or more entities in which one occurrence of an entity is associated with many occurrences of a related entity is associated with many occurences of the first entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

one-to-one(1:1) relationship

A

In a 1:1 relationship, one entity instance is associated with only one instance of the related entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly