Consider the following SQL statement and the Orders relation shown in the exhibit:
What is the output of this SQL statement?
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 subset of Structured Query Language (SQL) is used to create and name database entities?
Consider the following relation definition:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL
Student_Number: integer NOT NULL
Building: variable length character string length 25 NOT NULL)
Primary Key Housing_ID
Foreign Key Student_Number References
STUDENT(Student_Number)
ON DELETE NO CHECK
ON UPDATE
Which integrity constraint is violated in this relation definition?
Which of the following best describes the two-tier database architecture?
The exhibit shows a table called Activity Relation that relates a unique student identification number with a sports activity and a fee for participating in that activity. A student can participate in only one activity. The key for the relation is Student_ID. What consequence would occur if the tuple for Student_ID 1001 were removed?
Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?
Which term describes the rejoining of relations that have been decomposed?
Which statement best describes a procedural data manipulation language command?
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?
