ISDS 3003 FINAL QUESTIONS & ANSWERS
Table - Answer -Relation
Table - Answer -File
Column - Answer -Field
Column - Answer -Attribute
Row - Answer -Record
Row - Answer -Tuple
Key - Answer -One or more columns of a relation that is used to identify a row
Unique Key - Answer -a key that identifies a unique row
Nonunique Key - Answer -a key that potentially identifies more than one row
Composite Key - Answer -a key that potentially identifies more than one row
Composite Key - Answer -Ex.: (LastName, Department)
Candidate Key - Answer -an attribute or a group of attributes that identifies a unique
row in a relation
One of the candidate keys is chosen to be the - Answer -Primary key
Primary Key - Answer -the candidate key that is chosen as the key that the DBMS will
use to uniquely identify each row in a a relation
Entity Integrity Constraint - Answer -the constraint that the primary key column or
columns must have unique values so that each row can be uniquely identified
Surrogate Key - Answer -column with a unique, DBMS-assigned identifier that has
been added to a tablet be the primary key
Ideal Primary Key - Answer -short and never changes
MySQL uses to automatically assign surrogate key numbers - Answer -
AUTO_INCREMENT
Identity - Answer -the attribute specification the tis used to create a surrogate key
, Identity Seed - Answer -starting value of the surrogate key
Identity Increment - Answer -amount that is added to each key value to create the next
key value
Foreign Key - Answer -an attribute or set of attributes that is a key of one or more
reactions other than the one in which it appears
Functional Dependency - Answer -a relationship between attributes in which one
attribute or group of attributes determines the value of another
Determinant - Answer -one or more attributes that functionally determine another
attribute or arrtibutes
Normalization - Answer -the process of (or set of steps for) breaking a table or relation
with one theme into a set if tables such that each has only one theme
Well-Formed Relation - Answer -a relation in which every determinant is a candidate
key
Recursive Relationship - Answer -a relationship among objects or rows of the same
type
Recursive Relationship - Answer -when a foreign key links to the primary key of the
same table
NOT NULL Constraint - Answer -indicates that a value must be supplied when a new
row is created
NULL Constraint - Answer -indicates that null values are allowed
VarChar(n) - Answer -variable-length character type
UNIQUE Constraint - Answer -indicates that there cannot be any duplicated values in
the column
Numeric (x, y) - Answer -data type that values consist up to x decimal digits, with y
digits assumed to the right of the decimal point
Foreign Key Constraint - Answer -a data constraint between 2 tables requiring that
before a data value can be inserted into a foreign key column, the data value must
already exist in the associated primary key column
5 Component Information System Framework - Answer -1. Hardware
2. Software
3. Data
Table - Answer -Relation
Table - Answer -File
Column - Answer -Field
Column - Answer -Attribute
Row - Answer -Record
Row - Answer -Tuple
Key - Answer -One or more columns of a relation that is used to identify a row
Unique Key - Answer -a key that identifies a unique row
Nonunique Key - Answer -a key that potentially identifies more than one row
Composite Key - Answer -a key that potentially identifies more than one row
Composite Key - Answer -Ex.: (LastName, Department)
Candidate Key - Answer -an attribute or a group of attributes that identifies a unique
row in a relation
One of the candidate keys is chosen to be the - Answer -Primary key
Primary Key - Answer -the candidate key that is chosen as the key that the DBMS will
use to uniquely identify each row in a a relation
Entity Integrity Constraint - Answer -the constraint that the primary key column or
columns must have unique values so that each row can be uniquely identified
Surrogate Key - Answer -column with a unique, DBMS-assigned identifier that has
been added to a tablet be the primary key
Ideal Primary Key - Answer -short and never changes
MySQL uses to automatically assign surrogate key numbers - Answer -
AUTO_INCREMENT
Identity - Answer -the attribute specification the tis used to create a surrogate key
, Identity Seed - Answer -starting value of the surrogate key
Identity Increment - Answer -amount that is added to each key value to create the next
key value
Foreign Key - Answer -an attribute or set of attributes that is a key of one or more
reactions other than the one in which it appears
Functional Dependency - Answer -a relationship between attributes in which one
attribute or group of attributes determines the value of another
Determinant - Answer -one or more attributes that functionally determine another
attribute or arrtibutes
Normalization - Answer -the process of (or set of steps for) breaking a table or relation
with one theme into a set if tables such that each has only one theme
Well-Formed Relation - Answer -a relation in which every determinant is a candidate
key
Recursive Relationship - Answer -a relationship among objects or rows of the same
type
Recursive Relationship - Answer -when a foreign key links to the primary key of the
same table
NOT NULL Constraint - Answer -indicates that a value must be supplied when a new
row is created
NULL Constraint - Answer -indicates that null values are allowed
VarChar(n) - Answer -variable-length character type
UNIQUE Constraint - Answer -indicates that there cannot be any duplicated values in
the column
Numeric (x, y) - Answer -data type that values consist up to x decimal digits, with y
digits assumed to the right of the decimal point
Foreign Key Constraint - Answer -a data constraint between 2 tables requiring that
before a data value can be inserted into a foreign key column, the data value must
already exist in the associated primary key column
5 Component Information System Framework - Answer -1. Hardware
2. Software
3. Data
