Friday, July 19, 2019
systems analysis :: essays research papers
Overview. The process is designed to handle the interaction with customers and suppliers, and also deals with stock control. Invoice and payment data is recorded. For clarity I have noted down the following: †¢Ã‚     Head Office consists of               -     Product Management                     Finance                     Sales †¢Ã‚     A Local Branch consists of     -     A Local Office                     Warehouse                     Distribution Preliminary List of Entities. In my top-down analysis of the Metropolitan Pharmaceuticals scenario, I have first attempted to produce a preliminary list of candidate entities. These are as follows: †¢Ã‚     Customer †¢Ã‚     Customer Order †¢Ã‚     Customer Invoice †¢Ã‚     Sales                    -     Occurs only once so isn’t included †¢Ã‚     Product †¢Ã‚     Product Order †¢Ã‚     Supplier †¢Ã‚     Supplier Invoice          †¢Ã‚     Finance               -     Occurs only once so isn’t included †¢Ã‚     Local Branch †¢Ã‚     Local Office               -     Is part of Local Branch so isn’t included †¢Ã‚     Distribution               -     Is part of Local Branch so isn’t included †¢Ã‚     Warehouse               -     Is part of Local Branch so isn’t included †¢Ã‚     Stock The following page shows my list of probable entities: List of Probable Entities. †¢Ã‚     Customer †¢Ã‚     Customer Order †¢Ã‚     Customer Invoice †¢Ã‚     Product †¢Ã‚     Product Order †¢Ã‚     Supplier †¢Ã‚     Supplier Invoice          †¢Ã‚     Local Branch †¢Ã‚     Stock Descriptions and expected essential attributes for the above entities: Since the system analysis is focused on dealing with customers, suppliers and handling products, I have included all entities which I believe participate in these activities. †¢Ã‚     Customer Description:     Retail chemist shops or pharmacies associated with shops, hospitals or medical practices. All require a supply of products from the Metropolitan Pharmaceuticals system. Attributes:          Customer ID               -     Identifying attribute Name                Address                Telephone Number                Fax Number                e-mail                Contact Name                Delivery Address                Credit Rating †¢Ã‚     Customer Order Description:     An order placed by the Customer requesting the delivery of product. Attributes:          Order Number          -     Identifying attribute                Customer ID Product ID Quantity †¢Ã‚     Customer Invoice Description:     An invoice sent to the Customer from the Finance department, requesting payment for the delivered goods. Attributes:          Invoice Number          -     Identifying attribute Order ID Date Amount to be paid †¢Ã‚     Product Description:     An item that is supplied by the Metropolitan Pharmaceuticals system. Attributes:          Product ID               -     Identifying attribute Name                Description                Category               -     (A,B,C or D)                Stock Item               -     (Yes or No) †¢Ã‚     Product Order Description:     An order that is sent to either the Supplier (if it is a non-stock item) or a Local Branch (if it is a stocked item), requesting the delivery of a product to a customer. Attributes:          Order Number          -      Identifying attribute Date Product Customer ID                Quantity †¢Ã‚     Supplier Description:     A company that is able to supply a range of products to Metropolitan Pharmaceuticals. Metropolitan Pharmaceuticals does not manufacture any of its products, but instead, uses suppliers who either produce or procure the products. Attributes:          Supplier ID               -     Identifying attribute Name Address Telephone Number                Fax Number                e-mail               †¢Ã‚     Supplier Invoice Description:     An invoice that is sent by the supplier to Metropolitan Pharmaceuticals requesting payment for the product it has provided. Attributes:          Invoice Number          -     Identifying attribute Date                Amount to be paid †¢Ã‚     Local Branch Description:     A local outlet that contains a Local Office, a Warehouse and a Distribution Center. Attributes:          Branch ID               -     Identifying attribute                Name                Address Telephone Number †¢Ã‚     Stock Description:     A full inventory of products that are held in stock at the local branch. Attributes:          Stock ID               -     Identifying attribute                Product ID Location               -     eg. Shelf number                Quantity                Re-Order level Entity Links or Dependencies. Now to identify which pairs of entities have an association between themselves. †¢Ã‚     Customer is related to Customer Order: Justification:     Customer places Customer Order Customer Order is placed by Customer
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.