MITS4003 Database Systems Assignment

Assignment Help Database Management System
Reference no: EM132927618

MITS4003 Database Systems - Victorian Institute of Technology

Objectives(s)

This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to improve student presentation skills, 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 both the Presentation and Research Report assessments

Presentation and Participation

For this component you will be required to do a 5-10-minute presentation on an academic paper on Database Systems, Data Mining or Data Analysis. The paper you select must be directly relevant to these 3 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 must select a different paper; thus the paper 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.

A grade of 10% of the Units mark will be awarded for your presentation and your participation in other student presentations. Prepare a PowerPoint slide presentation for your presentation.

The presentations will occur in sessions 9-12 on the academic calendar and the order of presentations will be by arrangement, but these will be evenly spread over those sessions.

Research Report

For this component you will prepare a report or critique on the paper you chose from the Presentation and Participation component 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. 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 Harvard style. The footer must include your name, student ID, and page number.

Attachment:- Database Systems.rar

Reference no: EM132927618

Questions Cloud

Explain james behavior in terms of frustration : James Emery is the father of four children. He was raised in a hardworking immigrant family. His needs for achievement and power were developed while he was gro
Ensuring a safe and healthy work environment : Conduct a research about this TOPIC choosing a specific company/organization as the subject of your research study.
Recruiting and onboarding new volunteers : What are the most popular challenges with recruiting and onboarding new volunteers?
Identify the ethical standards : Identify the ethical standards. Does any company have published ethical standards? Do you know who to go to if there is an ethical violation?
MITS4003 Database Systems Assignment : MITS4003 Database Systems Assignment Help and Solution, Victorian Institute of Technology - Assessment Writing Service
Achieving diversity with inclusion : Workplace bias - both conscious and unconscious - continues to impede the hiring, development and promotion of underrepresented groups. Although many companies
Differences between public relations and journalisms : What would the fundamental differences between public relations and journalisms be?
What do you understand by the terms governance : What do you understand by the terms 'governance', 'good governance' and 'ethical governance'? Effective utilization of public funds is crucial to meet developme
Explain capital expenditure and revenue expenditure : Distinguish between Capital Expenditure and Revenue Expenditure with examples.

Reviews

Write a Review

Database Management System Questions & Answers

  Show the functional dependencies

Draw a dependency diagram to show the functional dependencies in the relation and Decompose GRADE REPORT into a set of 3NF relations

  Eliminate multivalued dependencies

Create tables as necessary to eliminate multivalued dependencies, if any.

  Evaluate capabilities of the models you have developed

Identify three new indexes and justify why they could be useful. Write the SQL code for creating these indexes under your DWUaccount

  Determine a list of n numbers has no duplicates

Express given five loosely described problems carefully in { Instance, Question } form as utilized in "Computers and Intractability". Determine that a list of n numbers has no duplicates.

  MIS609 Data Management and Analytics Assignment

MIS609 Data Management and Analytics Assignment Help and Solution, Laureate International Universities - Assessment Writing Service

  What is the best plan with nested loop joins only

Assuming relations have the same size and uniform distributions, what is the best plan with Nested Loop joins only? Write it as an algebra expression.

  Design a relational database so that it is at least in 3nf

Explain the fundamentals of how data is physically stored and accessed.Compose conceptual data modeling techniques that capture information requirements.

  1 start with checksalary trigger explain below on triggers

1 start with checksalary trigger explain below on triggers. show that that trigger creates muttating table error. in

  Describe the different procedure performed in dbms

Describe the different procedure performed in DBMS for student database in which fields are student id, student name, student class, marks.

  Draw the pie chart or line chart of data anomalies

INSS 422 - Business Intelligence - identify data anomalies that must be removed before data can be loaded in data warehouse

  Explain what would be the data load and refresh cycles

For an airlines company, identify three operational applications that would feed into the data warehouse. What would be the data load and refresh cycles

  First-stage allocation to the customer support

Would be allocated in the first-stage allocation to the Customer Support activity cost pool - Allocated in the first-stage allocation to the Order Size activity cost pool -

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd