Database Design Multiple Choice We are given the following relational schema: Pl
ID: 3866671 • Letter: D
Question
Database Design Multiple Choice
We are given the following relational schema: Please normalize the above relational schema, so that the new design is a correct database schema that will replace the above design and will conform to 3NF. After that, please answer the following question. According to the new design that achieves 3NF, which of the following statement is FALSE? (a) One of the new relations in the new schema is: STUDENT (StudentlD. Student_Name) (b) One of the new relations in the new schema is: CLASS_SECTION (Section#, Section_Start_Date, Course_ID) (c) One of the new relations in the new schema is: ENROLLMENT (Section#, StudentID, Section_Start_Date, CourseID, NoOfAbsence, Grade) (d) In the new schema that conforms to 3NF, there Is a total of three relations. (e) All of (a) through (d) are TRUE.Explanation / Answer
3NF means that it should satisy 2nf and there should not be any transitive dependency.
In 3nf we will have following tables:
Student ID Student Name
Section#, Section_Start_Date, Course_ID
Course_ID StudentID Grade NoOfAbsence
The false statement is c
It is because ENROLLMENT table is not 2nf. In 2nf an non key attribute can not depend on proper subset of primary key. In this case Course_ID is only dependent on Section# which is a part of primary key (Section#, StudentId).
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.