Reference no: EM131073291
John & co. is a Pharmaceutical company which sales lifesaving medicines. You have to draw E-R of sales and purchase system of above company. Main entities of system are Customer, supplier, product, stock etc.
Purposes:
Ensure that you can analyze existing manual system and can draw Entity Relationship Diagrams (ERD) of any proposed system.
Before Starting:
An Entity Relationship Diagram
The entity relationship enables a software engineer to fully to fully specify the data objects that are input and output from a system the attributes that define the properties of these objects, and their relationships
Guidelines to make ERD
The ERD is constructed in an iterative manner. The following approach is taken.
1.During requirement elicitation, customer are asked to list the "things" that the application or business process addresses. These "things" evolve into a list of input and output data objects as well as external entities that produce or consume information.
2. Taking the objects one at a time, the analyst and customer define whether or not a connection exists between the data objects and other objects.
3.Whether a connection exists, the analyst and the customer create one ore more object/relationship pairs.
4. For each object/relationship pair, cardinality and modality are explored.
1. Steps 2 through 4 are continued iteratively until all object/relationships have been defined. It is common to discover omissions as this process continues. New objects and relationships will invariably be added as the number of iterations
grows.
2. The attributes of each entity are defined.
3. An entity relationship diagram is formalized and reviewed.
4. Steps 1 through 7 are repeated until data modeling is complete.
Discussion of the Assignment
Main Analysis Diagrams
Customer Registration Place where new customers are registered Products those are available in this store and register new products Supplier who supply products in this company and also allot them specified regions for their supply
Purchase invoice give three slips on the behalf of suppler that supply products also if return then delete slip from record Sales invoice give three slips on the behalf of order that is placed by customer when return then delete slip from record
|
Expand production increase the NPV of the project
: Hit or Miss Sports is introducing a new product this year. If its see-at-night soccer balls are a hit, the firm expects to be able to sell 58,000 units a year at a price of $70 each. If the new product is a bust, only 38,000 units can be sold at a pr..
|
|
Stage of the investment
: CP Venture Partners is looking at the possible investment of $1 million in an early-stage company (Startco). Given the stage of the investment, CP requires a 40% annual rate of return. The company earned $750,000 in EBITDA last year, and this amount ..
|
|
Managerial ethics to examine dilemma critically
: Use an organisation that is or has been in the news during the past two years (work-related learning) and identify an ethical dilemma faced by that organisation as an example. Apply at least two theoretical concepts from managerial ethics to examin..
|
|
What is the annualized holding period return
: Suppose you purchased a stock on June 5 for $30. It paid $0.20 cash dividends on July 1 and Oct. 1, and you sold it for $31.16 on Dec. 18. What is the annualized holding period return (APY) of this investment?
|
|
Entities of system are customer-supplier
: John & co. is a Pharmaceutical company which sales lifesaving medicines. You have to draw E-R of sales and purchase system of above company. Main entities of system are Customer, supplier, product, stock etc.
|
|
Evaluated an early-stage investment
: Venture Partners has evaluated an early-stage investment in a startup company (Startco). Startco needs $4 million in financing, and SPC has offered to provide the financing in exchange for a 40% interest in the company. What is SPC's post-money valua..
|
|
What will be swap rate on agreement to exchange currency
: Suppose the U.S. yield curve is flat at 5% and the euro yield curve is flat at 4%. The current exchange rate is $1.25 per euro. What will be the swap rate on an agreement to exchange currency over a 3-year period? The swap will call for the exchange ..
|
|
Treasury strips-what is the yield to maturity
: A Treasury STRIPS is quoted at 93.333 and has 4 years until maturity. What is the yield to maturity?
|
|
Steering future performance back toward the baseline
: Determine the fundamental impact of not using a project management tool which clearly displays the effect of delays in delivering work packages, as required per your project schedule. Justify your response.
|