Introduction to Relational Databases
Study Questions Solved 100% Correct
one to one relationship - ANSWER occurs where for each instance of a table only one
instance of a corresponding table exists. vice versa.
one to many relationship - ANSWER where for each instance of a table many of the
respective could exist. but does not go the other way. an artist has many paintings.
many paintings one artist.
many to many relationships - ANSWER each instance of one table has equal many
of other and vice versa.
mandatory relationship - ANSWER each instance of first table one or more of another
exist. the reverse is not necessarily true.
optional relationship - ANSWER each instance of A there MAY be a B.
data integrity - ANSWER accuracy, validity, consistency of data.
database normalization - ANSWER technique that helps us to reduce the occurrence
of data anomalies and poor data integrity.
, key: explained - ANSWER a tool to unlock access to database tables. by knowing the
key we can locate specific records and traverse the relationships between tables.
candidate key - ANSWER any field or combo of that uniquely identifies a record. the
field of the candidate must contain unique values (no duplicates) and no null
primary key: explained - ANSWER a candidate key that has been chosen to identify
unique records in a particular table.
selecting a candidate key - ANSWER always better to choose the key that has the
least fields for the primary key.
Study Questions Solved 100% Correct
one to one relationship - ANSWER occurs where for each instance of a table only one
instance of a corresponding table exists. vice versa.
one to many relationship - ANSWER where for each instance of a table many of the
respective could exist. but does not go the other way. an artist has many paintings.
many paintings one artist.
many to many relationships - ANSWER each instance of one table has equal many
of other and vice versa.
mandatory relationship - ANSWER each instance of first table one or more of another
exist. the reverse is not necessarily true.
optional relationship - ANSWER each instance of A there MAY be a B.
data integrity - ANSWER accuracy, validity, consistency of data.
database normalization - ANSWER technique that helps us to reduce the occurrence
of data anomalies and poor data integrity.
, key: explained - ANSWER a tool to unlock access to database tables. by knowing the
key we can locate specific records and traverse the relationships between tables.
candidate key - ANSWER any field or combo of that uniquely identifies a record. the
field of the candidate must contain unique values (no duplicates) and no null
primary key: explained - ANSWER a candidate key that has been chosen to identify
unique records in a particular table.
selecting a candidate key - ANSWER always better to choose the key that has the
least fields for the primary key.