none
why do we split one table to two table?please help RRS feed

  • 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.
    Wednesday, December 31, 2008 7:47 AM

Answers