ISYS2038 Database Design and Development
Lecture 12 – Final Assessment (Individual, 50%)
Final Assessment
• See Canvas > Assignments for the release of questions of final assessment and also submission due date and time. Course coordinator will also make an announcement when the final assessment is released.
• The final assessment is a piece of assignment and will cover topics from Week 1 to Week 11. Questions
will be related to a case study. In addition, you are not required to login to MySQL server to work on the assignment.
• As this is an individual final assessment, you’re not able to consult with anyone and/or assist anyone in completing the assessment.
RMIT University© School of Accounting, Information Systems and Supply Chain 2
Final Assessment
• Please note that the mark, rubric and feedback of final assessment WILL NOT be released via Canvas. Instead, you will get a final result and grade for the course on the University official result release date. From the final result of the course, you will be able to work out your mark of your final assessment.
• Please note that as this final assessment IS
NOT online timed exam and timed exam at a physical location, therefore this course WILL NOT appear in the exam schedule.
RMIT University© School of Accounting, Information Systems and Supply Chain 3
Final Assessment
• Marking rubric will show the mark out of 100 points and the total mark will then be converted to 50%.
• Questions are based on a provided 1-page case study and cover the following:
–Data Modelling: ERD, Relational Model with data types
–SQL Queries with justifications and explanations
–Data Analytics using Orange with discussion
–Discussion related to Database Administration Approaches
–Discussion related to Big Data and Analytics
RMIT University© School of Accounting, Information Systems and Supply Chain 4
Data Modelling
• Ensure good quality of images for both diagrams with readable font size.
• Free to use any diagramming tool.
• Apply third normal form (3NF)
• Show consistency in the use of notation – use either Chen notation or Crows Feet notation
• Optional – make use of Appendix section to include assumptions/ justifications for your design as you see fit.
RMIT University© School of Accounting, Information Systems and Supply Chain 5
Data Modelling
• ERD
–For each entity, provide at least one attributes/ fields with a maximum of two attributes (excluding primary key)
–Allow to show features of EER if you see fit • Relational Model
–Show the most appropriate attributes/ fields, primary keys and foreign keys.
–Include the data type for each attribute/ field listed in each table/ entity.
RMIT University© School of Accounting, Information Systems and Supply Chain 6
SQL Queries
• Do not require the use of MySQL server to work on the SQL statements – no creation of tables and records and execution of scripts.
• Provide three SQL queries based on your ERD and Relational Model.
• For each query, provide justifications for the business purpose
–What is its business values/ impact/ implications to the company in addition to what it does for the company
RMIT University© School of Accounting, Information Systems and Supply Chain 7
SQL Queries
• For each query, provide explanations for the design of SQL query
–Explain each line of your query
–Make use of table(s) with sample data to explain the
potential output
• Requirements of SQL queries are like Team Assignments, for example:
–One of the 3 queries need to show the use of JOIN and NESTED
• Remember to keep entities/tables, attributes/fields
consistent with your data model. Pay close attention to
the syntax and structure of your queries.
RMIT University© School of Accounting, Information Systems and Supply Chain 8
Data Analytics using Orange
• Dataset related to the case study will be provided
• You are required to use Orange to perform visualisation
and prediction
• Do not use other data analytics tools
• Take print screens or figures of Orange workflow, visualisations to support your explanations
• Check the RMSE values for different prediction techniques and organise the results in tabular format to support your explanations
RMIT University© School of Accounting, Information Systems and Supply Chain 9
Discussions
• Two questions are related to the discussions on: –Database Administration Approaches
–Big Data and Analytics
• Need to provide and articulate your discussions in relation to the case study.
• You are allowed use web resources (e.g. research articles, white papers, news, etc.) as supporting examples but you need to tie/ relate the discussion of these resources to the case study.
• Make you use Reference section if you are using web resources to support your discussions.
RMIT University© School of Accounting, Information Systems and Supply Chain 10
Discussions
• No maximum or minimum number of references – you include the references as you see fit.
• If you are using the web resources to support your discussion, you must cite to avoid plagiarism.
• Use Harvard referencing style if you are citing the web resources.
RMIT University© School of Accounting, Information Systems and Supply Chain 11
Submission
• Word Limit: 1500 – 2000 words +/- 10% (excluding Table of Content, Appendix, figures, tables and screenshots, anything beyond word limit will not be marked)
• Font Size: 11pt or 12pt
• Font Style: Calibri or Times New Roman
• Spacing: Single or 1.5 Spacing
• Organise the report according to sections and subsections
• Submit as a zip file for all files (e.g. Excel files, Orange file, Report in PDF, etc.).
• See more details in Individual Assignment Specification
RMIT University© School of Accounting, Information Systems and Supply Chain 12
Thank You, Good Luck and All The Best!!