Submitted Questions

  • Database Design

    I have these questions and looking for validation, these questions are part of test: Foreign keys implement: a) one to one relationship b) m:n relationship c) one to many relationship d) recursive relationship e) a, c and d are true Identify the dependency type shown by the attribute PATIENT- BALANCE. CHAGRES (PHYSICIAN #, PATIENT#, PATIENT –NAME, PATIENT-ADDRESS, PATIENT-BALANCE) a)...

    anand reddy

    • Apr 20th, 2016

    Correct anwser - e
    Reason, there will be M:M relation but not M:N

    Howy

    • Jul 10th, 2015

    I suggest you download a copy of the free book Database Design and Implementation: A practical introduction using Oracle SQL by bookboon It explains how to answer these questions in a simple way.