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

$1$

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$ Marls$)$

I need help with e & f