Part 1: Data Modeling - 30 marks INSTRUCTION 1. Create a Crow's Foot ER diagram for each business rule. The diagrams should clearly describe and identify each entity and show relationships. Show all cardinality, primary keys, and foreign keys. Use verbs to name and clarify relationships. Show only the attributes contained explicitly in the case/ business rules. 2. Make sure each entity is in the third normal form and each attribute is atomic. 3. You should also make and document any reasonable assumptions where you feel the case is vague, ambiguous, or missing data necessary to meet the requirements. 4. Simplify M:N relationships, if any. 5. You may develop the diagram on paper. If so, submit the scanned version. You may also use any relevant software like Erwin. 6. Submit a PDF file only. Other file formats are not accepted. Assignment Questions: The database design process's requirements collection and analysis phase has provided the following data requirements for a charitable community association. The association has members who pay monthly contributions. The main purpose of the database is to maintain accurate data about its members and their contributions and be able to generate reports such as the number of active members, members who did not pay their monthly payments, payments collected per month, etc. a) The community association maintains member number (unique), name (first and last name), home address (number, street name, city, province, and postcode), home phone number, mobile phone number, date of birth (DOB), sex, email, membership start date and their specialization. A member can have many specializations. Although the values for home address, home phone number, and mobile phone number change, the association maintains the current values only, i.e., they do not maintain historical data. (6 Marks) ITIS2P91 SPRING 2023 b) Each member contributes a monthly contribution. The monthly contribution scheme is CAD 20 per month, with 5% and 15% discounts when a member pays a six-month (biannual) and a yearly (annual) contribution. (6 Marks) c) A member may serve in one or more committees. The association maintains on each committee the committee number (unique), title, a brief description of the committee, and the type of committee (executive, social, cultural or fund-rasing). In addition, the association maintains on each member when they joined the committee, their role (a member can be a chairperson, secretary or just a member), and the expected membership end date. A member plays only one role in a committee, and all the roles are the same for each committee, i.e., the responsibilities of a chairperson are the same no matter the type of the committee. (6 Marks) d) A committee may organize several events, which may be organized by more than one committee. The association maintains the event name, description, start and end date, location, and the number of expected participants for each event. Each even has a unique event number. (4 Marks) e) A member of the association manages historical artifacts for the association. The association maintains an asset tag (unique), name, description, acquisition date, condition, provenance, current value, and artifact image. (4 Marks) f) Represent the complete set of requirements in one ER diagram. (4 Marks)