# B lossless join decomposition must be achieved at all

• 176

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 116 - 122 out of 176 pages.

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?

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 176 pages?

Course Hero member to access this document

Term
Winter
Professor
NoProfessor
Tags