Which characteristic is an advantage of a database management system?
Which characteristic is an advantage of a database management system?
What are the referential constraints for the relations defined in these relation definitions?
Consider the following relation definitions:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 )
Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL
Student_Number: integer NOT NULL
Building: variable length character string length 25 ) Primary Key Housing_ID
Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION
ON UPDATE CASCADE
What are the referential constraints for the relations defined in these relation definitions?
Which of the following best describes the information contained in the data dictionary (or system catalog)?
Which of the following best describes the information contained in the data dictionary (or system catalog)?
Which relational algebraic operation is used to select specific columns (attributes) from a relation?
Which relational algebraic operation is used to select specific columns (attributes) from a relation?
Which of the following describes two desirable characteristics of a primary key?
Which of the following describes two desirable characteristics of a primary key?
which data records are stored in one or more files with no structured relationship?
Which term best defines a database system in which data records are stored in one or more files with no structured relationship?
Which of the following best describes the two-tier database architecture?
Which of the following best describes the two-tier database architecture?
Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?
Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?
Which of the following is a characteristic of the three-tier database architecture?
Which of the following is a characteristic of the three-tier database architecture?
Which statement best describes a candidate key?
Which statement best describes a candidate key?