Your firm performs marketing research using focus groups, which are composed of volunteer consumers. We would like to design a database to keep track of these groups and associated information.
For each consumer volunteer, you would like to store name information, address information, phone number, date of birth, gender, marital status, number of children, and approximate annual family income. Assume that you do have access to a complete zip code table.
Each focus group consists of 5-20 consumer volunteers, although there is no strict upper limit on the size of a group. Consumer volunteers can sometimes be members of more than one group. In addition to storing which consumers are members of each group, you also want to store each group's name, date formed, and a description.
Each group can have multiple meetings. For each meeting, you want to store date/time started, date/time ended, and a brief description of the discussion topic. Each meeting has a single moderator, who is one of your employees and not considered a member of the group. Different meetings of the same group may have different moderators. For each employee, you want to store name information, regular and mobile phone numbers, date of birth, date hired, and gender.
Design a database to store all the information described above. Note that a lot of further data about your employees is stored in your Human Resource department's database, which we will not consider here. Make sure focus group database stores enough information to be able to answer all of the following queries: