Hey guys thank you for all your help. I'm stuck on a relationship diagram diagram, and swim lane diagram any help would be appreciated for this.

The Sports Supply Company, inc. Overview:

The Sports Supply Company (TSSC) was opened several years ago out of a garage. The owners have excellent supplier contacts around the globe who they purchase sports supplies from. They then sell these products to local businesses - and make a nice profit. They have kept track of all of their sales, purchases and inventory using manual methods. Over the last few months they have realized they are spending more time doing paperwork than building sales, so they would like a database system created to help them get organized and run their business more efficiently. TSSC has a solid reputation and want to keep it that way. Their business continues to grow year over year and they now sell their merchandise all over North America.

TSSC contacted us to build their system. Before we begin any systems design we want to model their existing manual processes to understand what information is required, how that information is obtained and all of the players/roles and processes involved in the buying and selling of their merchandise. We have previously worked on the Sales Orders (our customers buying from us) cycle.

We performed a separate interview with their purchasing manager and documented the below process used in purchasing materials.

The Interview/Walkthrough - Purchasing General Information Currently,

TSSC maintains an inventory in excel of their items. In the excel spreadsheet they keep track of the suppliers and the items assigned to each supplier. TSSC usually creates one Purchase Order (PO) for a Supplier that has several line items on it. We will need to be able to print a report of purchases by Supplier so that TSSC can negotiate better discounts where possible. TSSC keeps the following information regarding suppliers: Address-including street, city, state, zip, country code, Contact Information including phone numbers, fax numbers, email addresses and names for the Suppliers Sales Manager and Suppliers Accounts Receivable department. TaxID is also necessary.

Some of the Suppliers have branches in different locations so TSSC must have a unique Supplier ID per location and a Supplier Grouping code so they can report on purchases by Supplier ID, and by Supplier Group. A supplier status code is necessary to know if they are currently active, inactive, or on hold. We need to know the userid of the purchasing clerk who enters a PO and the date and time the PO was created. We also need the user-id of the last user who modified the PO, along with the date and time it was modified. For all of our items we need to know their item ID, their description, the items unit of measure (e.g., each, yard, etc.), quantity available, re-order point (quantity where we would want to generate a PO), item group code, general ledger number, status of the item (active / inactive), the items cost, the items list price, Creating Purchase orders: Workflow Once a week the PO clerk runs an inventory report by supplier showing any items that have an available quantity less that the re-order quantity. They then build a draft Purchase order in excel for the PO Manager to review.

The Draft PO contains: The Supplier information Our Terms information (From supplier info)

Item Information (Can be 1 to many items) - Item number - Item Description - Quantity to order - Unit of Measure - Cost PO Date Requested Receive date (The date we want to receive the goods)

(See example PO Below, taken from an existing PO) If the PO Manager agrees with the draft PO they will mark it as approved and an official PO is generated and sent to the Supplier. If the PO Manager does not agree they make comments and send the draft PO back to the PO Entry clerk for updates. Based on the information gathered, and perhaps with some of your own reasoning/analysis:

- Build an Activity diagram and SwimLane diagram that supports the Purchase Order Workflow

- Identity the objects required and their attributes (hint: Suppliers, POs, Items)

- In the object Diagram, show the relationships between the objects

- Explain why all of the above diagrams are important, how they are used, and how they will change over time.