b. Lossless join decomposition must be achieved at all times.c. Functional Dependencies are a kind of integrity constraints.d. BCNF is not always achievable.
FeedbackYour answer is correct.The correct answer is: Dependency preserving implies lossless join and vice-versa.Question5IncorrectMark 0.00 out of 1.00Flag questionQuestion textConsider a relation that doesn’t include multivalued attributes and non-key attributes in thisrelation dependent on the primary key. However, this relation contains transitivedependencies. What is the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF)?Select one:a. 1NFb. 2NFc. 3NFd. BCNFFeedbackYour answer is incorrect.The correct answer is: 2NFQuestion6IncorrectMark 0.00 out of 1.00Flag questionQuestion textRelations should always be normalized to the highest normal form possible.
Select one:TrueFalseFeedbackThe correct answer is 'False'.Question7IncorrectMark 0.00 out of 1.00Flag questionQuestion textConsider the following table that shows the Movie relation. In the relation, {Movie_Title,Year} form a candidate key. Which of the following is correct about this Movie relation?Movie_Title YearTypeDirectorDirector_DOActorsNotting Hill1999RomanticRoger M05/06/1956Hugh GRhys ILagaan2000DramaAshutosh G 15/02/1968Aamir KGracy SSelect one:a. It is 1NFb. It is 2NFc. It is 3NFd. None of the aboveFeedback
Your answer is incorrect.The correct answer is: None of the aboveQuestion8IncorrectMark 0.00 out of 1.00Flag questionQuestion textA relation is in the first normal form if it has no more than one multivalued attribute.Select one:TrueFalseFeedbackThe correct answer is 'False'.For the relationship represented in the figure below, which of the following is wrong?Select one:a. An instructor can teach more than one course.b. A course can be taught by more than one instructor.c. A course has to be taught by one instructord. An instructor does not have to teach any course.
FeedbackYour answer is incorrect.The correct answer is: A course can be taught by more than one instructor.Question2CorrectMark 1.00 out of 1.00Flag questionQuestion text“The maximum number of courses a student can take in one term is 6.”Which constraint should be used to enforce this statement?Select one:a. Tuple constraintb. Semantic integrity constraintc. Referential integrity constraintd. Entity integrity constraintFeedbackYour answer is correct.The correct answer is: Semantic integrity constraintQuestion3CorrectMark 1.00 out of 1.00Flag questionQuestion textA surrogate key is usually a generated unique number.
Select one:TrueFalseFeedbackThe correct answer is 'True'.Question4CorrectMark 1.00 out of 1.00Flag questionQuestion textThe address of a student can be defined using street, city, state, and zip code. What type ofattribute should be used to represent the address of a student?
Upload your study docs or become a
Course Hero member to access this document
Upload your study docs or become a
Course Hero member to access this document
End of preview. Want to read all 176 pages?
Upload your study docs or become a
Course Hero member to access this document
Term
Winter
Professor
NoProfessor
Tags
Correct Answer
