Question

Based on explanation in GPS Low Firm Business Processes. Generate a database for the GPS Law firm.

You can use Revenue Cycle case diagrams to document the Resources, Events, Entities and Agents involved in the company.

Database has to be designed conforming to the descriptions in the Project document; however you can make assumptions where appropriate to define specific conditions.

In adding to the necessary objects, create 3 additional queries and 2 additional reports providing information about the revenue Cycle items of GPS.

When completed you should submit 2 files,

1. A model diagram describing the GPS firm and relationships and a list describing any assumptions you made about the operation of GPS

2. Completed database of the GPS firm.