Kevin’s Music is a small, but rapidly growing business operating out of Burwood. The business began as a means for Kevin to book his band into venues for live performances. Live music is not a very profitable occupation, so Kevin also started to teach music.
Within a year of beginning his operation Kevin 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 the musicians are mostly from Victoria, the venues he deals with all Australian states and territories.
Three years later, Kevin finds he has become an agent, the go-between for over 50 musicians or bands and over 100 venues, and is making a reasonable income from his fees. The music school side of the business has also expanded and he has 20 musicians who are doing the teaching, and the demand is still increasing.
Kevin’s Music is now:
So far, his business has been run with a ledger book and a calendar (a paper-based process). But these tools are becoming inefficient to manage the business. A transition to an information system is urgently needed.
You are employed as a business analyst at Deakin Innovative Solutions, a business consulting firm. You are assigned to investigate and develop an EER model for the system.
Please note: The design of any payments system is outside the scope of this project.
The system needs to be able to provide the following outputs:
You are required to perform the following tasks in this assignment.
|1. Construct an Enhanced Entity-Relationship (EER) model for the database. Make sure you include in your model details of entities, relationships, attributes, keys and cardinality of the relationships. (GLO1&5)
a. List any assumptions made and ensure that you give adequate justification.
|2. Show by providing SQL statements, that all of the reports listed in the
“Operations” section above can be produced from your EER diagrams. (GLO1&5)
NOTE: No need to actually create a database. This is a thought exercise to demonstrate that the queries are possible based on your EER diagram.
|3. Produce a business report (with EER diagram and SQL queries included within) according to the format outlined in the document “A Guide to Writing Business Reports.pdf” (GLO1&3)||10 Marks|
EER diagram should contain the following components: Entities, named relationships, attributes (keys) and cardinality for relationships.
A faster way of doing the EER diagram is to sketch it up on a blackboard, take a digital photograph and paste it into your report. Alternatively, you may use any software tools at your disposal – Lucid Charts is a good one. If hand-drawn please make sure your EER diagram is legible.
(adapted from Lucid Charts, https://www.lucidchart.com/pages/EER-diagram-symbols-and-meaning)
Entities are objects or concepts that represent important data. They are typically nouns, e.g. customer, supervisor, location, or promotion.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more