Hi all,
I am looking to build a database that can help a job support agency but I am finding the task quite difficult and would appreciate any help possible. I am quite the novice in database design and would love someone to review and let me know what my work so far is like.
The organisation is set up so that clients come to them, upon referral and the organisation helps the client to get back into employment.
When a client comes to the organisation they are caseloaded and assigned a mentor from the employee staff to look after their case.
The organisation helps clients by sending them to skills courses. There are 5 categories of course programmes that a client can be sent to. Within each category a client will need to undertake a skills programme however the names of each are specific to the client and will need to be manualy typed in under the correct category they fall under.
The organisation also helps organisations by helping them get into employment. Again their are a number of categories of employment types that the clients can be sent to and the organisation needs to keep track of the employment type a client is in and the employer details that they have went to.
I have spent a few weeks now trying to develop this database and have ended up with a design that I am just not sure about. It seems to work, but so much of it replies on the primary key of the case table. If anyone could take a look and see if what I have done is ok, it would be much appreciated! Please help people because I am completely unsure if my design is massively flawed.
I have just attached two screenshots which I placed in a word document to show you all what I have done in relating the tables, and the form and subform I have for users to interact and enter the data needed. please help and if my wording here is very confusing, please let me know.