I have five entities i.e Patient, Advancepayment, totalBillAmount, TotalRecievedAmount, TotalDueAmount.
I have to deliever detail and summary of each transaction on daily basis.
In reporting I need Billing items details, AdvanceAmount Detail, ReceivedAmount detail, TotalDueAmount against each patient on daily basis.
Create a db named "hospital"
and create tables with Patient, Advancepayment, totalBillAmount, TotalRecievedAmount, TotalDueAmount.
Place datafile ( mdf ) - in RAID 1 drive ( example D: drive ) and log file (ldf ) in RAID 10 drive ( example E: drive )
Create required sp and views required for the use , with logins and necessary permissions granted for the users at the database level .Create required database roles and assign privileges .
DB file(data and log file ) growth - while creating db set datafile growth in MB not in %
Place the files in disk calculating the usage of db with ample free space in disk focusing the monthily and annual growth