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

  • Question

  • hi guys,
    suppose you have a Hospital 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:

    why do we split this table to two seperate 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 this for memory maintaing.??????

    Brainstorm your Brain and find solution,if no result stuck to Brainstormer.
    Wednesday, December 31, 2008 7:47 AM