Is441 Definitions Fill It Blank Exam 1

Front 1

Simple Attribute: An attribute that ____ be broken into small ___

Back 1

cannot, component

Front 2

Composite Attribute: An attribute that ___ be broken down into smaller ____.

Back 2

can, component

Front 3

Single Valued Attribute: An attribute that can take on _____ value for a give entity _____

Back 3

only one, instance

Front 4

Multi-Valued Attribute: An attribute that __ take on __ value for a given entity ____

Back 4

may, multiple, instance

Front 5

Derived Attribute: An attribute whose value can be ____ from related attribute value.

Back 5

computed calculated

Front 6

Primary Key: An attribute (or combination of attribute) that ___ ___ .

Back 6

unique, identified

Front 7

Composite Primary Key: A primary key that consists of a ___ of attribute.

Back 7

combination

Front 8

Foreign Key: An attribute in one table that matches the ___ of another table.

Back 8

primary key

Front 9

Candidate Key: An attribute of combination of attributes that ___ served as a primary key, but was not selected to e the primary key.

Back 9

could have

Front 10

Surrogate Key: A table identifier that is ___ by the data modeler.

Back 10

make up

Front 11

Entity Integrity: When all of rows of a database table are ____ .

Back 11

unique id

Front 12

Referential Integrity: When all the foreign key in one table either ___ the primary key value in the related table or are ___ .

Back 12

match, null

Front 13

A meaningful association between__ Type

Back 13

3

Front 14

Connectivity: Describe the mapping of associated ____ in a relationship. The possible values of connectivity are __ and ___

Back 14

entity instance, one, many

Front 15

1:1 :A record in one entity is related to a ____ of ___ records in another entity.

Back 15

maximum, one

Front 16

1:M : A record in one entity is related to a ___ of ___ records in another entity.

Back 16

maximum, many

Front 17

M:N :Individual record ___ side of relationship can be related to ___ records on the other side of the relationship.

Back 17

each, many

Front 18

Cardinality Constraint: Specifies both ___ and ___ number of instances of entity B that can be associated with each instance of entity A.

Back 18

maximum, minimum

Front 19

Degree: The ___ of entity type that participate in a realtionship

Back 19

number

Front 20

Unary: a relationship between the instances of a ___ entity type.

Back 20

single

Front 21

Binary: A relationship between the instances of ___ entity types

Back 21

double

Front 22

Ternary: A simultaneous relationship among the instances of ___ entity types.

Back 22

triple

Front 23

Strength: Whether or not an entity type can exist independently of other entity types.
If an entity type can exit independently of their entity type it is called ___ enity type, if it cannot, it is call a ___ entity type
___ entiy type do not have identifiers of there own, they share the identifier of there ___
The relationship between a ___ entity type and its owner is call a(n) ____ relationship.

Back 23

strong, weak, strong, owner, weak, identifying.