In what normal form are the below examples, and why? Are they correct? If below

Question

In what normal form are the below examples, and why? Are they correct? If below 3NF or incorrect, normalize and/or correct them. Student(first, middle, last, gpa, student_number. class_taken, class_credit_hours, class_section_number, class_semester, class_grade_achieved) University(address, city, state, zip, name. majors_offered) Restaurant(tax_id, name, genre, zagat_rating, phone, address, city, state, zip) Employee(emp_no, tax_id(fk), first, middle, last, Job_title(fk) Job(job_title, pay scale, hours) Job_duties(job=title, duly.) ABC(A, B, C) CDEFG(C, D, E, F, G) Where Aa {B, C}, CaD, Da{E, F, G}

Explanation / Answer

1. The student relation is in second normal. Because all the non prime attributes are dependent on primary key student_number only.

But this relation is not is 3 rd normal form as this is having trivial dependency. Here in this class_semester is dependent on student_nunber and class_taken and class hours is depend on student_semester. So now we can convert the table into.

Student(first,middle,last,gpa,student_number,class_semester,class_gradeachieved)

Student_semester( class_semester, class_taken,class_credithours)

2. This university table is in s second normal form. But it is having trivial dependency. Zip is dependent on name but state,city, address is dependent on zip

University (name,majors_offered,zip)

University_address( zip, address, state,city)

3. In this restaurant also we have trivial dependency of address so we convert this into below

Restaurant(tax_id, name,genre, zagat_rating, phone, zip)

Restaurant_address( zip, address, city,state)

All the other in this which are employee,job and job_duties are in 3rd normal form only.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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