How to create report table in sql? <p>I am creating In-patient management system desktop application in javafx as my mini project of MCA, which has some data about patient admitted in hospital.</p> <p>I have to save all the records of patient test &amp; test reports in a database.</p> <p>So, I have created <code>Test</code> table with following attributes </p> <pre><code>-&gt;(T_ID, P_ID, T_NAME, T_DATE), </code></pre> <p><code>Report</code> table with following attributes </p> <pre><code>-&gt;(R_ID, P_ID, P_NAME, T_DATE, REF_BY) </code></pre> <p>So, there are multiple types of Test Report like,</p> <pre><code>eg. CBC_REPORT, LFT_REPORT etc. </code></pre> <p>then how should I create the relationship between this table.</p> <p>I tried but I am facing problem in user interface for inputing values in table.</p>