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

  Describe the lifecycle and the age

Describe the lifecycle and the age to be in that lifecycle. Describe nutritional challenges associated with that particular lifecycle.

  What do think nora watson meant in her summary

what do think Nora Watson meant in her summary when she said "I think most of us are looking for a calling not a job. Most of us...have jobs that are too small for our spirit. Jobs are not big enough for people"

  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?

  You can describe the relationship

Before you can describe the relationship of your findings to the theory, you need to give your reader an overview of the theory. In this section provide an overview of controlling with appropriate references to support your description.

  Our ideal job interview scenario

discuss and apply what you've learned this week about proper interview techniques to create a scenario of the perfect interview environment (place, time, seating arrangements, etc.) and the perfect set of interview questions

  Edit this for grammatical errors and make it free of errors

Edit this for grammatical errors, and make it grammatically sound and free of errors.

  The growth of nursing as a knowledge-based profession

Barriers have existed, especially in the past, which have impeded the work necessary to develop the knowledge base of nursing. Many of these barriers are related to issues of gender and knowledge in a female-dominated profession like nursing.

  Domicile in england

He obtained a working visa that permits him to work in Australia for three years. He is a specialist in information technology and is employed by Systems Ltd, a resident UK company that has secured a contract in Australia.

  What is a cshp and its important for community health

What is a CSHP, and why is it so important for community health? What are some things that we can do as healthcare managers to support effective school health programming? Provide specific examples.

  Paper on day-to-day operations

Write a research paper on  Day-to-Day Operations . Industry standards and best practices are explained and utilized where appropriate. If best practices are not used an alternative is recommended.

  Practical understanding

This assignment relates to all of the course objectives but more specifically to your practical understanding and evaluation of the key issues in relation to the development of the infrastructure and functionality for an e-commerce enterprise.

  Population ecology

This perspective focuses on organizational diversity and adaptation within a population of organizations.

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