Assignment Instructions/ Description
Project Questions
2-59. Redo the enterprise data model you created in Chapter 1 to accommodate the information gleaned from Alex Martin, Dale Dylan, and Sandy Wallis’ e-mails.
2-60. Create an E-R diagram for FAME based on the enterprise data model you developed in 1-52. Clearly state any assumptions you made in developing the diagram.
2-61. Use the narratives in Chapter 1 and above to identify the typical outputs (reports and displays) the various stake-holders might want to retrieve from your database. Now, revisit the E-R diagram you created in 2-60 to ensure that your model has captured the information necessary to generate the outputs desired. Update your E-R diagram as necessary.
2-62. Prepare a list of questions that you have as a result of your E-R modeling efforts, and that need to be answered to clarify your understanding of FAME’s business rules and data requirements.read the case study; Forondo Artist Management Excellence Inc. After reading the case, evaluate the project questions and decide individually on what is the most effective and efficient answer for each project question.
Need answer as soon as possible in APA format with references and citation. you got about 12 hrs.
Chapter 2 CASE
Forondo Artist Management Excellence Inc.
Case Description
Martin was very impressed with your project plan and has given you the go ahead for the project. He also indicates to you that he has e-mails from several key staff members that should help with the design of the system. The first is from Alex Martin (administrative assistant to Pat Smith, an artist manager). Pat is on vacation and Martin has promised that Pat’s perspective will be provided at a later date. The other two are from Dale Dylan, an artist that Pat manages, and Sandy Wallis, an event organizer. The text of these e-mails is provided below.
E-mail from Alex Martin, Administrative Assistant
My name is Alex Martin, and I am the administrative assistant to Pat Smith. While Pat’s role is to create and maintain relationships with our clients and the event organizers, I am responsible for running the show at the operational level. I take care of Pat’s phone calls while Pat is on the road, respond to inquiries and relay the urgent ones to Pat, write letters to organizers and artists, collect information on prospective artists, send bills to the event organizers and make sure that they pay their bills, take care of the artist accounts, and arrange Pat’s travel (and keep track of travel costs). Most of my work I manage with Word and simple Excel spread-sheets, but it would be very useful to be able to have a system that would help me to keep track of the event fees that have been agreed upon, the events that have been successfully completed, cancellations (in the current system, I sometimes don’t get information about a cancellation and I end up sending an invoice for a cancelled concert—pretty embarrassing), payments that need to be made to the artists, etc. Pat and other managers seem to think that it would be a good idea if they could better track their travel costs and the impact these costs have on their income
Post a Comment