Database design concepts

Assignment Help Term Paper
Reference no: EM13138626

The exam contains seven (7) questions. Four (4) questions are short answer/essay style theory questions, three (3) questions require you to analyse graphical documentation. You need to be able to read DFDs and Flowcharts to complete these questions. Further information about each question is provided later in this document. Please read this document carefully as you are provided with question 3. It is expected that you will prepare an answer to this question as you revise the material. 
The short answer questions vary. The questions may ask you to explain, describe, list, state, compare, contrast, critically evaluate, and/or recommend. If a question asks you to illustrate your answer with an example, illustrate does NOT mean to draw, it means to provide a written example and use it to demonstrate or support your argument. 
Make sure you read each question carefully.Underline important parts of the question. 
Answer only what the question asks. Some questions have several dot points that you need to address - pay attention to these. Make sure you address these. A brain dump of everything you know will not get you any marks!Take the time, think, and plan your answers. Use the marks as a guide for the time you should spend on the question. For most questions, the time includes thinking and writing time. The space provided should not be used as a guide for the length of the answer required; more space is provided than you should be needed. If you need additional space, ask for an exam script booklet. 
For the process analysis questions you will be provided with a graphical depiction of a process. For these questions, you will not be given a written narrative. Examples are available in the lectures, tutorials and in the prior year exam papers available on the LMS. You will need to analyse the documentation and answer the questions. To answer the question you will need to draw on your knowledge of the generic processes covered in the lecture. Remember, what is not documented is often as important as what is documented (i.e., you need to apply your knowledge of what you know should be there to reduce the risks, versus what is there). 

To do well in the exam, you need to know: 
x Database design concepts; 
x Alternative processing modes; 
x Information quality goals; 
x How to readdataflow diagrams and flowcharts; 
x The typical activities, objectives, risks and control plans of the order-to-cash (revenue) and purchase-to-pay (expenditure) processes and how these feed into the financial statements; and 
x A detailed understanding of the information risks and internal controls from each of these processes, particularly the control plans we covered in detail in the lectures and tutorials. 
How to study for the exam: 
(1) Review the learning objectives for the subject and each week's material. 
(2) Review the lecture material and the readings; make summary notes of the key activities, risks, and control plans we covered. Take notes for question 3 as you revise all material. 
(3) Attempt the analysis exercises that were completed in the lectures. 
(4) Review and reattempt the tutorial questions. 
(5) Attempt prior exam papers and draft an answer for question 3. 

Question 1 - Database design ER Diagram, anomaly.
Question 2 - Information goals, misstatement, internal control 
Question 3 - (14 marks) 
The question is provided below. Because this question is being provided before the exam, tutors or I will NOTdiscuss this question with students. I have provided it as it is a very broad question which you can use to reflect on the course material overall. Because you were given the question beforehand, it will be marked to a higher standard than if it was unseen. 
When preparing your answer, remember that it worth 14 marks, you should not spend more than 25 minutes on this question, that includes writing time and time to re-read the question. 
We are looking for succinct answers that integrate material from across the whole semester (not just week 4), that demonstrate reflection and understanding of the material in their discussion of the statement below: 
An organisation's 'tone at the top' determines the effectiveness of the process level control plans. These process level control plans ensure that the financial statements are not misstated. 
Discuss the accuracy of this statement. 
In your answer, include the following aspects: 
x Discuss the role of internal control; 
x Explainand discussthe purpose and impact of 'tone at the top'; 
x Explainand discussthe purpose and operation of process level control plans; 
x Illustrateyour answer with examples that demonstrate the effectiveness or ineffectiveness of 'tone at the top' and process level control plans in achieving reliable financial statements. 
x Your answer should integrate the material covered across the whole semester 
Question 4 - Control plan analysis and evaluation (9 marks) 
Question 5 - Written analysis of the operation of preventative and detective control plans in the processes 
Question 6 - Short answer questions to be answered based on your analysis of a process depicted in a DFD
Question 7 - Using the flowchart provided, you will be required to complete a set of control analysis framework tables. See prior exam papers as a guide for the types of tables you may have to complete Written question on operational and financial risks.

Reference no: EM13138626

Questions Cloud

What would murphy corporation total estimated cost : Murphy Corporation has the following data pertaining to certain costs that cannot be easily identified as either fixed or variable. Murphy Corporation has decided to use a method of measuring cost functions called the high-low method in this situa..
Significance of the ark of the covenant : What is the significance of the Ark of the Covenant? Include Bible references.
Determine the total conversion cost : In the manufacture of 10,000 units of a product, direct materials cost incurred was $135,700, direct labor cost incurred was $82,000, and applied factory overhead was $37,500. What is the total conversion cost?
Write the analytical expression for the waveforms : What would be the initial value of v c (t) when switch is closed and determine the time constants in both cases (switch is open, switch is closed).
Database design concepts : Make sure you read each question carefully.Underline important parts of the question. Answer only what the question asks. Some questions have several dot points that you need to address - pay attention to these.
Calculating taxable income related to the machines for 2011 : Tan Company acquires a new machine (ten-year property) on January 15, 2011, at a cost of $200,000. Tan also acquires another new machine (seven-year property) on November 5, 2011, at a cost of $40,000.
How many liters of no(g) can be made : How many liters of NO(g) can be made from 17.57 L of O2(g) and 16.55 L of N2(g) at STP?
Determine consolidated totals for each of account balances : Anchovy acquired 90 percent of Yelton on January 1, 2011. Of Yelton's total acquisition-date fair value, $60,000 was allocated to undervalued equipment (with a 10-year life) and $80,000 was attributed to franchises (to be written off over a 20-yea..
How many moles of cf4 can be produced : How many moles of CF4 can be produced when 5.00 mol C react with 8.00 mol F2?

Reviews

Write a Review

Term Paper Questions & Answers

  Generation and evaluation of alternative solutions

Write two pages for "Generation and Evaluation of Alternative Solutions" for Love Canal case. Total 2 Pages for "Generation and Evaluation of Alternative Solutions" for love canal case and including references.

  Paper on deming theory

Paper on Deming theory: Dr. W. Edwards Deming developed a method for the quality improvement process. He believed that the identification and correction of defects after production is not effective.

  Paper on what does autism play in savant syndrome

Write a Paper on Topic:   What does autism play in savant syndrome?

  Write a paper on italy and its democracy

Write a Paper on Topic:  Italy and Its Democracy,  Affecting the Event by “The Economist” and  Democracy Appear to Work with including references.

  Climate change and the north

The essay topic is: Climate Change and the North (with particular Focus on the Inuit).  The purpose of this research paper is to help you engage with current events and contemporary challenges concerning Aboriginal people in Canada.

  Should manitoba adopt a single transferable vote

Write a paper on Topic: Should Manitoba adopt a single transferable vote (STV) electoral system for provincial elections?

  In crisis and reform

In Crisis and Reform:  Current Issues in American Punishment (p. 126), Alexis Durham writes,Please write a reaction paper (4-6 pages in length) to the quote in which you explore global correctional objectives

  Role play as the corporate social responsibility officer

Your Corporate Social Responsibility Officer  Handout and Rubric, This paper gives you an opportunity to "role play" as the Corporate Social Responsibility Officer for an organization of your choice.

  Operationalize sustainability

This assignment is designed for you to analyze an organization and to help develop a plan for that organization to better Operationalize sustainability in the future.

  Gulliver''s view of science

Write on  Gullivers view of science or politics, Jonathan Swift’s view about science is explicitly portrayed in this novel Gulliver’s travel. Jonathan swift says the scientific researches and the experiments will be utter waste of time and it will be..

  Designing a computer interface with visual disability

The topic is about designing a computer interface to people with visual disability (blindness- colour blindness) also , how to apply decision support systems to such interfaces..

  Social issue

Answer the following questions as these general questions pertain to the specific issue selected.The questions that you will cover with respect to your choice of broad social issue in the paper are given.

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