Systems analysis

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.

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now


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
Customer is related to Customer Invoice:
Justification:Customer receives Customer Invoice
Customer Invoice is received by Customer
Customer Order is related to Local Branch:
Justification:Customer Order is received by Local Branch
Local Branch receives Customer Order
Local Branch is related to Stock:
Justification:Stock is held by Local Branch
Local Branch holds Stock
Local Branch is related to Product:
Justification:Product is received by Local Branch
Local Branch receives Product
Local Branch is related to Product Order:
Justification:Local Branch requests Product Order
Product order is requested by Local Branch
Product Order is related to Supplier:
Justification:Product Order is received by Supplier
Supplier receives Product Order
Product is related to Supplier:
Justification:Product is sent by Supplier
Supplier sends product
Supplier is related to Supplier Invoice:
Justification:Supplier sends Supplier Invoice
Supplier Invoice is sent by Supplier
The following page shows my preliminary Entity Relationship diagram. I have chosen Local Branch as the central active entity.