i'm developing a web-based system that will allow users to view and update patient records. nurses can only update patient records assigned to them (room assignment) in a specific date and time.
current design:
i have a table for assign, anurse, and aroom. they have the following attributes:
assign (asid_pk, adate, stime, etime); asid_pk-primary key, adate-schedule date, stime-start of shift, edate-end of shift
aroom(asid_fk, rno_fk); asid_fk-foreign key referencing asid_pk from assign, rno_fk-foreign key referencing rno_pk from the table for room
anurse(asid_fk, nid_fk); asid_fk-fk from assign, nid_fk-fk from the table for nurse
problem:
i have to duplicate entries in assign table to assign different nurses in different rooms. there will be 12 entires in the assign table with the same date and time and different primary keys. 12 because there are 12 groups of rooms and in each group 1-4 nurses will be assigned.
2007-10-06
03:39:22
·
4 answers
·
asked by
!-sp-!
2