Relation database

[fabrizio19]

Hi I have loosing myself about this topic.

My databse is a medical database.Thus I have a huge amount of tables.
The first table is admission (ricovero in italian).One patient can have more than one admission in the hospital. Thus when you insert the new patient in the database from the form admission you can choose 4 locations 4 differents table related to 4 different form). In fact the patient can go in the cath lab, Ward intensive care and operating theatre.An other problem is that a patient spends several days in the hospital moving from ward cath lab and ICU.
So the variable day is mandatory.Every day is a new record in the table ICU if the patient is in ICU, ward if the patient is in the ward and so on.
I have a build my database connecting the forms by modules.Every things work fine. But I have no idea as connect the tables in the relation window!
Help me
Fabrizio:banghead:

 

[AliyuKatsina]

Re: Relation daabase

Hi Fabrizio,

I have a build my database connecting the forms by modules.Every things work fine. But I have no idea as connect the tables in the relation window!

I have examined your db and I've you have established some relationship like the One-To-Many in the PTS fields in Recovero and AnesTesia tables. What is your problem precisely?

 

[Mihail]

Re: Relation daabase

Any DB is designed in order to answer to some questions.
Post the questions that your DB should answer.

 

[Steve R.]

Re: Relation daabase

Take a look at this website database answers. There may be a sample model there that you can use.

 

[fabrizio19]

Re: Relation daabase

Thanks for your replies.Every patient is adnitted into the hospital.so you record him in the form ricovero.After that he can spend several days in it before and after the cath lab.For example the day zero the patient is recoverd in the ward (reparto form).the day 1 and 2 also.During this period he can have same complications.the day 3 is in the cath lab (form cath lab).After that the patient can goes back to icu or came back to the ward.So there is a on e to many relationship from ricovero icu or ward or cath lab and many to many from cath lab and other table.in particular i 'm not able to fill the junction table by form

 

[Mihail]

Re: Relation daabase

I saw in every table a lot of fields. Why all this fields if you need only to remember the patient movement ?
3 tables with few fields are enough:

tblPatients
ID_Patient (PK)
PatientName
PatientCard

tblHospitalRooms
ID_HospitalRoom (PK)
RoomName

tblPatientMovements
ID_Movement (PK)
ID_Patient (FK)
ID_HospitalRoom(FK)
MovementDate