(Solved) : 3 Single Entity Case Judy New Town Decided Join Local Chapter Woman S Volunteer Club Under Q44133796 . . .
3 – Single Entity Case Judy, who is new to town, has decided to join the local chapter of a woman’s volunteer club that undertakes a number of charitable events and outreach programs. It has approximately 150 current members as well as 30 provisional members (a new member before she becomes a full member). The club would like to create a single table database that could be used to maintain a membership directory and print mailing labels. This table should include each member’s first name, last name, street address, city, state, zip code, phone, fax, e-mail address, the community in which she lives, whether she receives the newsletter via regular mail or e-mail, and whether she is a provisional member. The club wants to be able to query this table to 1. Create a list of those members who receive the newsletter by mail. 2. Make an alphabetic list of all members’ first name, last name and e-mail address for those members with email addresses. 3. Make a special directory for those members who live in the communities HG, AG, CLI, and CC (this should be in order by community and within community by last name). 4. Make a master directory that lists the current members in alphabetical order and followed by the provisional members in alphabetical order. Create the data model, then create the single table and populate with three records. Show transcribed image text 3 – Single Entity Case Judy, who is new to town, has decided to join the local chapter of a woman’s volunteer club that undertakes a number of charitable events and outreach programs. It has approximately 150 current members as well as 30 provisional members (a new member before she becomes a full member). The club would like to create a single table database that could be used to maintain a membership directory and print mailing labels. This table should include each member’s first name, last name, street address, city, state, zip code, phone, fax, e-mail address, the community in which she lives, whether she receives the newsletter via regular mail or e-mail, and whether she is a provisional member. The club wants to be able to query this table to 1. Create a list of those members who receive the newsletter by mail. 2. Make an alphabetic list of all members’ first name, last name and e-mail address for those members with email addresses. 3. Make a special directory for those members who live in the communities HG, AG, CLI, and CC (this should be in order by community and within community by last name). 4. Make a master directory that lists the current members in alphabetical order and followed by the provisional members in alphabetical order. Create the data model, then create the single table and populate with three records.
Expert Answer
Answer to 3 – Single Entity Case Judy, who is new to town, has decided to join the local chapter of a woman’s volunteer club that …
OR