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.