Which relational algebraic operation is used to select specific columns (attributes) from a relation?
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 NULLName: variable length character string length 20)Primary Key Student_Number -HOUSING(Housing_ID: integer NOT NULL -Student_Number: integer NOT NULLBuilding: 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?
