About Entity Relationship Diagram or ERD.

Question

Make a ERD.

1. Each applicant can submit one or more application( one application per year for multiple years). Each application is submitted by only one applicant.
2. Each school can be associated with one or more applications. Each application is associated with only one school.
3. Each application must include two or more recommendation. Each recommendation is included with only one application.
4. Each bowling center can be associated with one or more applications. Each application is associated with only one bowling center.

Answer 1

The first step in creating an ERD is, not surprisingly, identifying the entities. The candidates seem to be applicant, application, school, recommendation and (odd tho it may be) bowling center.

Next is identifying the relationships and their cardinality (one-to-one, zero-to-many, many-to-many, etc.) Any many-to-many relationship should be resolved by an associative entity which reduces the many-to-many into 2 relationships that have a zero or 1 cardinality on at least one side. (There does not appear to ba any many-to-many relationships in this case.)

Finally, at least a few attributes of each entity should be identified - at a minimum, a candidate key (applicant id, school id, etc.)