Database Answers Documents and Expenses

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Documents and Expenses   
Back to the Data Model.

Entities are shown in Bold to provide a start to the design of the Data Model.
The Question is about :-
Subject: Documents and Expenses

Question: I am employee and have been asked to put together a database to handle administrative documents. 
The database has to be able to keep track of expenses and employee travels. 
Some of documents the receptionist looks after are the following invoices, 
contracts, purchase orders/requisitions, travel expenses/authorizations, statements. 
I was able to come up with data model for this database but I am stuck because 
invoices can be from a project or a contract or a purchase order, and statements have accounts. 

I don't know how to include information on projects or accounts within the design. 

So far i have the following tables Documents Document_Types Invoices Statements Contracts 
Purchase_Orders Travel_Authorizations Travel_Expenses Budget_Codes Suppliers 

I would like this database to be able to track all the office expenses using the budget 
codes year to year. 

Any help you provide would be greatly appreciated.


© DataBase Answers Ltd. 2012
About Us Contact Us