Does this ERD make any sense? Does it have 1NF, 2NF and 3NF? Business Rules Teacher: Teacher can teach one or more classes. Teacher checks attendances and each attendedance record belongs to a teacher of that class. Teacher may or may not contact parents of student. Parent: Parent can enroll at least one student. parent may or may not be contacted by teacher. parent can contact any teacher in the school. Student: Students must take at least classes Each student can only have one primary contact parent. An attendance keeps track of students. School: School assignes classes. Classes are assigned by a school Class: A class must be taken by at least one student. More than one classes can be taught by a teacher. Classes are assigned by a school. Attendance: Attendances are checked by a teacher to keep record of students. Student take attendances. attendance keeps track of each student.
Does this ERD make any sense? Does it have 1NF, 2NF and 3NF?
Business Rules
Teacher:
Teacher can teach one or more classes.
Teacher checks attendances and each attendedance record belongs to a teacher of that class.
Teacher may or may not contact parents of student.
Parent:
Parent can enroll at least one student.
parent may or may not be contacted by teacher.
parent can contact any teacher in the school.
Student:
Students must take at least classes
Each student can only have one primary contact parent.
An attendance keeps track of students.
School:
School assignes classes.
Classes are assigned by a school
Class:
A class must be taken by at least one student.
More than one classes can be taught by a teacher.
Classes are assigned by a school.
Attendance:
Attendances are checked by a teacher to keep record of students.
Student take attendances.
attendance keeps track of each student.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
