Structure DB tables

[hasan_3]

What is the best way to structure DB tables for the attached picture?

 

[Ranman256]

Like:

TSymptoms table
1 ,Fever
2 shortness of breath


TMedNotes tbl
PatientID,medNoteNum, Date,DayPer,Result
123, 1, 1/1/2020, Evening,0

TMedExam tbl
PatientID,Date,Comordities,covid,....etc


TPatient tbl
PatientID,FirstN,LastN,address,...etc.

 

[hasan_3]

Thanks for your help

I didn't get the Result field in TMedNotes tbl

I need to collect data for 3 days only for 3 periods each day

 

[Ranman256]

The value you enter on the paper.

 

[onur_can]

Use at least 3 tables for the image, using the best way to configure DB tables.
1-Staff Information
2-Symptoms
3-days
Your staff master table will be associated with your main table in rechargeable tables.

 

[jdraw]

Cross-posted at UA with responses.

 

[mike60smart]

Hi Hasan

here is one way of approaching this.

 

[hasan_3]

Thank for your help

Special thanks to @mike60smart and @Ranman256