The Expense Reporting database tracks expense reports and expense report items along with users, expense categories, status codes and limits on expense category spending. Hint: Expense Report is indeed an entity in this model. For each user, the database records the unique user number, the first name, the last name, the phone number, the email address, the spending limit, the organizational relationships among users, and the expense categories (at least one) available to the user. A user can manage other users but have at most one manager. For each expense category, the database records the unique category number, the category description, the spending limit, and the users permitted to use the expense category. When an expense category is initially created, there may not be related users. For each expense category available to a user, there is a limit amount. For each user, there are many expense categories. For each status code, the database records the unique status number, the status description and the expense report using the status code. Each expense report has one status code. For each expense report, the database records the unique expense report number, the description, the submitted date, the status date, the status code (required), the user number (required) and many related expense items. Each expense item will show up in one report. Each expense report will be for one user, but each user can submit multiple expense reports. Each expense report can have multiple category expense items in it. Each expense category can show up in many expense reports. For each expense item, the database records the unique item number, the description, the expense date, the among the expense category (required), and the expense report number (required).

Please draw the E-R Diagram for the following Expense Reporting database. Please list your assumptions if you made any. Please indicate Primary and Foreign Keys clearly. Please use an ER Diagram tool to design your E-R Diagram. If you hand-draw it, please draw it very clearly and submit a picture of it.