Design an eer diagram for ciuntry club

Assignment Help Software Engineering

Reference no: EM1367782

You are working for a large country club. This country club wants to keep a database on its members and their guests. For each member, the club keeps mail and telephone contact information, name, and membership number. When you join this club, you can join as a social member (which allows you two rounds of golf a year as well as privileges to the swimming pool and weight room), a tennis member (which allows you all the privileges of a social member as well as use of the tennis courts and four rounds of golf), or a golfing member (which allows you all the privileges of a tennis member and unlimited use of the golf course). This database needs to track how often a member (who has limited use of the golf course; all golfing members have unlimited use of the golf course) has used the golf course, and how many guests any and each member has brought to the club. All members have guest privileges. The club also wants to attract new members by mailing to all those who came to the club as guests and live in the state. The mailing includes information about their visits (i.e., date of visit and which member was their host for each visit). Once a person becomes a member of any type, information about them as guests is no longer important to retain. Develop an EER diagram for this situation.

Reference no: EM1367782

Questions Cloud

Illustrate what would be effect taxes once all rounds : Assume that economy starts at equilibrium and mpc = 0.8. Illustrate what would be effect of a $500 increase in taxes once all rounds of multiplier process are complete.

Developing a research manuscript : What do you believe is the most significant consideration when developing a research manuscript? Support your response.

Production possibilities curve-free markets : Pick a social problem where free markets aren't allowed to function and explain how free market features could be introduced to aid alleviate the problem.

Data collection for nursing research : Describe the nurse's role in data collection, patient privacy, and ethical treatment of human subjects? What are several ethical considerations in data collection for nursing research?

Design an eer diagram for ciuntry club : Once a person becomes a member of any type, information about them as guests is no longer important to retain. Design an EER diagram for this situation.

Asset market model and exchange rates. : Suppose the spot exchange rate in dollars and yen is e=$1/100yen. The interest rate on a 6 months dollar denominated assets is i($)=1 percent and interest rate on comparable 6 months yen denominated assets

Economics-decision making in multi-national firms : Can you articulate how macroeconomics and microeconomics come into play in the context of firm decision-making in a global business. Please provide an example.

Understanding of transcultural concepts : What unique features of families require an understanding of transcultural concepts? Describe factors the nurse will require to consider when planning culturally appropriate nursing care.

Underestimating actual costs : Assume the military bureaucracy consistently misinforms Congress on total costs of producing military hardware. Suppose that it underestimates the actual costs and that the political representatives believe these estimates.

User Account

All Pages