ASSESSMENT 3 BRIEF
\nSubject Code and Title MIS602 Data Modelling and Database Design
\nAssessment Database Case Study Report
\nIndividual\/Group Group
\nLength N\/A
\nLearning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include:
\na) Examine the role of data in an organisation, and develop solutions related to the creation, storage and management of organisational data. Data plays a critical role in organizations, as it is used to inform decision-making, support business operations, and measure performance. Some specific ways that data is used in organizations include:<\/p>\n
Decision-making: Data is used to inform business decisions by providing insight into trends, patterns, and relationships. This can help organizations make more informed and data-driven decisions.<\/p>\n
Business operations: Data is used to support a wide range of business operations, such as sales, marketing, finance, and human resources. For example, data can be used to track customer interactions, forecast demand, optimize production processes, and measure employee performance.<\/p>\n
Performance measurement: Data is used to measure organizational performance in various areas, such as financial performance, customer satisfaction, and employee engagement. This can help organizations understand how they are performing and identify areas for improvement.<\/p>\n
To ensure that data is effectively used in an organization, it is important to have solutions in place related to the creation, storage, and management of organizational data. Some specific solutions that organizations can consider include:<\/p>\n
Data governance: Establishing policies and processes to ensure that data is collected, stored, and used in an ethical and compliant manner.<\/p>\n
Data quality management: Implementing processes to ensure that data is accurate, complete, and consistent.<\/p>\n
Data security: Protecting data from unauthorized access or misuse through the use of measures such as encryption, access controls, and backup and recovery procedures.<\/p>\n
Data storage and management: Implementing systems and tools to store and manage data in a way that is efficient and scalable. This can include the use of databases, data warehouses, and cloud storage solutions.<\/p>\n
Data analytics: Using tools and techniques to analyze data and extract insights that can inform decision-making and support business operations.
\nb) Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.
\nc) Apply contemporary database modelling to identify and address anomalies in data and recommend solutions.
\nSubmission 12 Week Cycle: Due by 11:55pm AEST\/AEDT Sunday end of Module 6.1 (Week 11)
\n6 Week Cycle: Due by 11:55pm AEST\/AEDT Sunday end of Module 6.1
\nWeighting 35%
\nTotal Marks 100 Marks
\nTask Summary
\nThis 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:
\na) Appropriate modelling plus any business rules or assumptions
\nb) SQL commands to
\n\u2022 physically implement your logical model
\n\u2022 populate the database
\n\u2022 retrieve meaningful information
\nc) Visualizations that can be presented at a board meeting
\nContext
\nThis assignment brings together all the learning gained over the duration of this subject. The skills and knowledge you\u2019ve 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.
\nTask Instructions
\n1. Group Formation and Registration
\n\u2022 Form groups of 3 members.
\n\u2022 The deadline for team registration is 11:45pm AEST Friday end of Module 2.2
\n\u2022 To register your team, you are required to send your Learning Facilitator an email with \u201c[MIS602] Group Registration\u201d 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.
\n\u2022 You are required to send the registration email to your facilitator before the registration deadline.
\n\u2022 After the registration deadline, those students who are not in a team will be allocated to a group by the Learning Facilitator.
\n2. Case Study
\nPlease read the attached MIS602_Assessment 3_Case Study.
\n3. Database Case Study Report
\nBased 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.
\n4. The database case study report should include the following elements:
\na) ER diagram, relational model and associated business rules and assumptions b) SQL commands to:
\n\u2022 Create tables and Insert sample data rows into each table
\n\u2022 SQL queries to provide business insights At least one of each of the following is required:
\n\u2022 SELECT Question Assignment with a condition
\n\u2022 GROUP BY Question Assignment
\n\u2022 JOIN Question Assignment o NESTED Question Assignment
\nFor each Question Assignment explain its business value i.e. what business question does the result answer? Does it save money\/more efficient process?
\nc) At least two visualizations with an explanation of its business value.
\nFor each visualization explain its business value. E.g. does the visualization highlight savings in time or money?
\nReferencing
\nIt 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
\nSubmission Instructions
\n1. Graded submission: Group submission
\nSubmit Assessment 3 via the Assessment link in the main navigation menu in MIS602 Data Modelling and Database Design. On behalf of the team, only one member will submit. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
\n2. Peer Assessment: Individual Submission
\nEach individual student is to submit a completed team participation score matrix document in the Assessment 3 \u2013 Peer Assessment submission link. Please submit your peer review correctly as no submission may result in a zero grading for this assessment criteria.
\nAcademic Integrity Declaration
\nWe 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
\nProcedure viewable online at http:\/\/www.torrens.edu.au\/policies-and-forms
\nWe are aware that we need to keep a copy of all submitted material and their drafts, and we will do so accordingly.
\nAssessment Rubric
\nAssessment Criteria Fail
\n(Unacceptable) 0-
\n49% Pass
\n(Functional)
\n50-64% Credit (Proficient) 65-74% Distinction
\n(Advanced)
\n75 -84% High Distinction
\n(Exceptional)
\n85-100%
\nER diagram
\nRelational model Associated business
\nrules and
\nassumptions
\n30% Limited entities and relationships identified. Limited entities converted to tables. No list of assumptions\/ business rules. Most entities identified and labelled. Most relationships identified.
\nIdentified Entities converted to tables.
\nMost fields listed. Design is in third normal form. List of assumptions\/business rules.
\nAll entities identified and labelled. All relationships identified. Most cardinality is correct. Most participation is correct. All entities converted to tables. All fields listed.
\nMost many-to-many relationships deconstructed into new tables. Primary keys correctly underlined. All relationships meaningfully labelled. Primary key labelled for entities.
\nAll cardinality is correct. All
\nparticipation is correct. All many-to many 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.
\nWell-presented ER diagram, relational model, associated business rules and assumptions.
\nSQL commands
\n45% 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.
\nAdditional queries provided. Queries exhibit extra detail e.g. advanced
\nfiltering calculations join with more than two tables. Additional queries provided.
\nAll SQL is well formatted.
\nOverall, well presented.
\nVisualisation with an explanation
\n15% Minimum visualisations provided with no business value statements. Minimum visualizations provided. Business value statements provided Axes well labelled.
\nLegends well labelled. One
\nvisualization is an aggregation. Additional visualization provided. Additional features utilized e.g. calculations Additional visualization provided. Overall, well presented visualisation with an explanation.
\nAssessment 3, MIS602 Page 4 of 5
\nPeer Assessment 10% Showed limited efforts and contribution to the team. Other team completed tasks agreed for this team member to ensure project ( help with nursing paper writing from experts with MSN & DNP degrees) was finalised. Has fulfilled part of the agreed tasks and overlooked others. Has not initiated tasks or contributed substantially to group effort. A passive member of the group. Contributed to the group effort as per agreed tasks with minimal effort, but did not go beyond that. Very valuable member of the group actively contributing to the group effort and assessment tasks Peer member of the group
\ntakes initiative and extensively contributing to the group assessment effort.
\nAssessment 3, MIS602 Page 5 of 5<\/p>\n","protected":false},"excerpt":{"rendered":"
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\u2026<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9022,4791,8770],"tags":[9983],"class_list":["post-117663","post","type-post","status-publish","format-standard","hentry","category-assessment-assignment-help","category-assessment-brief-task-help","category-assessments-help","tag-assessment-database-case-study-report"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/117663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=117663"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/117663\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=117663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=117663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=117663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}