Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions