Sophia Intro To Relational Databases Final Milestone Verified Study Questions And Answers Updated Solutions

Sophia Intro To Relational Databases Final Milestone
Verified Study Questions And Answers Updated
Solutions

, lOMoAR cPSD| 7670600




MILESTONE 18/25

RETAKE
18/25 that's 72%




1●

Which of these statements is true about 4NF?



It breaks tables down into as many
tables as possible to avoid
●
redundancy.



It is focused on eliminating join
● dependencies.



It creates multivalued
● dependencies.



It should already satisfy the
properties of BCNF.




RATIONALE

A database is in 4NF if it already satisfies the properties of BCNF and
there are no multivalued dependencies. 4NF eliminates multivalued
dependencies; it does not create them.

, lOMoAR cPSD| 7670600




18/25

CONCEPTMILESTONE
→ Higher Normalization



2●

Which of the following statements would be a valid DROP VIEW
statement to remove the two views, display an error if either view does
not exist, and drop any dependent objects?




DROP VIEW IF EXISTS album_cost,
●




DROP VIEW album_cost, album_arti
●




DROP VIEW album_cost AND album_a

, lOMoAR cPSD| 7670600




MILESTONE 18/25




DROP VIEW album_cost, album_arti




RATIONALE

The correct syntax for this query does not use IF EXISTS (because that
would suppress the error if the views do not exist). It uses CASCADE to
drop any dependencies. It separates the view names with a comma, not
with AND.


CONCEPT
→ DROP VIEW to Remove Views



3●

Which normal form looks for atomicity issues in individual tables?



1NF




None of the first three normal forms
●



3NF
●



2NF