Question 2. Given our intuitive guideline for 3rd normal form that a non-key att

Question

Question 2. Given our intuitive guideline for 3rd normal form that a non-key attribute is about the key, the whole key and nothing but the key, consider the following schema for a college; the college database is one large table, named Al in Qne: AlwinnOne(Student ID, name, Course ID, Course Section, course name, total credits, grade, professor name, salary, Semester acul ID) Furthermore, the following relationships hold for the data in this large table R1 Student ID name, total credits R2 Student ID, Semester, C ID, C Section grade R3 Semester, C ID C Section Faculty ID R4 Course ID course name RS E Faculty ID 7 prof name, salary In other words, Student ID determines (uniquely identifies name, and total credits Student ID, Semester, Course ID and Course Section determine grade for courses taken Semester, Course ID and Course Section determine the Faculty ID ofthe teacher Course ID determines course name Faculty ID determines professor name, and salary Decompose the college's one large table into a set of tables that are in 3rd normal form

Explanation / Answer

package david; public class Student { private String name; private int age; private int year; private String studentNum; public Student(String name, int age, int year, String studentNum) { this.name = name; this.age = age; this.year = year; this.studentNum = studentNum; } // Setters and getters (Name, Age, Year and Student Number) public String getName() // name { return name; } public void setName(String name) { this.name = name; } public int getAge() // age { return age; } public void setAge(int age) { this.age = age; } public int getYear() // year { return year; } public void setYear(int year) { this.year = year; } public String getstudentNum() // studentNum { return studentNum; } public void setstudentNum(String studentNum) { this.studentNum = studentNum; } }

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.