This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to improve student knowledge through further research on recent trends to demonstrate competence in tasks related to modelling, designing, implementing a DBMS, Data Warehousing, Data management, Database Security. Also, to enhance students experience in researching a topic based on the learning
outcomes they acquired during lectures, activities, assignment 1 and assignment 2. Furthermore, to evaluate their abilityto identify the latest research trends and writing a report relevant to the Unit of Study subject matter. This assessment covers the following LOs.
1. Synthesize user requirements/inputs and analyse the matching data processing needs, demonstrating adaptability to changing circumstances;
2. Develop an enterprise data model that reflects the organization’s fundamental business rules; refine the conceptual data model, including all entities, relationships, attributes, and business rules.
3. Derive a physical design from the logical design taking into accountapplication, hardware, operating system, and data communications networks requirements; further use of data manipulation language to query, update, and manage a database
4. Identify functional dependencies, referential integrity, data integrity and security requirements; Further integrate and merge physical design by applying normalization techniques;
5. Design and build a database system using the knowledge acquired in the unit as well as through further research on recent trends to demonstrate competence in various advanced tasks with regard to modelling, designing, and implementing a DBMS including Data warehousing, Data Management,DB Security.
Note: Group Assignment. Maximum 4 students are allowed in a group.
INSTRUCTIONS
These instructions apply to both the Report and Presentation assessments.
For this component you will be required to select a published research article / academic paper which must cover one or more of the topics including Database modelling, designing, and implementing a DBMS including Data warehousing, Data Management, DB Security, Data Mining or Data Analysis. The paper you select must be directly relevant to these topics. The paper can be from any academic conference or other relevant Journal or online sources such as Google Scholar, academic department repositories etc. All students are encouraged to select a different paper; and it must be approved by your lecturer or tutor before proceeding. In case two groups are wanting to present on the same paper, the first who emails the lecturer or tutor with their choice will be allocated that paper.
Report – 20% (Due week 12)
For this component you will prepare a report or critique on the paper you chose as mentioned above.
Your report should be limited to approx. 1500 words (not including references).Use 1.5 spacing with a 12-point Times New Roman font. Though your paper will largely be based on the chosen article, you can use other sources to support your discussion. Citation of sources is mandatory and must be in the Harvard style.
Your report or critique must include:
Title Page: The title of the assessment, the name of the paper you are reviewing and its authors, and your name and student ID.
Introduction: A statement of the purpose for your report and a brief outline of how you will discuss the selected article (one or two paragraphs). Make sure to identify the article being reviewed.
Body of Report: Describe the intention and content of the article. Discussthe research method (survey, case study, observation, experiment, or other method) and findings. Comment on problems or issues highlighted by the authors. Discuss the conclusions of the article and how they are relevant to what you are studying this semester.
Conclusion: A summary of the points you have made in the body of the paper. The conclusion should not introduce any ‘new’ material that was not discussed in the body of the paper. (One or two paragraphs)
References: A list of sources used in your text. Follow the IEEE style. The footer must include your name, student ID, and page number.
Presentation and Participation – 10% (weeks 9-12)
For this component a group (all members of the group) will be required to do a 5 – 10 minutes presentation based on a selected research article.
A grade of 10% of the Unit mark will be awarded for your presentation. Prepare a PowerPoint slides for your presentation.
You must upload the recorded presentations in the link provided on the LMS.
Only the group leader has to submit the recorded presentation file. All recorded presentation of individual members must be merged in to one file if recorded individually.
What to Submit – Only the group leader must submit the report and recorded presentation file.
Report
Submit your report in a file named Report-xxxxxxx.doc (where xxxxxxx is your student ID) by the due date and time.
Presentation and Participation
Group leader must upload the recorded presentations in the link provided on the LMS.
Group Participation Form
Group leader must upload the filled group participation form in the link provided on the LMS.
Please note: Please be informed that the concerned Lecturer may schedule a Viva Voce for a whole group with respect to work done for the Assignment 3.
Marking Rubric
Marking Guide: CATEGORY
Unacceptable
Acceptable
Good
Excellent
1. Introduction
(Weightage 10%)
1.1 Topic
Does not adequately convey topic.
Conveys topic, but
not key question(s).
Conveystopic and
key question(s).
Strong introduction of topic’s key
question(s), terms.
1.2 Subtopics
Does not describe
subtopics to be
reviewed.
Describes subtopics to be reviewed.
Clearly delineates
subtopics to be
reviewed.
Clearly delineates
subtopics to be
reviewed.
1.3 Research
statement
Lacks adequate
research statement.
General research
statement.
General research
statement.
Specific research
statement.
2. Focus &
Sequencing
(Weightage 30%)
2.1 Focus
Little evidence
material islogically
organized
into topic,subtopics or related to topic.
Most material clearly related to subtopic, main topic. Material may not be organized within subtopics.
All material clearly
related to subtopic, main topic and
logically organized
within subtopics.
All material clearly
related to subtopic, main topic. Strong
organization and
integration of
material within
subtopics.
2.2 Sequencing
Many transitions are unclear or non
existent.
Attemptsto provide variety of
transitions
Clear, varied
transitions linking
subtopics, and main topic.
Strong transitions
linking subtopics, and main topic.
3. Support
(Weightage 30%)
Few sources
supporting research topic. Sources
insignificant or
unsubstantiated.
Sources generally
acceptable but not
peer-reviewed
research
(evidence) based.
Sources well selected to support report
topic with some
minor issues.
Strong peer reviewed based papers to
support research
topic.
4. Conclusion
(Weightage 15%)
Does not summarize evidence with respect to research topic.
Does not discuss the impact of researched material on topic.
Review of key
conclusions. Some
integration with
research topic.
Discusses impact of researched material on topic.
Strong review of key conclusions. Strong integration with
research topic.
Discusses impact of researched material on topic.
Strong review of key conclusions. Strong integration with
research topic.
Insightful discussion of impact of the
researched material on topic.
5. Grammar &
Mechanics
(Weightage 2.5%)
Grammatical
errors or spelling &
punctuation
substantially detract from the report.
Very few
grammatical, spelling or punctuation errors interfere with reading the report.
Grammatical errors or spelling &
punctuation are rare and do not detract
from the report.
The paper is free of grammatical errors and spelling &
punctuation.
6. Style &
Communication
(Weightage 2.5%)
Errors in style
detracts substantially from the paper. Word choice is informal in tone. Writing is
choppy, with many awkward or unclear passages.
Errors in style is
noticeable. Word
choice occasionally informal in tone.
Writing has a few
awkward or unclear passages.
Rare errors in style that do not detract from the report.
Scholarly style.
Writing has minimal awkward of unclear passages.
No errorsin style.
Scholarly style.
Writing is flowing and easy to follow.
7. Citations &
References
(Weightage 10%)
Reference and
citation errors detract significantly from
report.
Two references or
citations missing or incorrectly written.
One reference or
citations missing or incorrectly written.
All references and
citations are correctly written and present.
Note: The above Rubric is based on the assumption that students will choose their research article which will cover the one or more of the following topics:
• Database modelling
• Database designing
• Implementing a DBMS
• Data warehousing
• Data Management
• DB Security
• Data Mining
• Data Analysis