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...
-
Use the 175 ranked axial loads of aluminum cans. Find the percentile corresponding to the given value. 265
-
A uniform magnetic field of 0.50 T is directed to the north. At some instant, a particle with charge +0.020 C is moving with velocity 2.0 m/s in a direction 30 north of east. (a) What is the...
-
On September 30, balances in Manufacturing Overhead are: Wendy Company- debit \($1,800\), Mahmoud Company-credit $3,000: Indicate how each company should re- port its balance at September 30,...
-
On January' 1, Lorain Corporation had 2,000 shares of $5 par common stock LO 15.7 authorized and outstanding. These shares were originally issued at a price of $26 per share. In addition, 500 shares...
-
Let f(x)=x+3x - 189x+6. Use the definition of a derivative or the derivative rules to find f'(x). f'(x) = Use the definition of a derivative or the derivative rules to find f"(x). f"(x)= On what...
-
The field is less sharply defined. There is heavier use of economics, decision sciences, and behavioral sciences. Identify the branch of accounting described in the quotation.
-
The return on net worth (RONW) ratio is based on a retailer's ________. a. gross margin and operating costs as a percent of sales b. net profit margin and asset turnover c. net profit margin and...
-
Key comparative figures for Apple and Google follow. Apple Current Current $ millions Year Net sales. $265,595 Cost of sales $163,756 Prior Year $229,234 $141,048 Year $136,819 $ 59,549 Google Prior...
-
Imagine that you are the Licensed Nursing Home Administrator of a fairly dated nursing facility that is in disrepair. You have a limited budget that can only support improvements to either the...
-
The rate of heat production in a typical passenger car with an internal combustion engine is?
-
150 cubic meters of air per minute at 35 C dry bulb and 25 C wet bulb temperature are to be cooled to 22 C. Determine the tons of refrigeration.
-
The Sedona company has six servers in its datacenter. Maintenance of the servers is handled by Mike, a system administrator who works for the company. The time between server failures follows Poisson...
-
College tuition: A simple random sample of 35 colleges and universities in the United States has a mean tuition of $19,400 with a standard deviation of $10,300 Construct an 80% confidence interval...
-
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...
-
How do teams work?
-
Task characteristics, reward systems, and team size are all ____________ that can make a difference in group effectiveness. (a) group processes (b) group dynamics (c) group inputs (d) human resource...
-
When a new team member is anxious about questions such as Will I be able to influence what takes place? the underlying issue is one of ____________. (a) relationships (b) goals (c) processes (d)...
Study smarter with the SolutionInn App