Database Systems (MITS4003) Assignment 3 Assignment Help

 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


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.