Week-3 better system for the manager where they can

 

 

 

 

 

 

 

 

 

Week-3 GroupAssignment

Professor Frank Richey

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Wilmington University

January/31/2018

Group Members:

Rajeev Kottu

Swarna Madhuri Kandala

Miral Doshi

 

 

 

 

 

 

 

 

 

 

 

3-44.

 

3-45.

For this Case, we have 2 new clients from the same company.

Pat Smith, An Artist Manager.

For Pat, He desired a better system for the manager where they can get more information from the prospective artists. By this way, they’ll be able to assign the right leads and more accurate approaches to for the artist.

We decided that 4 new systems will be created for the manager side-  

·       Manager spendings

·       Manager’s calender

·       Manager’s payments

·       Manager leads

As per the pat request, managers can access ARTIST REPORT to see how well they’re doing.

Here, the names of these entities are self-explanatory. They’ll help the manager keep on tracks of what they are spending, how their calendar work matching to what the artist has.

The leads system will be based on the best match of all from artist’s previous work and resume. They can also keep track of the payment and therefore, see how much they make. And in terms, it will help them to see the revenue of each year.

 

Shannon Howard, Artist-

For Shannon, we choose to develop a similar system that would let her keep track on her earnings and spendings. She can also monitor what she’s currently working on and how her calendar is being noted.

We added 5 new system for Shannon and Artists in general:

Ø  ARTIST CALENDAR

Ø  ARTIST SPENDS

Ø  ARTIST LEADS

Ø  ARTIST WORK

Ø  ARTIST PAYMENT

These 5 new entities are also self-explanatory. As per her requests, we think this new system will be sufficient for working, traveling and schedule line up. We also specified most of the relationships followed the requests of clients.

 

3-46.

The reports that the various stakeholders might want to retrieve from the database is given below. All these reports can be retrieved from the database corresponding to the above ER diagram-

1. Customer details can be generated and also can know which manager and customer are dealing. The similar report can also be generated for the event organizers too. These reports can be retrieved from the Customer, Manager and the Event organizer tables.

2. The report for getting the details of the artist and the music record for the new artist can be obtained from the Artist table.

3. The report can be obtained from the manager’s details and can also know expense and travel cost to incur in their salary. These reports will be generated from the Manager table.

4. The report generated from the calendar to know about the events which are going on and which artist has been booked and which dates/artists are free and so that can be helpful in scheduling for the other event. These reports will be obtained by combining the Artist, Calender, Manager and Event organizer tables.

5. The artist can know their events directly accessed from the calendar and can also cancel the event and can be noted down on their calendar. These reports will be obtained by combining the Artist, Calender, Manager tables.

6. The payment slip can be generated for the artist and also can know which customers or event organizers have made the payment. These reports will be obtained by combining the Artist, Manager, Customer and Payment tables.

7. Reminders can also be generated for the specific dates. The manager can get the details of the payment that is paid to the artist. The payment involves the calculation of tax and salary for managers and the artist. These reports will be obtained from the Manager, Artist and Payment table.

 

3-47.

The user can generate the following report from the EER diagram for FAME:

Ø  The report generated from the calendar to know the events which are going on and which artist is booked and which dates are free and artist so that can be scheduled for the other event.

Ø  Remainders can also be generated for the specific dates. The manager can get the details of the payment that is paid to the artist. The music record for the new artist can be obtained. The payment involves the calculation of tax and salary for managers and the artist.

Ø  The artist can know their events directly accessed from the calendar and can also cancel the event and can be noted down in the calendar.

Ø  Customer details can be generated and can know which manager and customer are dealing. The similar report can also be generated for the event organizers also.

Ø  The report can be generated for the manager’s details and can know its extra expense and travel cost to incur in their salary. The report generates for getting the details of the artist.

Ø  The payment slip can be generated for the artist and can know which customers or event organizers have done the payment.

Now, consider the following diagram, which shows the different entities exist in the FAME:

 

 

 

 

 

 

 

 

 

 

Meeting with Stakeholders:

Many persons are present in the company and meeting can be arranged from any of them. But basically, Stakeholders involved in reviewing ER will be Pat Smith and any prospective artist to review whether their information provided is achieving in the model. Then the Assistant manager of Pat Smith is involved in reviewing their requirement.

Reviewing:

As the email is received from a different person with their own requirements, it should be reviewed separately. All the stakeholder’s requirement should be fulfilled from the designed ER model and are reviewed priorly.

ER model signed off:

When the ER model is agreed by all of them, then this model should be signed off by the Assistant manager of Pat Smith as pat smith is only responsible for looking out the major portion of the tasks which are conducted by Pat.