Souder, Oles, and Franek is an international consulting firm headquartered in Chicago, Illinois. The Entity-Relationship diagram in Figure shows a simplified version of the company€™s process for purchasing and paying for equipment and supplies.

Requirements
1. Insert appropriate pairs of cardinalities for the relationships in the Entity-Relationship model developed with the REA data modeling approach.
2. Describe the database table attributes for this model. You will need a table for each entity, as well as one or more relationship tables. First identify the table name and then indicate the primary key by underlining it. Show any foreign keys by framing them in brackets (e.g., [Vendor#]). Include at least three fields in each table. Below is an example for the Vendor table and the Order Goods table:
Vendor#, Name, Street Address 1, Street Address 2, City, State, Zip Code, Phone, Email, Fax, Contact, Comments. Order#, Date, [Vendor#], [Employee#], Shipping Instructions,Comments.

Transcribed Image Text:

Purchasing agent Order goods Merchandise inventory Vendor Receive goods Receiving clerk Pay for goods Cashier or A/P clerk Cash