Identify functional dependencies and referential integrity

Assignment Help Database Management System

Reference no: EM133544377

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 ability to 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 account application, 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.

INSTRUCTIONS
These instructions apply to the Research Report assessments.

For this component you will be required to select a research article / academic paper which must cover one or more of the topics including, but not limited to, 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 (Selected papers must be from 2018 to 2023); and it must be approved by your lecturer or tutor before proceeding. In case two students are wanting to present on the same paper, the first who emails the lecturer or tutor with their choice will be allocated that paper.

Research Report
For this component you will prepare a report or critique on the paper.

Your report 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 IEEE 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. If it is a research report, 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. They should be listed alphabetically by (first) author's family name. Follow the IEEE style. The footer must include your name, student ID, and page number.

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.

Reference no: EM133544377

Questions Cloud

How you will use this data to develop a balance sheet : How you will use this data to develop a Balance Sheet, Profit and Loss Statement, and Cash Flow Statement. Refer to the course text for additional guidance.

Define validity and reliability : Define validity and reliability. Give two examples of evidence that may be obtained for each. You are a member of a nursing education program faculty

Define measurement-norm and criterion-referenced evaluation : Define assessment, test, measurement, norm- and criterion-referenced evaluation, and formative- and summative evaluation.

Create a new pivottable showing income average for each year : Create a new PivotTable showing Income Average for each Year. Create a PivotTable which shows Average Yearly Income with Tax in the Rows and Income in Columns.

Identify functional dependencies and referential integrity : Identify functional dependencies, referential integrity, data integrity and security requirements; Further integrate and merge physical design by applying

What was the resolution or outcome of this dilemma : Identify the ethical dilemma you were faced with and explain why this is an ethical dilemma. What was the resolution or outcome of this dilemma?

Discuss three critical interventions upon diagnosing : What is the rationale for prescribing phenytoin for Mr. Lee? Discuss three critical interventions upon diagnosing Mr. Lee's reaction.

Describe the positions of the trade organizations : Trucker Logs, Sleep, and Safety: Describe the positions of the trade organizations and explain why the two groups have taken positions they have on black boxes.

Patient diagnosed with alcohol use disorder and diabetes : A patient diagnosed with alcohol use disorder and diabetes. The patient is currently taking Naltrexone for alcohol use disorder.

User Account

All Pages