Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please draw the ERD for each of the following scenarios. A ) The Society of Artists in Nevada would like to maintain a database regarding
Please draw the ERD for each of the following scenarios.
A The Society of Artists in Nevada would like to maintain a database regarding its members. An artist is known by the name, membership number, and pen names uses on the artwork; an artist may have used many different pen names. The artworks created by the artists are also recorded in the database. The data of a piece of artwork include item code, title, type for example, drawing, sculpture, cartoons, calligraphy, photography, etc. and size; size could be described by weight, height, length, and width. The data regarding the owner of the artwork should also be maintained, such as the name, address, and phone number. An artwork could have been owned by different people over the years.
B The National Association for Anime hosts a large number of events. Each event would have an event name, venue, start day, and end date. An event is sponsored by one organization, and an organization can sponsor many events. Each organization is described by the name, contact person, address, and phone numbers. Only the organizations that have sponsored at least one event would be kept. Members of the Association can attend any number of events. For each member, the member ID name, sex, and affiliations are maintained in the database. Future events in planning are also recorded; in this case, the attendance of the event is not yet known. When a member attends an event, the registration date should be recorded as well.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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