Reference no: EM133585631
Database Systems
Objectives
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.
Synthesize user requirements/inputs and analyse the matching data processing needs, demonstrating adaptability to changing circumstances;
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.
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
Identify functional dependencies, referential integrity, data integrity and security requirements; Further integrate and merge physical design by applying normalization techniques;
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.
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. Discuss the 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.
Presentation and Participation
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.