Seatwork Fundamental of Database (Relational Data Model)

IT IS SOMETHING OF IMPORTANCE TO A USER OR ORGANIZATION THAT NEEDS BE

REPRESENTED IN A DATABASE

• QUALITY

• SENSITIVITY

• ENTITY

• DURABILITY

A _____IS A TWO-DIMENTIONAL TABLE THAT HAS SPECIFIC

CHARACTERISTICS

• RELATIONSHIP

• RELATION

• DIMENSIONS

• ROWS

THESE ARE THE TWO TERMINOLOGIES FOR ROW

• RECORD

• FIELD

• FILE

• TUPLE

______ IS THE KEY THAT WILL UNIQUELY IDENTIFY A ROW.

• UNIQUE KEY

• NON-UNIQUE KEY

• SURROGATE KEY

• FOREIGN KEY

_____ IS THE KEY THAT WILL IDENTIFY A SET OF ROWS

• COMPOSITE KEY

• NON-UNIQUE KEY

• PRIMARY KEY

• UNIQUE KEY

A ____ IS A CANDIDATE KEY CHOSEN TO BE THE MAIN KEY FOR THE RELATION

• SURROGATE KEY

• PRIMARY KEY

• CANDIDATE KEY

• COMPOSITE KEY

A _____ KEY IS A UNIQUE, NUMERIC VALUE THAT IS ADDED TO A RELATION TO

SERVE AS THE PRIMARY KEY

• PRIMARY KEY

• COMPOSITE KEY

• SURROGATE KEY

• CANDIDATE KEY

_____ STATES THAT EVERY VALUE OF A FOREIGN KEY MUST MATCH A VALUE OF

AN EXISTING PRIMARY.

• INFERENTIAL INTEGRITY

• DEFERENTIAL INTEGRITY

• CONSEQUENTIAL INTEGRITY

• REFERENTIAL INTEGRITY

THIS IS DIFFERENT FROM ZERO, SPACE CHARACTER, EMPTY STRING, OR TAB

CHARACTER

• NULL HYPOTHESIS

• NULL DATA

• NULL VALUES

• NULL STRING

IT IS A RELATIONSHIP BETWEEN ATTRIBUTES IN WHICH ONE ATTRIBUTE

DETERMINES THE VALUE OF ANOTHER ATTRIBUTE

• FUNTIONAL DEPENDENCY

• RELATION

• COLUMN

• DATA