1. Compare the operation of EPB systems with EBPP systems. Explain their similarities and differences. 2. 3....
Question:
1. Compare the operation of EPB systems with EBPP systems. Explain their similarities and differences.
2.
3.
In a discussion with a colleague the following statement is made to you: ?I was explaining data flow diagrams to our client this morning. It took a while but eventually they got the idea that all internal entities must be within the organization. Similarly, all external entities must be outside the organization. How much more simple can it be??
Required
(a) Evaluate the extent to which your colleague is correct.
(b) Justify whether your colleague is right or wrong, using references to the definition of internal and external entities, and use an example to illustrate your position.
You are expected to research your answers by going beyond the textbook or this Model site. All sources that you use must be referenced in-text, and placed in the reference list here.
ONF 1NF Student number 38214 38214 69173 69173 69173 Student number 38214 38214 69173 69173 69173 4.3 Part A: Below is a table for a university database. Course number FM6000 AIS7909 AIS7909 FR8204 RM7000 Course number FM6000 AIS7909 AIS7909 FR8204 RM7000 Course title Financial Modelling Accounting Information Systems Accounting Information Systems Environmental Accounting Research Methods Course title Financial Modelling Accounting Information Systems Accounting Information Systems Environmental Accounting Research Methods Instructor number 1 2 2 3 4 Instructor number 1 2 2 3 4 Instructor name AARON KARIN KARIN HELEN KEN Instructor name AARON KARIN KARIN HELEN ΚΕΝ Instructor location 927 947 947 935 327 Instructor location 927 947 947 935 327 Grade A C A B C Grade A C A B C 1NF with dependency arrows Student number 38214 38214 69173 69173 69173 Course number FM6000 AIS7909 AIS7909 FR8204 RM7000 Course title Financial Modelling Accounting Information Systems Accounting Information Systems Environmental Accounting Research Methods Instructor number 1 2 2 3 4 Instructor name AARON KARIN KARIN HELEN KEN Instructor location 927 947 905 935 327 Grade A C A B C In first normal form, student number and course number have been chosen as a primary key to uniquely identify each line in the table. 2NF Student table: Student number Course table: Course number, Course title, Instructor number, Instructor name, Instructor location Student course (enrolment table): Student number, Course number, Grade Note that the student table has no attributes in this problem. However, as discussed in the chapter, when forming the enterprise model for the business it is likely that in combining tables the student table will have attributes such as student name, student phone number and student address. Even though the student table does not have attributes in this problem, it is important and should not be deleted. Remember that when the full enterprise model is formed it is likely that this table will have attributes. There is a dependency arrow from instructor name to instructor number and from instructor location to instructor number. Therefore, we have a transitive dependency: instructor name is dependent on the primary key, course number, via the non-key attribute instructor number. The same situation arises with instructor location. To remove the transitive dependencies we need to move to third normal form. 3NF Student table: Student number Course table: Course number, Course title, Instructor number Instructor table: Instructor number, Instructor name, Instructor location Student course (enrolment table): Student number, Course number, Grade Note that to remove the transitive dependency, instructor number becomes a foreign key in the course number table (shown by a dashed line underneath the instructor number in the course table). Then instructor number becomes a primary key in its own table. The attributes instructor name and instructor location are now attributes of the instructor table. Student number Student number, Course number, Grade Course number, Course title, Instructor number Instructor number, Instructor name, Instructor location Required (a) The table has been normalised to third normal form. Explain the logic underlying the table; that is, how the university works. Comment on the entity-relationship diagram. ONF 1NF Student number 38214 38214 69173 69173 69173 Student number 38214 38214 69173 69173 69173 4.3 Part A: Below is a table for a university database. Course number FM6000 AIS7909 AIS7909 FR8204 RM7000 Course number FM6000 AIS7909 AIS7909 FR8204 RM7000 Course title Financial Modelling Accounting Information Systems Accounting Information Systems Environmental Accounting Research Methods Course title Financial Modelling Accounting Information Systems Accounting Information Systems Environmental Accounting Research Methods Instructor number 1 2 2 3 4 Instructor number 1 2 2 3 4 Instructor name AARON KARIN KARIN HELEN KEN Instructor name AARON KARIN KARIN HELEN ΚΕΝ Instructor location 927 947 947 935 327 Instructor location 927 947 947 935 327 Grade A C A B C Grade A C A B C 1NF with dependency arrows Student number 38214 38214 69173 69173 69173 Course number FM6000 AIS7909 AIS7909 FR8204 RM7000 Course title Financial Modelling Accounting Information Systems Accounting Information Systems Environmental Accounting Research Methods Instructor number 1 2 2 3 4 Instructor name AARON KARIN KARIN HELEN KEN Instructor location 927 947 905 935 327 Grade A C A B C In first normal form, student number and course number have been chosen as a primary key to uniquely identify each line in the table. 2NF Student table: Student number Course table: Course number, Course title, Instructor number, Instructor name, Instructor location Student course (enrolment table): Student number, Course number, Grade Note that the student table has no attributes in this problem. However, as discussed in the chapter, when forming the enterprise model for the business it is likely that in combining tables the student table will have attributes such as student name, student phone number and student address. Even though the student table does not have attributes in this problem, it is important and should not be deleted. Remember that when the full enterprise model is formed it is likely that this table will have attributes. There is a dependency arrow from instructor name to instructor number and from instructor location to instructor number. Therefore, we have a transitive dependency: instructor name is dependent on the primary key, course number, via the non-key attribute instructor number. The same situation arises with instructor location. To remove the transitive dependencies we need to move to third normal form. 3NF Student table: Student number Course table: Course number, Course title, Instructor number Instructor table: Instructor number, Instructor name, Instructor location Student course (enrolment table): Student number, Course number, Grade Note that to remove the transitive dependency, instructor number becomes a foreign key in the course number table (shown by a dashed line underneath the instructor number in the course table). Then instructor number becomes a primary key in its own table. The attributes instructor name and instructor location are now attributes of the instructor table. Student number Student number, Course number, Grade Course number, Course title, Instructor number Instructor number, Instructor name, Instructor location Required (a) The table has been normalised to third normal form. Explain the logic underlying the table; that is, how the university works. Comment on the entity-relationship diagram.
Expert Answer:
Accounting Systems and Information Assurance 1 Similarity i Both EPB and EBPP have the capacity to accelerate the cash flow generate savings in particular operations and lessen the cost of customer se... View the full answer
Foundations of Financial Management
ISBN: 978-1259194078
15th edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen
Students also viewed these finance questions
-
While going to work this morning off site from his office, an engineer accidently ran a stop sign and was in a car accident that resulted in the death of a 5-year-old child. He has a strong belief in...
-
Loida Carino has a gross compensation income of Php 69,605. She is single. The amount of her nontaxable income is Php 5,700 and her tax withheld is Php 16,200. What is the amount of his total...
-
How are external and internal agents modeled in REA diagrams for transactions that involve purely internal exchanges, such as raw material moving into production?
-
For each of the statements, state the null and alternative hypotheses The average age of taxi drivers in New York City is 36.3years. The average IQ of disc jockeys is greater than 117.3. The average...
-
Corn has 10 chromosomes per set, and the sporophyte of the species is diploid. If you performed a karyotype, what is the total number of chromosomes you would expect to see in the following types of...
-
Examine the five pairs of data points given in the following table. a. What is the mathematical relationship between X and Y? b. Show by computation that, for the straight-line regression of Y on X,...
-
Using the steps outlined in the five-step transaction analysis, record the following transactions in the general journal for Laverden Plumbing, Inc. Explanations are not required. May 1 5 Paid...
-
A data set of 5 observations for Concession Sales per person ($) at a theater and Minutes before the movie begins results in the following estimated regression model: Sales = 4.3 + 0.265 Minutes. The...
-
What are the interest cost and the total amount due on a six - month loan of $ 1 , 5 0 0 at 8 percent simple annual interest? ( Do not round your intermediate calculations. Round your final answers...
-
Ray Flagg took out a 60-month fixed installment loan of $12,000 to open a new pet store. He paid no money down and began making monthly payments of $232. Ray's business does better than expected and...
-
For which of the following transactions would the use of the present value of an annuity due concept be appropriate in calculating the present value of the asset obtained or liability owed at the...
-
What three methods often are used to describe internal control systems?
-
What is a job time control sheet? What information is contained on this sheet?
-
Why are auditors concerned about the documentation of corrective actions as well as the performance of those actions? Explain the effect upon follow-up procedures.
-
What are the advantages and the disadvantages of narrative descriptions of internal control systems?
-
How is an auditor likely to find out to which audit projects he or she is to be assigned?
-
Opportunity costs are the potential benefits a person or company forgoes when choosing one alternative over others. Both business decisions and personal decisions can have opportunity costs. While...
-
What is the difference between adsorption and absorption?
-
## Challenge 3 ########## # Combining what we learned #we've learned a lot over the last few weeks. Let's put that to use # Create a code block which consists for a function to average grades #The...
-
Precision Systems had sales of $820,000, cost of goods of $510,000, selling and administrative expense of $60,000, and operating profit of $103,000. What was the value of depreciation expense? Set...
-
The yield to maturity for 10-year bonds is as follows for four different bond rating categories: The bonds of Falter Corporation were rated as Aaa and issued at par a few weeks ago. The bonds have...
-
The Griggs Corporation has credit sales of $1,200,000. Given the following ratios, fill in the following balance sheet. Total assets turnover 2.4 times Cash to total assets 2.0% Accounts receivable...
-
a. Nonlinearity in mass b. Nonlinearity in damping c. Linear equation d. Nonlinearity in spring \(\ddot{x}+f \frac{\dot{x}}{|\dot{x}|}+\omega_{n}^{2} x=0\)
-
The equation of motion of a nonlinear system is given by \[\ddot{x}+c \dot{x}+k_{1} x+k_{2} x^{2}=a \cos 2 \omega t\] Investigate the subharmonic solution of order 2 for this system.
-
Prove that, for the system considered in Section 13.5.1, the minimum value of \(\omega^{2}\) for which the amplitude of subharmonic oscillations \(A\) will have a real value is given by...
Study smarter with the SolutionInn App