bernmc
Camel Spotter
- Local time
- Today, 19:03
- Joined
- Oct 3, 2004
- Messages
- 14
Hello all.
Still getting my head around this database stuff, and need some help on defining primary keys and links:
Basically, an operating theatre staffing database:
It has a four week rolling rota.
Lets say for eg there are 10 theatres.
Week1 Monday Theatre1(am) will have
Surgeon: Joe Bloggs
Anaesthetist 1: Bert Blinkenthrop
Anaesthetist 2: Amy Phmut
Wk1 Mon Theatre1(pm) will have
Surg
Anaes1
Anaes2
Wk2 Mon am... etc etc
So my database will have a list of Anaes staff, surg staff, and theatres that need to be staffed. How do I tie it all together into Week 1, Week 2, Week 3 etc? How should I be linking the different tables - ie what should the primary keys be?
Here's the start of my ER diagram (ignore the current key settings - they're wrong):
Am I going about it the right way? Seems to me that the 'unique identifier' would have to be a combo of Week/day/site - is this correct?
Still getting my head around this database stuff, and need some help on defining primary keys and links:
Basically, an operating theatre staffing database:
It has a four week rolling rota.
Lets say for eg there are 10 theatres.
Week1 Monday Theatre1(am) will have
Surgeon: Joe Bloggs
Anaesthetist 1: Bert Blinkenthrop
Anaesthetist 2: Amy Phmut
Wk1 Mon Theatre1(pm) will have
Surg
Anaes1
Anaes2
Wk2 Mon am... etc etc
So my database will have a list of Anaes staff, surg staff, and theatres that need to be staffed. How do I tie it all together into Week 1, Week 2, Week 3 etc? How should I be linking the different tables - ie what should the primary keys be?
Here's the start of my ER diagram (ignore the current key settings - they're wrong):
Am I going about it the right way? Seems to me that the 'unique identifier' would have to be a combo of Week/day/site - is this correct?