16In R(A, B, C) with key A and dependencies A → B and B → C, R is in:A3NFBBCNFC2NF but not 3NFDNot 1NFView AnswerDiscussWorkspaceReportSaveMedium
17In Student(roll_no, course_id, student_name, course_name) with key (roll_no, course_id), student_name depends only on roll_no. This violates:A1NFB2NFCBCNF onlyDNo normal formView AnswerDiscussWorkspaceReportSaveMedium
185NF (project-join normal form) deals with:AJoin dependenciesBMultivalued dependencies onlyCNull valuesDPartial dependenciesView AnswerDiscussWorkspaceReportSaveEasy
19A relation is in BCNF if:AIt has no NULLsBIt has a single-column keyCEvery determinant of a non-trivial functional dependency is a super keyDIt is in 1NFView AnswerDiscussWorkspaceReportSaveEasy
20An insertion anomaly means:ADuplicate rows are insertedBInserts are slowCInserts need a triggerDSome facts cannot be stored without unrelated dataView AnswerDiscussWorkspaceReportSaveEasy