The goal of this homework is to draft an EER diagram for a business problem that reects the real- life projects of a data architect. The homework is individual. Any form of collaboration is not allowed. After reading the description of the business problem (see below the client's requirements and attached additional information), prepare a list of entities and a short descriptionlexplanation of each entity. Then, design the BER diagram representing your proposed solution to this database project. In case something is not clearly specied, you have 2 options: 1. Prepare a list of questions for the client (your instructor). Be mindful that the client will require time to answer, so ask the questions at least 2 days before the deadline. 2. Make assumptions and design the diagram (remember to list all the assumptions in your deliverable) I will evaluate each submission following these criteria. Outline of the evaluation criteria: I 1. The EER Diagram (120 points) must: - Be in the BER languagelfonnat that we use in this course Follow the BER logic and rules Include the entities that are necessary to answer al_i the client's requirements Include a list of all the entities with a brief description of each entity Show all the necessary relationships between entities Specify the cardinality (both directions!) and degree of each relationship Include a short list of the assumptions that were made to draft the diagram ["1 |"'| Il I' -. gm Prepare one wordr'pdf document with all the above information. For the diagram, you can use any tool you want, including drafting it on a paper and taking a picture of it. But remember. the submission must include one file only. When you're ready, upload your le on Blackboard. formanagingourarstaccmmtsbecaisewehavesepamtespreadsheetsa'keepingnackofa particularartist'sfmenmedandtheexpensesiueunedmndthenattheendnfeachmonthwe [manuallyr create a simple statentent for each ofthe artists. This is a lot ofwosrk, and it would make much more sensetohaveacomputersystem that wouldallowmtobeabletokeep thebooks constantly up to date. Also, we need to keep in our databases plenty of information on the artiststheir name. gender, address (including the state. as they live all over the US). phone Embeds). instrumentis). email. genre, etc. Wealsotrytolceeptrackofhow theyaredoingintu'msoftlie reviewsllieygeLand thus we are subscribing to a clipping service that provid us articles on the artists whom we manage. At any rate.wewould atlemt liketnbeableto haveabetter ideaot'whatwehaveinmir archives on a particular artist, and thus we should probably start to maintain some kind ofa list of tlienewsitel'ns'wehaiu'eforaparticularnrtist.Iclton'tknowit'tlaisisworthithutitwnuldhevtn'yr useful ifwe could get it done. In addititmtnthat,wekeeptraekoftbe vmue's rating oftlte artists aereachperformance.Each ratingisniunericonnscalefrom l to lilandhasnlsoashort description attached. The system for managing prospective artists should keep track of the artists (including their name. gender. year of birth, instruments), genra. university degrees. addras. phone number. e-Inail. honors. etc.) and all the situations in which we have heard oftheeo (including the source, a brief summary. a brief quality evaluation. and space for storing the original story or a reference to it if it was a review either in a newspaper or on the Web). Scheduling is. of course. a major headache for Inc. I maintain a big schedule book for each artist whom we manage. It would be so wonderful to get a centralized calendar which both myself and the artists could access. I guess it would be good if the artists could block time out ifthey decide that they need if for personal purposes (they are not. however. allowed to hook any performances without discussing it rst with us]. One more thing: I would need to have something that would remind me of the upcoming changes in artist contracts. Every artist's contract has to be renewcdannually. and sometimes I forget to do this with the artist. Normally this is not a big deal. but occasionally we have had a situation where the lack of a valid contract led to unfortunate and unnecessary problems. It seems that we would need to maintain some type of list of the contracts will\"! their start dates. end dates. loyalty percentages. and simple notes related to each ofthe contracts. From an artist perspective, it would be nice to have annual summaries regarding the fees they have canted. but it would be nice to have this information a hit more otten. It is also crucial to keep track of the fees that have already been paid to the artists and the fees that still need to be paid. Our policy is to pay the artist the week after the perfom'iance. which is when the venues pay in