ASSIGNMENT 3

ASSIGNMENT 3

Due 04/27/18

Part I

1. Develop a function decomposition model for the traditional (as-is) 3-way matching process described in Assignment 2. Start with the top line function and provide at least

one level of sub-functions. Expand to deeper levels as required.

2. Identify all data entities in this process.

3. Develop a function/entity crosscheck matrix.

Part II

Develop an Entity-Relationship model for the purchasing requirements described below.

1. The purchasing department of a company issues purchase orders (PO) to its suppliers.

2. Each PO is for one supplier.

3. Each PO has one or more line items (PO LINE ITEM).

4. Each line item belongs to one PO.

5. Each line item is for one product from a supplier.

6. A supplier may supply one or more products.

7. A product from a supplier could be in multiple purchase orders.

8. The status of a PO is tracked at the line item level. Example of statuses are “line item

shipped”, “line item received”, “line item rejected”, “line item paid”, etc.

Submit your work in a MS Word document. Use the formats introduced in Chan (2013) for all your models.

The important issue is to complete the assignment correctly. However it should not be more than 2-3 pages.