First Test

Question 0

Referential integrity

Answer 0

A foreign key in one table has to be a primary key in another table

Question 1

Foreign key

Answer 1

Primary key in another table

Question 2

Entity integrity

Answer 2

Every table has to have a primary key and the primary key cannot be null

Question 3

Derived attribute

Answer 3

An attribute need not be physically stored within the database

Question 4

Cardinality

Answer 4

Specific number of entity occurrences

Question 5

ER diagram

Answer 5

Represents the conceptual database as viewed by the end user

Question 6

Composite key

Answer 6

A primary key composed of more than one attribute

Question 7

Recursive relationship

Answer 7

When an entity is related to itself

Question 8

Primary key

Answer 8

A unique key that cannot contain a null value and relates to the other keys in the table

Question 9

Candidate key

Answer 9

Any columns or combo of columns that can qualify as a unique key in the database.

Basically candidate keys can qualify as primary keys

Question 10

Secondary key

Answer 10

Candidate keys that were not selected as the primary key

Question 11

Alternate key

Answer 11

Any of the candidate keys that is not part of the primary key

Question 12

Domain

Answer 12

A parameter of an attribute

Example: months 1-12

Question 13

Business rule

Answer 13

A rule set up arbitrarily

Question 14

Relationship

Answer 14

Between entities that are related in a 1-1 1-many or many-many

Links entities through PK and FK

Question 15

Entity

Answer 15

Person, place, or thing in which data can be collected

Question 16

Attributes

Answer 16

Describes the facts, details, or characteristics of an entity

Question 17

Hierarchical model

Answer 17

Developed by IBM in 1960

Question 18

Network model

Answer 18

Also called the codasyl model

Question 19

Relational model

Answer 19

Uses the repetition of unique identifying info to link data

Question 20

Object oriented model

Answer 20

Emerging technology that bundles data and processes

Question 21

Legacy system

Answer 21

Older system that would no longer be used for new development

Question 22

Super key

Answer 22

An attribute or combination of attributes that uniquely identifies each row in a table