Given the case assignment, do items 1 – 4

Question

1. Draw a partial REA diagram of the XYZ Company’s revenue cycle to model there events: taking customer orders, deliveries, and the use of vehicles. Be sure to include cardinalities

2. Create a set of tables (either on paper or in a relational DBMS to which you have access) to implement the REA model you developed for the XYZ company, specifying the primary key(s) for each table, any foreign key(s) and add at least one other attribute in each table.