M2

Question 1

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

Answer 1

Entity instance–

Question 2

collection of entities (often corresponds to a table)

Answer 2

Entity Type–

Question 3

link between entities (corresponds to primary key- foreign key equivalencies in related tables)

Answer 3

Relationship instance–

Question 4

category of relationship…link between entity types

Answer 4

Relationship type–

Question 5

Properties or characteristics of an entity or relationship type (often corresponds to a field in a table)

Answer 5

Attributes

Question 6

specify how many of each entity type is allowed

Answer 6

Relationship cardinalities

Question 7

specify number of entity types involved

Answer 7

Relationship degrees

Question 8

Entities are represented by X

X go in the softboxes

Entity names are always X and X

Answer 8

softboxes

Entity names

singular

written in capital letters

Question 9

are listed under entity names

Answer 9

Attributes

Question 10

X are marked with an asterisk: “*”

X are marked with a circle: “o”

X are marked with a hash sign: “#”

Answer 10

Mandatory attributes

Optional attributes

Unique identifiers

Question 11

Business Rules

• Are statements that X or X some aspect of the business
• Are X from policies, procedures, events, functions
• Assert X
• X business behavior
• Are expressed in terms X to end-users
• Are X through DBMS software

Answer 11

define,,, constrain

derived

business structure

Control/influence

automated

Question 12

A good business rule is:

• X–what, not how
• X–clear, agreed-upon meaning
• X–one statement
• X–internally and externally
• X–structured, natural language
• X–non-redundant
• X–understood by business people

Answer 12

• Declarative–what, not how
• Precise–clear, agreed-upon meaning
• Atomic–one statement
• Consistent–internally and externally
• Expressible–structured, natural language
• Distinct–non-redundant
• Business-oriented–understood by business people

Question 13

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

Answer 13

Entity

Question 14

a collection of entities that share common properties or characteristics

Answer 14

Entity type –

Question 15

A single occurrence of an entity type

Answer 15

Entity instance –

Question 16

property or characteristic of an entity or relationship type

Answer 16

Attribute

Question 17

X entity
• exists X of other types of entities
• has its own X identifier
• identifier underlined with X line

Answer 17

Strong

independently

unique

single

Question 18

X entity
• dependent on a X (identifying owner)…cannot exist on its own
• does not have a unique identifier (only a X)
• entity box and partial identifier have X lines

Answer 18

Weak

strong entity

partial identifier

double

Question 19

links strong entities to weak entities

Answer 19

Identifying relationship

•

Question 20

Naming Attributes

• Name should be a X noun or noun X
• Name should be X
• Name should follow a X
• e.g. [Entity type name { [ Qualifier ] } ] Class
• Similar attributes of different entity types should use the
X

Answer 20

singular,,, phrase

unique

standard format

same qualifiers and classes