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

  Mit/darpa dataset attack models

MIT/DARPA Dataset Attack Models The student will review the 1998, 1999, and 2000 datasets and develop attack trees for each of the included attacks. The student will then write a 5 page paper describing the results and include the attack trees as an ..

  - making decisions

What are the considerations/particularities you must take into account when - making decisions - communicating in a diverse workplace environment different from a non-diverse environment?

  Research and writing

Research and Writing: Brief Assignment,  Review the fact pattern provided below. At this time, Mr. Kant stands convicted of either petit larceny or shoplifting, as dictated by your state statutes,

  Risk assessment

Risk Assessment .- conduct a risk management assessment of one of them, for this assignment you are to conduct a risk management assessment of your own place of employment,

  Discussion on national security

Discussion on  National Security and  Current Events – Nuclear Weapons and Nuclear Energy.

  Write a paper on young adulthood

Write a paper on Young Adulthood,  Discuss the physical development of the selected individual during young adulthood. Were there observable changes in growth, strength, and physical functioning? How did lifestyle impact health?

  Abstract thoughts as to why mcclelland''s acquired

abstract thoughts as to why McClelland's acquired needs theory is a good motivational method in an organization

  Process consultation

Intervention 1: Use the process consultation intervention. Describe and explain why this intervention is useful and how it can be implemented within VRD given the facts in the case

  Research on the topic of marriage and other alternatives

Write down 3-5 page paper (in proper APA format) researching the topic of marriage and other alternatives. Divorce and common effects on family.

  Write influence of distance delivery on health care

Write down the influence of distance delivery on health care. Let the use of e-mail, telemedicine, and electronic transfer of records.

  Create mission,vision, and value statement on own health org

Create actual mission, vision, and value statements for you own health care organization department or one which you someday hope to lead. Explain your thought process in creating these statements. Your explanation should consist of at least 200 word..

  The organization you have selected

The organization you have selected for journals 1 and 2 will be used to complete assignments 1 and 2. Assume that you have been hired as a management consultant to the selected organization.

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