FlyingMonkey
New member
- Local time
- Today, 01:47
- Joined
- May 1, 2014
- Messages
- 8
Hi
First time here and I have a query about a Database I'm designing.
I'm designing a Database for my section in work. I have Normalised it already. The Database is to hold information about the recruitment of hospital workers. This is not a recruitment system. We already have one in the office. It's merely to keep track of our own section's work.
We recruit for hospitals all over the country and the reason why I have a few tables is because I'm using them as look up tables. I use tables rather than lists so anyone can go in and add another hospital to the list. I have tables for title of the post, employing authority and staff member who is dealing with it too. The main table will have information concerning the actual individual post, eg date of advertising, no of applicants etc. I don't want people to have to keep typing the hospital and title etc. as there is a lot of repeating in these.
I have no need for other information in these tables as it's purely for the lookup column. At the moment I have H01, H02 etc. as the primary key for the hospital table and similar for the others. But I don't think I need them as the hospital name will be unique.
Is this acceptable or am I going to cause trouble for myself in future? I can't think of another way of doing this.
First time here and I have a query about a Database I'm designing.
I'm designing a Database for my section in work. I have Normalised it already. The Database is to hold information about the recruitment of hospital workers. This is not a recruitment system. We already have one in the office. It's merely to keep track of our own section's work.
We recruit for hospitals all over the country and the reason why I have a few tables is because I'm using them as look up tables. I use tables rather than lists so anyone can go in and add another hospital to the list. I have tables for title of the post, employing authority and staff member who is dealing with it too. The main table will have information concerning the actual individual post, eg date of advertising, no of applicants etc. I don't want people to have to keep typing the hospital and title etc. as there is a lot of repeating in these.
I have no need for other information in these tables as it's purely for the lookup column. At the moment I have H01, H02 etc. as the primary key for the hospital table and similar for the others. But I don't think I need them as the hospital name will be unique.
Is this acceptable or am I going to cause trouble for myself in future? I can't think of another way of doing this.