Consider the Project relation shown in the exhibit as well as the following SQL statement:
DELETE FROM Project WHERE Cust_Name = Acme;
Which of the following tables shows the Project relation after execution of this SQL statement?
Correct Answer:A
What is a relational database domain?
Correct Answer:D
Which statement accurately describes a characteristic of attributes?
Solution:
Does this meet the goal?
Correct Answer:A
Which term describes the rejoining of relations that have been decomposed?
Correct Answer:B
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?
Correct Answer:C