FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


database design of room assignment schedules of nurses





cvbayot
hello. i'm a newbie in database and stuff. i just want to ask for help in designing a database.

i'm developing a web-based system that will allow users to view and update patient records. the thing is, nurses can only update patient records assigned to them (room assignment) in a specific date and time.

my current database design is this..
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

my problem is..
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.

does anyone have a suggestion in improving my current database design? thanks!
Related topics
How to build a good database design...
Database Design
How would you represent a MySQL database visually
Job that u wouldn't mind doing for the rest of your life
Need Expert help in php-mysql
Help for Instant Messenger
MySql or MsSql?
Index
Sybase Database error message
Introduction
How to combine lots of queries to one - MySQL
Big, complicated php project: 10,000 frih$
Chained Selects
How should I start learning PHP and SQL?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.