I created this database for a project I am working on right now, and I need an expert check it for normalization optimization. also, fill in the blanks and create whatever is needed to best fit my needs.
general description of the purpose of the database:
we receive requests to refund money. money that could be deposited in our account by mistake and needs to be refunded, or it may be deposited to the wrong account and just needs to be redirected to another account. each case will have its own workflow.
it is critical that user can only submit one request for any given transaction.
- i am using asp net membership to manage the users and registration. no need to create users tables.
this might answer some questions.
- in some
-possible user types:
1-student. not all students are allowed to use the service. only those who are : a- graduates and balance is less than 200. ( nevermind the balance ). or b- the student is dead. and
2- non-students. anyone who is not a student.
each case (1 or 2) has a specific set of required documents, some of which are common in all cases.
the request will go through a 2 steps approval flow. an employee will review and another will approve. then the request is attached to a payroll.
please contact me if you need any clarification.
the maximum budget for this project is 100$.