Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ISB 22C > Data Modeling > Flashcards

Data Modeling Flashcards

1
Q

A good business rule is:

A

(1) declarative
(2) precise
(3) atomic
(4) consistent
(5) expressible
(6) distinct
(7) business-oriented

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

A good data name is:

A

(1) related to business
(2) meaningful and self-documenting
(3) unique
(4) readable
(5) composed of words from an approved list
(6) repeatable

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

A logical representation of the data from an organization or for a business area, using entities for categories of data and relationships for associations between entities

A

ENTITY-RELATIONSHIP MODEL

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

A graphical representation of an entity-relationship model

A

ENTITY-RELATIONSHIP DIAGRAM

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

A person, a place, an object, an event, or a concept in the user environment about which the organization wishes to maintain data

A

ENTITIES

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

Person, place, object, event, concept (corresponds to a row in a table)

A

ENTITY INSTANCE

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

Collection of entities (corresponds to a table)

A

ENTITY TYPE

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

Link between entities

A

RELATIONSHIP INSTANCE

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

Category of relationship, link between entity types

A

RELATIONSHIP TYPE

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

Property or characteristic of an entity or relationship type

A

ATTRIBUTE

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

Often corresponds to a field in a table

A

ATTRIBUTE

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

Entity is an object that will have many instances in the database.

A

TRUE

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

Entity is an object that will be composed of multiple attributes. T or F?

A

TRUE

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

Entity is an object that we are trying to model

A

TRUE

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

Entity is a user of the database system

A

FALSE

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

Entity is an output of the database system.

A

FALSE

17
Q

Property or characteristic of an entity or relationship type

A

ATTRIBUTE

18
Q

An attribute that has meaningful component parts

A

COMPOSITE ATTRIBUTE

19
Q

An attribute that cannot be broken down into smaller components that are meaningful to the organization

A

SIMPLE (OR ATOMIC) ATTRIBUTE

20
Q

An attribute that may take on more than one value for a given entity (or relationship instance)

A

MULTIVALUED ATTRIBUTE

21
Q

An attribute whose values can be calculated from related attribute values

A

DERIVED ATTRIBUTE

22
Q

An attribute (or a combination of attributes) that uniquely identifies individual instances of an entity type

A

IDENTIFIER (KEY)

23
Q

An attribute that could be a key, satisfies the requirements for being an identifier

A

CANDIDATE IDENTIFIER

24
Q

This relationship exist between tables when only one record of the first table is related to only one record on the second table

A

ONE-TO-ONE RELATIONSHIP

25
Q

This relationship exist between tables when one record of the first table can be related to one or more records to a second table

A

ONE-TO-MANY RELATIONSHIP

26
Q

This relationship exists between tables when one record of the first table can be related to one or more records to a second table or vice versa

A

MANY-TO-MANY RELATIONSHIP

27
Q

Relationships are the glue that holds together the various components of an E-R model

A

MODELING RELATIONSHIPS

28
Q

A meaningful association between (or among) entity types

A

RELATIONSHIP TYPE

29
Q

An association between (or among) entity instances where each relationship instance associates exactly one entity instance from each participating entity type

A

RELATIONSHIP INSTANCE

30
Q

An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances

A

ASSOCIATIVE ENTITY

31
Q

How do you know whether to convert a relationship to an associative entity type?

A
  • All the relationships for the participating entity types are “many” relationships
  • The resulting associative entity type has independent meaning to end users and, preferably, can be identified with a single-attribute identifier
  • The associative entity has one or more attributes in addition to the identifier
  • The associative entity participates in one or more relationships independent of the entities related in the associated relationship
32
Q

The number of entity types that participate in that relationship

A

DEGREE OF RELATIONSHIP

33
Q

Relationship between the instances of a single entity type

A

UNARY RELATIONSHIP

34
Q

Relationship between the instances of two entity types.

The most common type of relationship encountered in data

A

BINARY RELATIONSHIP

35
Q

Simulataneous relationship among instances of three entity types

A

TERNARY RELATIONSHIP

36
Q

Recursive relationships

A

UNARY RELATIONSHIP

37
Q

A rule that specifies the number of instances of one entity that can be associated with each instance of another entity

A

CARDINALITY CONSTRAINT

38
Q

The minimum number of instances of one entity that may be associated with each instance of another entity

A

MINIMUM CARDINALITY

39
Q

The maximum number of instances of one entity that may be associated with each instance of another entity

A

MAXIMUM CARDINALITY

ISB 22C (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions