|
Back to the Data Model.
The Area being Modelled is :-
Equipment Repair.
The Business Rules have been drafted by Barry as follows :-
1. Clients can place Work Orders.
2. Details are stored in the Work_Orders Table.
3. Repair Work is usually predefined and new ones can be generated as required.
4. Each Repair Work activity is broken down into a series of Repair Tasks.
5. Repair Work is broken down into a series of Tasks.
6. Each Task is related to the next Task to be done.
7. Each Repair Task uses a predefined amount of each piece of Equipment.
8. Equipment Repair Levels are recorded at regular intervals, usually every day.
Specifications have been provided by Joe in the following terms :-
Hello Barry,
Thank you for responding.
Please don’t worry about making a special one for me.
I am currently creating a database for a person that works in the Biomedical Equipment Repair industry based off their current program.
I used to work for them and I know the program inside and out and was contacted to try and create a similar program in Access.
I knew it could be done so I agreed.
Mostly it deals with Clients, Parts Inventory and Work Orders.
So Work Orders and Inventory stuff is what I look at.
The Registration database came into play when my former boss said that after I create this program,
others companies that use the same program as he does are interested in what I come up with…so we will be able to market to
those as well…and customize it for “their” company.
So I was just looking at a small simple program to use to do this…but PLEASE…don’t do anything just for me.
I know your time is valuable..and at this time it is really a mute issue as I am not 100% done the program….although getting close.
Thanks again for the reply..I admire and respect you for what you have done and consider it an honor that you even answered my email.
Sincerely,
Joe
Barrys says
"The Things of Interest incliude "
Clients
Inventory of Parts
Work Orders
© DataBase Answers Ltd. 2010
|
|