Question: Please give a True or a False rating to each statement below. You can add an explanation if you feel the question is ambiguous, but

Please give a True or a False rating to each statement below. You can add an explanation if you feel the question is ambiguous, but that is option in this part.
a. A schema that is in Third Normal Form (3NF) must also be in Second Normal Form (2NF).
b. A foreign key can contain a NULL.
c. The union rule allows combining functional dependencies ACD and AEF into a functional dependency ACDEF.
d. A UNIQUE constraint on a column allows insertion of a NULL.
e. A column that appears in the WHERE clause must always appear in the SELECT clause.
f. SQL query output is always sorted by the primary key.
g. You can never use a WHERE clause and a HAVING clause in the same query.
h. Queries that output the same results will always run at the same speed regardless of how they are written.
i. DISTINCT queries always return a different number of rows than just a SELECT query.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!