Consider the Information Engineering diagram in the exhibit showing a conceptual data model of
the relations BUILDING and RESIDENT. What is the next step in refining the data model?

Which of the following best describes the information contained in the data dictionary (or system
catalog)?

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 characteristic is an advantage of a database management system?

Consider the Stu_Act and Act_Fee tables shown in the exhibit. Which relational algebraic
operation would yield the Activity Relation table in the exhibit?

A foreign key maps to a:

Which security technique limits access by unauthorized users to parts of an enterprise database?

Which of the following ACID properties requires that a transaction be executed in its entirety or not
all?

To create a view, what are the minimal privileges that a user must have for the relations used to
make the view?

Which database security technique prevents invalid data from being entered into the database?