Which of the following occurs in a relation when records are added or removed?
Which of the following occurs in a relation when records are added or removed?
Which situation would occur if new supplier information were entered in the relation before any information ab
Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers.
Which situation would occur if new supplier information were entered in the relation before any information about specific parts?
which types of relationships?
The creation of intermediate entities occurs during the logical database design phase for an
enterprise. It is used to resolve which types of relationships?
Which database protection technique should be employed?
Your enterprise is developing a database system that will contain highly sensitive data. Security of
the data will take priority over database processing speed. Which database protection technique
should be employed?
which normal form?
The exhibit shows a table called Housing Relation that relates a unique student identification
number with a dormitory building and a room fee for that building. Each building charges only one
fee and a student can live in only one building. The key for the Housing Relation is Student_ID.
This table is in which normal form?
Which candidate key(s) would best serve as the primary key for this relation?
The exhibit shows a relation for a company projects.
Which candidate key(s) would best serve as the primary key for this relation?
Which of the following best describes a composite key?
Which of the following best describes a composite key?
which phase of the database design process would this information be developed?
Consider the following database information:
domain s_id: integer domain grd: fixed length
character string length 1
STUDENT_GRADE(
Student_Number: s_id NOT NULL
Grade: grd ) Primary Key
Student_Number
During which phase of the database design process would this information be developed?
Which SQL statement or statements would best accomplish this?
Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for
Student_ID 1003 must be performed. It is necessary to change one of the activities from
swimming to tennis. The Student_ID and Activity attributes make up the primary key for the
Recreation relation. All related information must be altered, as well. Which SQL statement or
statements would best accomplish this?
Which process is used to prevent the current database operation from reading or writing a data item while that
Which process is used to prevent the current database operation from reading or writing a data
item while that data item is being accessed by another operation?