Enterprise Information System- Report

ENTERPRISE INFORMATION SYSTEM
MANAGER:
ADDRESS:
MY COMPANY NAME: Deakin Innovative Solutions Pty Ltd,
DATE

Table of Contents
Executive Summary..................................................................................................... 3
1.0 Introduction...................................................................................................... 3
2.0 Company Profile................................................................................................ 3
3.0 Entity Relational Diagram.................................................................................... 4
4.0 Justification...................................................................................................... 5
5.0 Benefits and Limitations........................................................................................... 8
6.0 Recommendations................................................................................................... 8
References................................................................................................................. 9

Executive Summary
The report is based on a company that have been doing manually using ledger books in recording all
the events in their calendar. The goal of this organisation is to come with an enterprise information
system that reduces all the works in the ledgers as booking of musicians, events and venues will be
easily recorded and easy to retrieve when need arise (Kahate, 2011). Considering Jim Music
company is growing rapidly there arose the need to migrate from paper work to a system that can
interact and in a faster way hence spending less effort, time and making more profit. As a business
analyst I have come up with data model in form of entity relational diagram and some of the
recommendations that need to be considered in putting up the proposed model considering all the
specifications and requirements of Jim Music Company.
1.0 Introduction
The project was commissioned by the manager Jim Music company to Deakin Innovative Solutions
Pty Ltd, where I work as a business analyst. The commissioning of this project was to advise them on
how they can migrate from paper based works to an interactive system that is effective and very
efficient.
For the project three individuals were assigned different tasks that is: A database administrator who
had to do the survey and come up with a model using ERD (Ramakrishnan, 2009), secondly is an
architecture who had to draw the whole scenario in way it can be understood and lastly the analyst
who had to give the whole analysis of all what is expected by Jim Music company.
This project covers entity relational diagram that need to be implemented showing its results through
use of sql statements that are a result of database manipulation. It also shows justifications of our
findings and the recommendations that need to be put in place with the benefits and the limitations
they accrue.
2.0 Company Profile
Jim’s Music is a small, but rapidly growing business operating out of Burwood. The business began
as a means for Jim to book his band into venues for live performances. Live music is not a very
profitable occupation, so Jim also started to teach music. Within a year of beginning his operation Jim
was approached by other musicians for help in getting bookings at live music venues. At the same
time, some music venues were also asking him for help in getting bands for them. While his musician
are mostly from Victoria, the venues he deals with all Australian states and territories. Three years