why do we split one table to two table?please help

Question

hi guys,
suppose you have a Hospital database.in here i have one table by name of Doctors which has two columns:DocID,DocName
and one table by name of Patients which has 3 columns:PatientID,PatientNAme,DocID

my question is why couldn't we have one table which has 3 columns like this:
PatientID,PatientName,DocName

why do we split this table to two seperate table.do we do this because we dont want to waste memory.i mean do we do this because we dont want to repeat for example DocAli for example for 2000 patient.and instead we want to use code of DocAli.is this for memory maintaing.??????

---

Brainstorm your Brain and find solution,if no result stuck to Brainstormer.

Answer 1

Thanks for the posting.   This is not the correct forum for your question.  Please repost it on the following forum for better assistance.

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1
 

---

Hongwei Sun -MSFT