Objectives(s)

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

• Database modelling 

• Database designing 

• Implementing a DBMS 

• Data warehousing 

• Data Management 

• DB Security 

• Data Mining 

• Data Analysis.