Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started