August 25, 2011 at 10:56 am
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 gave wrong table name in the paragraph.
2. If you are going to enter data then you should not denormalize.
Ans: I did not get this point. De-Normalization is needed when we have lots of data in our table and we want to optimize the performance, then we may need to de-normalize it. Please have a look at the below:
http://technet.microsoft.com/en-us/library/cc505841.aspx
3. I'm not sure why you have the DepartmentID on that Table.
Ans: Have a look at the 5th point again.
4. You Database is not in the 3rd normal form.
Ans: It's in 3rd NF. Please be specific what does it preventing from being 3rd NF.
August 25, 2011 at 1:30 pm
Who is Hugo?:-D
If you denormalized your database how can it be in 3rd normal form?
Typically you denormalize on a reporting version of the database.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply