ASSESSMENT 3 BRIEF
Subject Code and Title MIS602 Data Modelling and Database Design
Assessment Database Case Study Report
Individual/Group Group
Length N/A
Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include:
a) Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data.
b) Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.
c) Apply contemporary database modelling to identify and address anomalies in data and recommend solutions.
Submission Due by 11:55pm AEST/AEDT Sunday end of Module 6.1
Weighting 35%
Total Marks 100 Marks
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.
Assignment 3 Brief Page 1 of 3
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. Database Case Study Report
Based on the information provided in the case study, create a functioning database using MySQL that can be queried to meet the requirements of the business.
4. 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 and Insert sample data rows into each table • SQL queries to provide business insights At least one of each of the following is required:
• SELECT query with a condition
• GROUP BY query
• 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
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 for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing
Submission Instructions
Submit Assessment 3 via the Assessment link in the main navigation menu in MIS602 Data Modelling and Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
Academic Integrity Declaration
We declare that except where we have referenced, the work we are submitting for this assessment task is our own work. We have read and are aware of Torrens University Australia Academic Integrity Policy and
Procedure viewable online at http://www.torrens.edu.au/policies-and-forms
We are aware that we need to keep a copy of all submitted material and their drafts, and we will do so accordingly.
Assignment 3 Brief Page 2 of 3
Assessment Rubric
Assessment Criteria Fail
(Unacceptable) 0-
49% Pass
(Functional)
50-64% Credit (Proficient) 65-74% Distinction
(Advanced)
75 -84% High Distinction
(Exceptional)
85-100%
ER diagram
Relational model Associated business
rules and
assumptions
30% Limited entities and relationships identified. Limited entities converted to tables. No list of assumptions/ business rules. Most entities identified and labelled. Most relationships identified.
Identified Entities converted to tables.
Most fields listed. Design is in third normal form. List of assumptions/business rules.
All entities identified and labelled. All relationships identified. Most cardinality is correct. Most participation is correct. All entities converted to tables. All fields listed.
Most many-to-many relationships deconstructed into new tables. Primary keys correctly underlined. All relationships meaningfully labelled. Primary key labelled for entities.
All cardinality is correct. All
participation is correct. All many-tomany
relationships deconstructed into new tables. Foreign keys correctly underlined. Primary keys labelled for many-to-many relationships Some nonkey fields labelled. Any multivalued attributes deconstructed into new tables. Any self-joins identified.
Well-presented ER diagram, relational model, associated business rules and assumptions.
SQL commands
45% Limited number of queries provided and queries do not meet the criteria. Business statements value not provided. Create table DDL SQL provided. Data insert DML SQL provided. Minimum number of queries provided and queries meets the criteria. Business statements value provided. Queries exhibit extra detail e.g. column headers concatenation sorting.
Additional queries provided. Queries exhibit extra detail e.g. advanced
filtering calculations join with more than two tables. Additional queries provided.
All SQL is well formatted.
Overall, well presented.
Visualisation with an explanation
25% Minimum visualisations provided with no business value statements. Minimum visualizations provided. Business value statements provided Axes well labelled.
Legends well labelled. One
visualization is an aggregation. Additional visualization provided. Additional features utilized e.g.
calculations Additional visualization provided. Overall, well presented visualisation with an explanation.
Assignment 3 Brief Page 3 of 3
—
MIS602 Data Modelling and Database Design Assessment Database Case Study Report ASSESSMENT 3 BRIEF Subject Code and Title
Individual/Group Individual/Group
N/A Length
Learning Objectives The Matter Successful completion of the task below demonstrates the following learning outcomes:
a) Investigate the role of data in an organization and come up with solutions for the generation, storage, and management of organizational data.
b) Create solutions to challenging challenges using relational database techniques and communicate these solutions to all stakeholders.
c) Use modern database modeling to discover and solve data abnormalities and make recommendations for remedies.
Submission by 11:55 p.m. AEST/AEDT Module 6.1 comes to a close on Sunday.
35 percent of the total
Marks totaled: 100
Summary of the Task
You must create a powerful and adaptable database that can appropriately record information about the business specified in the case study for this final evaluation. You must also create queries and reports in order to deliver data insights that drive business choices. The following items should be included in your submission:
a) Useful modeling, as well as any business norms or assumptions
b) SQL statements to
• Put your logical concept into action physically.
• fill up the database
• Obtain relevant information
c) Visualizations that can be presented during a meeting of the board of directors
Context
This project synthesizes all of the knowledge obtained throughout the course. Your ability to traverse the key disciplines in the data and database sectors is dependent on the skills and information you’ve gained in this topic. You’ll be able to communicate with analysts, developers, database administrators, and managers in a single language, which is critical for a company’s success. These abilities are the foundation for advancing your career in data analysis and information management.
Page 1 of 3 of 3 of 3 of 3 of 3 of 3 of 3 of 3 of 3 of
Instructions for the Task
1. Formation and Registration of Groups
• Form three-person groups.
• Team registration closes at 11:45 p.m. AEST on Friday at the end of Module 2.2.
• To register your team, send an email to your Learning Facilitator with the subject line “[MIS602] Group Registration.” Please mention the names and student ID numbers of all members of your team in the body of that email.
• Before the registration deadline, you must send the registration email to your facilitator.
• After the registration deadline, the Learning Facilitator will assign students who are not in a team to a group.
Case Study No. 2
Please study the MIS602 Assessment 3 Case Study that is included.
Report on a Database Case Study
Create a working database using MySQL based on the information provided in the case study that can be queried to fulfill the business’s needs.
4. The following elements should be included in the database case study report:
a) The ER diagram, relational model, and business rules and assumptions that go with it b) SQL statements to:
• Make tables and add example data rows to each one. • Business intelligence from SQL queries There must be at least one of each of the following:
• A conditional SELECT query
• QUERY BY GROUP BY
• JOIN QUERY vs. NEXT QUERY
Explain the business value of each query, i.e., what business issue does the result answer? For example, how many employees have more than one laptop? What will this query’s output be used for in the business? For example, the company can save money by requiring each employee to have only one laptop.
c) At least two visuals, each with a business value explanation.
Explain the business value of each graphic. 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 for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing
Submission Instructions
Submit Assessment 3 via the Assessment link in the main navigation menu in MIS602 Data Modelling and Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
Academic Integrity Declaration
We declare that except where we have referenced, the work we are submitting for this assessment task is our own work. We have read and are aware of Torrens University Australia Academic Integrity Policy and
Procedure viewable online at http://www.torrens.edu.au/policies-and-forms
We are aware that we need to keep a copy of all submitted material and their drafts, and we will do so accordingly.
Assignment 3 Brief Page 2 of 3
Assessment Rubric
Assessment Criteria Fail
(Unacceptable) 0-
49% Pass
(Functional)
50-64% Credit (Proficient) 65-74% Distinction
(Advanced)
75 -84% High Distinction
(Exceptional)
85-100%
ER diagram
Relational model Associated business
rules and
assumptions
30% Limited entities and relationships identified. Limited entities converted to tables. No list of assumptions/ business rules. Most entities identified and labelled. Most relationships identified.
Identified Entities converted to tables.
Most fields listed. Design is in third normal form. List of assumptions/business rules.
All entities identified and labelled. All relationships identified. Most cardinality is correct. Most participation is correct. All entities converted to tables. All fields listed.
Most many-to-many relationships deconstructed into new tables. Primary keys correctly underlined. All relationships meaningfully labelled. Primary key labelled for entities.
All cardinality is correct. All
participation is correct. All many-tomany
relationships deconstructed into new tables. Foreign keys correctly underlined. Primary keys labelled for many-to-many relationships Some nonkey fields labelled. Any multivalued attributes deconstructed into new tables. Any self-joins identified.
Well-presented ER diagram, relational model, associated business rules and assumptions.
SQL commands
45% Limited number of queries provided and queries do not meet the criteria. Business statements value not provided. Create table DDL SQL provided. Data insert DML SQL provided. Minimum number of queries provided and queries meets the criteria. Business statements value provided. Queries exhibit extra detail e.g. column headers concatenation sorting.
Additional queries provided. Queries exhibit extra detail e.g. advanced
filtering calculations join with more than two tables. Additional queries provided.
All SQL is well formatted.
Overall, well presented.
Visualisation with an explanation
25% Minimum visualisations provided with no business value statements. Minimum visualizations provided. Business value statements provided Axes well labelled.
Legends well labelled. One
visualization is an aggregation. Additional visualization provided. Additional features utilized e.g.
calculations Additional visualization provided. Overall, well presented visualisation with an explanation.
Assignment 3 Brief Page 3 of 3
The post MIS602 Data Modelling and Database Design Assessment appeared first on Research Quora.