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, duty.) ABC(A, B, C) CDEFG(C, D, E, F, G) Where Aa {B, C}, CaD, Da{E, F, G}

Explanation / Answer

1) Student table is in 3NF.

Every attribute in student table depends on the primary key. It is in

2)In University table name is the primary key.It identifies every row uniquely.So every other attribute depends on the primary key.It is in

3)In Restaurant table,tax_id is the primary key which identifies every row uniquely.Every attribute is dependent on it.So the table is in

In Job table,job_title is the primary key.Job table is in

In employee table,emp_no,tax_id, and job_title uniquely identifies the row.AA the other attributes in this table are dependent on these 3 attributes. Employee table is in

In job_duties table,job_title and duty uniquuely identify the rows.Since only 2 attributes are there the table is in

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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