Design a database system to support any number of schools in an area (e.g. School District, Town, or City). The entities

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Design a database system to support any number of schools in an area (e.g. School District, Town, or City). The entities

Post by answerhappygod »

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).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply