MIS202: Managing Data & Information – EER Model Business – SQL Queries – Business Report Assessment Answer

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

1AFDHF
MIS202: Managing Data & Information Assessment Answer
Task: 1
SQL Queries
Include the following SQL queries that were completed as part of the weekly workshops. These were labelled as
Assignment Question
within each of the workshops.

a) Workshop Week 2 – Question 3 b) Workshop Week 3 – Question 6 c) Workshop Week 4 – Question 8 d) Workshop Week 5 – Question 4 e) Workshop Week 5 – Question 5

For each of the above SQL queries include the following:

Actual textual SQL query
(e.g.
SELECT column FROM table;
)

Screenshot of the SQL query being executed on your university database account 
and the resulting table.

Make sure the SQL query and the resulting table are captured in full in the screenshot. The table should be formatted with no lines wrapping around. Use
set linesize
command (see Workshop Week 2) to increase line length if necessary.
iii. Explanation of each of the SQL queries in your own words (1 or 2 sentences max).

Task 2: EER Model Business brief

Fix My Sink Online
is a small, but rapidly growing business operating out of Geelong. The owner, Phillip Lancashire who is a plumber by trade, started this business to sell various plumbing products online and book household plumbing services with his customer base. Selling plumbing parts alone was not a profitable occupation, so Phillip also branched off into selling other types of physical goods such as tools, pot plants and animal feed to the local community in the greater Geelong.
Within a year of beginning his operation Phillip was approached by his friends who were also interested in selling various specialised goods that typical shops were not interested in selling (e.g. herbal remedies, organic fertilizers, homemade spice concoctions etc). At the same time he is approached by others (handymen, plumbers, electricians, babysitters, mechanics etc.) seeking his help in getting their services booked with customers. All service bookings must specify a venue or a job site where the work is to be carried out. While most clients are from Victoria, the service bookings originate from all Australian states and territories.
Three years later, Phillip finds that he has become an agent, the go-between for over 500 buyers and sellers. He is generating a reasonable income from the commissions charged (5% of total transaction value). The household service bookings business has also expanded and he has over 50 service providers depending on him for finding work, and the demand is still growing.
So far his business has been operating with notes scribbled on notebooks in combination with a series of disorganised spreadsheets. But these tools are becoming inefficient and increasingly inapt at managing the growing demands of the business. A transition to an information system is urgently needed.
You are employed as a business analyst at Deakin Innovative Solutions Ltd, a business-consulting firm. You are assigned to investigate and develop an EER model for the newly proposed system, produce a business report addressing the business owner and make recommendations.

Note: The design of any payments system is outside the scope of this project.

EER Diagram

EER diagram should contain the following components: Entities, named relationships, attributes (keys identified) and the cardinality for all relationships.
A faster way of doing the EER diagram is to sketch it up on a blackboard/paper, take a digital photograph and paste it into your report. Alternatively, you may use any software tools at your disposal to sketch the EER diagram. If hand-drawn make sure your EER diagram is legible.

Tasks

You are required to perform the following tasks in this assignment.

Produce SQL statements outlined under the section Task 1 SQL Queries above. NOTE: No need to create an actual database. Only the SQL queries, screenshots and the accompanying explanations need to be submitted.

Construct an Enhanced Entity-Relationship (EER) model for the business case outlined under the section Task 2 EER Model Business Brief. Make sure you include the details of entities, relationships, attributes, primary keys and the cardinalities.

Produce a business report for the business case. Include Task 1 as Appendix 1. Also, list any assumptions made when completing Task 2 and ensure that you give adequate justification. More information about writing a business report and a sample report structure is provided in the separate document titled “A Guide to Writing Business Reports”

This MIS202: Managing Data & Information Assignment has been solved by our IT experts at TVAssignmentHelp. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
 

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services