Home / Expert Answers / Computer Science / 1-consider-the-following-scenario-a-photography-club-has-a-number-of-members-who-have-names-addr-pa755

(Solved): 1. Consider the following scenario: a photography club has a number of members who have names, addr ...



student submitted image, transcription available below
1. Consider the following scenario: a photography club has a number of members who have names, addresses and phone numbers and we assume that while their may be multiple members with the same address, no two members with the same name have the same address or the same phone number. Each member has a member id, which is unique to that member. Draw the ERD containing the entity type for the photography club members. 2. Consider the previous scenario. Suppose now that the club has activities that it sponsors and equipment that it loans to members. For the equipment, the store keeps track of the following: - the product manufacturer name - the product model number - number available - description A manufacturer has many products, each of which has a product which is unique for that manufacturer. For the activities, the club tracks the following the date of the activity the location the id of the activity leader product manufacturer of equipment to be used in activity the product model number of equipment to be used in activity Assume that the club has only one activity per day at a given location (there could be multiple activites on the same day and the same location could be used on different days). Each activity uses a specific type of equipement and the number of club members who can participate in the activity is limited by the number of that pieces of that type of equipment. One club member will act as the leader for each activity. a. Draw the entity types for the club activities and equipment. b. Draw the following relationship types between the club member, club activity, and club equipment entity types: i. club members can be loaned club equipment; a club member could have many of the club's equipment checked out, but each piece of equipment is checked out to one club member. The date of the check out is an attribute of the relationship. ii. club actitivities can use club equipment; an activity can use multiple pieces of equipment, but each piece of equipment is used at only a single activity. iii. club member leads a club activity; each activity is led by one club member; a club member can lead many activities


We have an Answer from Expert

View Expert Answer

Expert Answer



Solution:

For the first scenario, we can create an entity type called Member with the following attri...
We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe