Reference no: EM132965144
MIS602 Data Modelling and Database Design - Torrens University Australia
Database Case Study Report
Learning Outcome 1: Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data.
Learning Outcome 2: Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.
Learning Outcome 3: Apply contemporary database modelling to identify and address anomalies in data and recommend solutions.
Task Summary
This final assessment requires you to produce a robust and a flexible database that is able to accurately store information about the business mentioned in the case study. You also need to develop the queries and reports to provide data insights which in turn drive business decisions. Your submission should include:
a) Appropriate modelling plus any business rules or assumptions
b) SQL commands to
• physically implement your logical model
• populate the database
• retrieve meaningful information
c) Visualizations that can be presented at a board meeting
Context
This assignment brings together all the learning gained over the duration of this subject. The skills and knowledge you've gained in this subject forms a vital part of your ability to traverse the major disciplines in the data and database fields. You will be able to interact with analysts, developers, database administrators and managers using a common language which is vital if an organization is to function effectively. These skills are the groundwork for further career progression in data analysis and information management.
Task Instructions
1. Group Formation and Registration
• Form groups of 3 members.
• The deadline for team registration is 11:45pm AEST Friday end of Module 2.2
• To register your team, you are required to send your Learning Facilitator an email with "[MIS602] Group Registration" in the subject line. In the body of that email, please list the names and student ID numbers of all the members of your team.
• You are required to send the registration email to your facilitator before the registration deadline.
• After the registration deadline, those students who are not in a team will be allocated to a group by the Learning Facilitator.
2. Case Study
Please read the attached MIS602_Assessment 3_Case Study.
3. Please watch the attached MIS602_Software Assets Management: Industry Insights_Interview.
4. Database Case Study Report
Based on the information provided in the case study and the video interview, create a functioning IT asset database that can be queried to meet the requirements of the business.
5. The database case study report should include the following elements:
a) ER diagram, relational model and associated business rules and assumptions
b) SQL commands to:
• Create tables
• Insert sample data rows into each table
• SQL queries to provide business insights
At least one of each of the following is required:
o SELECT query with a condition
o GROUP BY query
o JOIN query
o NESTED query
For each query explain its business value i.e. What business question does the result answer?
E.g. How many staff have more than one laptop? How will the business use the output of this query? E.g. The company can save money by ensuring staff have only one laptop each
Please note that the questions will be of your design.
c) At least two visualizations with an explanation of its business value.
For each visualization explain its business value. E.g. Does the visualization highlight savings in time or money or both or potential anticipate future expense which can then be budgeted for?
Referencing
It is essential that you use appropriate APA style.
Attachment:- Database Case Study Report.rar
What must the average beta of the new stocks be to achieve
: Hazel Morrison, a mutual fund manager, What must the average beta of the new stocks be to achieve the target required rate of return?
|
What nominal rate of interest compounded quarterly
: At the end of the investment period, she had $4,193.53 in the account. What nominal rate of interest compounded quarterly did she earn?
|
What is the suitable enforcement framework
: What is the suitable "enforcement framework" necessary for a successful Labor Management Cooperation. Explain the underlying factors of your conceptual framewor
|
What was the approximate yield rate
: A $25,000, 9.5% bond with semi-annual coupons redeemable at par is bought 16 years before maturity at 78.25. What was the approximate yield rate?
|
Create a functioning it asset database
: Create a functioning IT asset database that can be queried to meet the requirements of the business - relational model and associated business rules
|
Affecting data resource management in business
: How have the Internet, intranets, and extranets affected the types and uses of data resources available to business professionals? What other database trends ar
|
Prepare a journal entry to record the of the money
: Assume now that the note requires blended installment payments of $30,192. Prepare the general journal entry to record the first installment payment.
|
Identify the characteristics of business spies
: Assess and identify the characteristics of business spies and apply the characteristics to a corporate espionage case you selected to analyze.
|
Locate a journal article about the balanced scorecard
: Locate a journal article about the balanced scorecard. In the subject line of your post, include the name of the article that you read. Then, in your initial po
|