Answered step by step
Verified Expert Solution
Link Copied!

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 affiliation(s) 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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 3 Lnai 9286

Authors: Albert Bifet ,Michael May ,Bianca Zadrozny ,Ricard Gavalda ,Dino Pedreschi ,Francesco Bonchi ,Jaime Cardoso ,Myra Spiliopoulou

1st Edition

3319234609, 978-3319234601

More Books

Students also viewed these Databases questions

Question

3 Solve for x 3 x 2 1 X 1 5x 3 3) Solve for x. 1 x 1 5x

Answered: 1 week ago

Question

a. Describe the encounter. What made it intercultural?

Answered: 1 week ago