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

  Write paper on compact smartphone

This is a phone that is not like the other phone. In many of this phone is unique, compact smartphone, that is a strong black sleek hand held machine, and when the eyes was laid on it, they were sated, and I had to have it.

  Erp systems important to organizations and components

Why are ERP systems important to organizations? What are the typical components of an ERP system?

  The failure of cop (community of practise)

the failure of CoP (community of practise), a paragraph focus on the failure reason and solution of the failure factor, the factor is management factors: 1: lack of management support. 2.too much support (too much control, participant be forced to do..

  Evaluate the key features/properties of language.

Evaluate the key features/properties of language.

  Planning and decision making

Types of Information Technology Capabilities and Competitive Advantage

  Should changes be made to the no child left behind act?

Research Topic: Should changes be made to the No Child Left Behind Act?

  Product satisfaction: does the "magic" last?

Product satisfaction: Does the "magic" last? (one page at least 275 words)  write two pages, any organization or institution

  Explain the use of silence suppression

Write down the 500-word paper which describes what silence suppression is, why silence suppression is used, what could be utilized instead of silence suppression.

  Current events and u.s. diplomacy

This assignment shows Current Events and U.S. Diplomacy.

  N payout to a sports professional

Why is it easier to explain a $2 million payout to a sports professional for working 4 days to win a Masters Championship than it is to explain why William Clay Ford made $30 million as CEO of Ford Motor Company?

  Television news or talk show that has an argumentative form

Choose any television news or talk show that has an argumentative format and subject matter.

  Introduction to humanities

Introduction to Humanities Evaluate modernity as a shaping force in nineteenth-century Western civilization, noting both its postive and negative effects as relected in the works of artists and thinkers of the industrial age.

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