Design a database system to support any number of schools in an area (e.g. School District, Town, or City). The entities
Posted: Tue Jul 12, 2022 8:16 am
Design a database system to support any number of schools in anarea (e.g. School District, Town, or City). The entities shouldinclude, Attendance, Classes, Parents, Schools, Students, andTeachers.
1. Write the business rule(s) that govern the relationshipbetween the entities.
2. Given the business rule(s) you wrote in Step 1, create aCrow’s Foot ERD. Remember a many-to-many (M:N) relationship is notsupported directly in the relational environ-ment. However, M:Nrelationships can be implemented by creating a new entity in 1:Mrelationships with the original entities. Do not use your free handto create the ERD. You will not get credit for this task if youdo.
3. Determine the characteristics of each entity(Attributes).
1. Write the business rule(s) that govern the relationshipbetween the entities.
2. Given the business rule(s) you wrote in Step 1, create aCrow’s Foot ERD. Remember a many-to-many (M:N) relationship is notsupported directly in the relational environ-ment. However, M:Nrelationships can be implemented by creating a new entity in 1:Mrelationships with the original entities. Do not use your free handto create the ERD. You will not get credit for this task if youdo.
3. Determine the characteristics of each entity(Attributes).