b) c) d) A software house is currently embarking on the development of a system that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
b) c) d) A software house is currently embarking on the development of a system that covers the functions supporting the Procure-to-Pay process. The project team has started the System Design phase. The following is part of a description of the facts collected from the various users. A purchase order created will be sent to a selected supplier. A supplier may receive zero, one or many purchase orders. A purchase order contains at least one material. A material may be listed in zero, one or many purchase orders. A purchase order may be delivered with the materials one or many times (ie partial deliveries) A goods receipt may cover one or many purchase orders. Draw an Entity Relationship Diagram. (Note: do not resolve any many-to-many relationships) (7 marks) With reference to Question 1 a) above, use the Database Design Language (DBDL) format. describe the Purchase Order and Supplier entities. (4 marks) The following are business rules used for an insurance quotation in a car insurance system. The standard quotation will be given to an insured if his or her car is garaged and the insured is willing to pay a RM500 excess on the insurance policy. In an insurance, an excess means that the insured has to bear the first RM500 of the claim. However, the insured has the option to remove the RM500 excess clause. This will lead to his or her standard quotation being increased by 6%. If the car is not garaged, then a further RM200 is added to the standard quotation value. Construct a decision table for an insurance quotation based on the above business rules. (8 marks) A Sales system was custom made in-house by an organisation's development team. The management is particularly worried about the issue of a poor user interface for this system. Explain to the top management THREE (3) potential consequences of a poor user interface for the Sales system. (6 marks) b) c) d) A software house is currently embarking on the development of a system that covers the functions supporting the Procure-to-Pay process. The project team has started the System Design phase. The following is part of a description of the facts collected from the various users. A purchase order created will be sent to a selected supplier. A supplier may receive zero, one or many purchase orders. A purchase order contains at least one material. A material may be listed in zero, one or many purchase orders. A purchase order may be delivered with the materials one or many times (ie partial deliveries) A goods receipt may cover one or many purchase orders. Draw an Entity Relationship Diagram. (Note: do not resolve any many-to-many relationships) (7 marks) With reference to Question 1 a) above, use the Database Design Language (DBDL) format. describe the Purchase Order and Supplier entities. (4 marks) The following are business rules used for an insurance quotation in a car insurance system. The standard quotation will be given to an insured if his or her car is garaged and the insured is willing to pay a RM500 excess on the insurance policy. In an insurance, an excess means that the insured has to bear the first RM500 of the claim. However, the insured has the option to remove the RM500 excess clause. This will lead to his or her standard quotation being increased by 6%. If the car is not garaged, then a further RM200 is added to the standard quotation value. Construct a decision table for an insurance quotation based on the above business rules. (8 marks) A Sales system was custom made in-house by an organisation's development team. The management is particularly worried about the issue of a poor user interface for this system. Explain to the top management THREE (3) potential consequences of a poor user interface for the Sales system. (6 marks)
Expert Answer:
Answer rating: 100% (QA)
a Entity Relationship Diagram b Purchase Order Entity Attributes Purchase Order ID Material ID Suppl... View the full answer
Related Book For
Project management the managerial process
ISBN: 978-0073403342
5th edition
Authors: Eric W Larson, Clifford F. Gray
Posted Date:
Students also viewed these mathematics questions
-
The optical disk project team has started gathering the information necessary to develop the project networkpredecessor activities and activity times in weeks. The results of their meeting are found...
-
The CyClon project team has started gathering information necessary to develop a project network-predecessor activities and activity time in days. The results of their meeting are found in the...
-
Draw an Entity Relationship Diagram for the following scenario: PART A: The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes...
-
Google, the immensely popular Web search engine, has been touted as the closest thing the Web has to an ultimate answer machine. Although this is debatable, of course, it is far more difficult to...
-
Jasmine Gregory is a 20% member in Sparrow Properties LLC, which is a lessor of residential rental property. Her share of the LLC's losses for the current year is $100,000. Immediately before...
-
How do security dealers earn their profits?
-
A stock with current value \(S(0)=100\) has an expected growth rate of its logarithm of \(u=12 \%\) and a volatility of that growth rate of \(\sigma=20 \%\). Find suitable parameters of a binomial...
-
The Hamilton Company balance sheet on January 1, 2007 was as follows: The Korbel Company is considering purchasing the Hamilton Company (a privately held company) and discovers the following about...
-
Required information [The following information applies to the questions displayed below.] George and Wanda received $30,500 of Social Security benefits this year ($11,700 for George; $18,800 for...
-
In Part III (Appendix 11B) of the audit case, the audit staff of Adams, Barnes & Co. identified specific revenue risks on working paper RA-12 (page 494). However, the Summary of Audit Approach...
-
Tom, an Australian resident, passed away on 19 January 2021, leaving his house in Canberra to his daughter Mandy. The house was purchased by Tom on 8 May 1998 at a cost of $220,000 and he had lived...
-
Describe the importance of effective communication in your current work/role?
-
Do you consider your daily texting, Facebook updates, blog entries, e-mails, and other informal writing to be "real writing"? How might such writing differ from the writing done in business? Why do...
-
Would it be better for students to work for a year before starting a degree?
-
List two (2) credible sources of information about local Aboriginal and Torres Strait Islander peoples' cultures and history.
-
LaToya Limmons is the manager of the Human Resources (HR) department and Javier Jartin is the manager of the sales department for a production company headquartered in the United States but also has...
-
20. This python program doesn't work. You need to find and fix ERROR. (3 points) rewrite wrong line(s) to fix this program # Solve the quadratic equation ax**2+bx+c=0 #import complex math module...
-
A researcher reports a significant two-way between-subjects ANOVA, F(3, 40) = 2.96. State the decision to retain or reject the null hypothesis for this test.
-
Why is scheduling overtime a popular choice for getting projects back on schedule? What are the potential problems for relying on this option?
-
Given the network plan that follows, compute the early, late, and slack times. What is the project duration? Using any approach you wish (e.g., trial and error), develop a loading chart for...
-
1. How effectively do you think Rachel spent her day? 2. What does the case tell you about what it is like to be a project manager? Rachel, the project manager of a large information systems project,...
-
How many oxygen molecules can one molecule of hemoglobin carry?
-
What is the structure of hemoglobin? Which part of the hemoglobin molecule binds to oxygen?
-
What is the function of a memory cell?
Study smarter with the SolutionInn App