Thanks for your valuable comments and Apologies for creating confusion.

The aforesaid is a design that I’m considering, my current design and business logic is as following:

There can be N...

1. Are users going to be entering data into the HospitalPatients Table?

Ans: Please refer the 5th point and the paragraph after 5th point in my previous reply. By mistake, I...

Can you please provide a detailed reply for both of my questions regarding De-normalization and Indexes, so that I can understand the logic behind that.

Hi Hugo

I am providing the below things which you can find at the end of my reply:

A snap shot of how the data would look like...

Hi Welsh

Before finalizing my DB design, I seek you advice again to make sure I am going the right way. To give you more insight into my database schema so...

What I realized is that importing 40k-50k records (with 10-15 columns) into a staging table using BULK INSERT take 2-3 seconds.

Once the data is in staging then I can transform...

I'll be following the same to see if it works for me.

Hi Welsh

Thanks for that. It helped.