create table DEPARTMENT(D_NAME VARCHAR(50) CONSTRAINT DNPRKY PRIMARY KEY,D_LOCATION VARCHAR(50),FACILITIES VARCHAR(60));
create table ALL_DOCTORS(DOC_NO VARCHAR(10) CONSTRAINT DCPRKY PRIMARY KEY CONSTRAINT LIKETHESE CHECK(DOC_NO LIKE 'DR%' OR DOC_NO LIKE 'HD%' OR DOC_NO LIKE 'DA%' OR DOC_NO LIKE 'DC%'),DEPARTMENT VARCHAR(50) CONSTRAINT ADDFRKYDMT REFERENCES DEPARTMENT);
create table DOC_REG(DOC_NO VARCHAR(10) CONSTRAINT DCRFDNPRKY REFERENCES ALL_DOCTORS ,D_NAME VARCHAR(50) PRIMARY KEY ,QUALIFICATION VARCHAR(50),SALARY INT,EN_TIME VARCHAR(50),EX_TIME VARCHAR(50),ADDRESS VARCHAR(50),PH_NO INT,DOJ VARCHAR(50));
create table DOC_ON_CALL(DOC_NO VARCHAR(50) ADD CONSTRAINT FOREIGN KEY(DOC_NO) REFERENCES ALL_DOCTORS(DOC_NO),D_NAME VARCHAR(50) ADD CONSTRAINT FOREIGN KEY(D_NAME) REFERENCES DOC_REG(D_NAME),QUALIFICATION VARCHAR(50),FS_PR_CL VARCHAR(50),PYMT_DU VARCHAR(50),ADDRESS VARCHAR(50),PH_NO INT,
ADD CONSTRAINT FOREIGN KEY(QUALIFICATION) REFERENCES DOC_REG(QUALIFICATION),ADD CONSTRAINT FOREIGN KEY(ADDRESS) REFERENCES DOC_REG(ADDRESS), ADD CONSTRAINT FOREIGN KEY(PH_NO) REFERENCES DOC_REG(PH_NO));