Question: Using the SQL*Plus describe commands given below, define the referential integrity constraints associated with the Cab Project. You may also want to refer to

Using the SQL*Plus describe commands given below, define the referential integrity constraints associated with the Cab Project. You may also want to refer to the ER diagram on the second page. SQL> desc cab Name CA CABNUM CA MAKE CA MODEL CA YEAR CA PURDATE CA LICNUM CA CONDITION CA CABSTATUS CA_FUELCAPACITY CA BASEFARE CA MILEAGECHARGE SQL> desc driver Name DR DRVNUM DR DRVNAME DR DRVSTREET DR DRVCITY DR DRVSTATE DR DRVZIP DR DRVPHONE DR ORVLIC DR DRVLICDATE DR DRVSTATUS DR BRTHDATE DR JOBCODE DR SALARY DR HIREDATE SQL desc shift Name A Referential Integrity Opportunity That Involves the CAB Project SH_WKDATE SH WKSHIFT SH_CARNUM SH DRVNUM SH WKFLAG SH ODMROGI SH_ODOMROG2 SH NUMFARES SQLX Nud? Type NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(10) NOT NULL VARCHAR2(15) NOT MALL VARCHAR2(2) NOT NULL DATE NOT NULL VARCHAR2(8) NOT NULL VARCHAR2(38) NOT NULL VARCHAR2(1) NOT NULL VARCHAR2(5) NOT NULL NUMBER NOT NULL NUMBER Mull? Type NOT NULL VARCHAR2(4) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(15) NOT NULL VARCHAR2(2) NOT NULL VARCHAR2(5) NOT NULL VARCHAR2(10) NOT NULL VARCHAR2(10) NOT NULL DATE NOT NULL VARCHAR2(20) NOT NULL DATE NOT NULL NUMBER NOT NULL NUMBER NOT NULL DATE Null? Type NOT NULL DATE NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(4) VARCHAR2(1) NUMBER NUMBER NUMBER SQL> desc maintain Name MA CANUM MA MAINDATE MA MAINTYPE MA_MAINODOM MA COST MA LASTDRVNUM SQL> desc incident Nane IC CABNUM IC WKDATE IC WKSHIFT IC INCITYPE IC DETAILS SQL dese qualification Nane QU DRVNUM QU CABNUM SQL> desc fueluse Name FUL CANUM FUL FUELDATE FUL_NUMGAL FUL FUELCODE FUL_PRICEGAL FUL FUELBRAND SQL> Null? Type NOT NULL VARCHAR2(3) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL NUMBER NOT NULL NUMBER (10,2) NOT NULL VARCHAR2(4) Null? Type NOT NULL VARCHAR2(3) DATE VARCHAR2(3) NOT NULL VARCHAR2(15) VARCHAR2(200) Null? Type NOT NULL VARCHAR2(4) NOT NULL VARCHAR2(3) Null? Type NOT NULL VARCHAR2(3) NOT NULL DATE NOT NULL NUMBER NOT NULL VARCHAR2(1) NOT NULL NUMBER (6,2) NOT NULL VARCHAR2(10) Undergoes (0,n) CAB (0,n) Makes use (1,1) FUELUSE (0,n) (1,1) Qual_cab (0,n) Driven_on (1.1) (1.1) MAINTAIN QUALIFICATION SHIFT (0,n) Involved in (1.1) INCIDENT (1.1) (1,1) Qual_driver (1.1) (0,n) Drives (0,n) Brings in (0,n) DRIVER
Step by Step Solution
There are 3 Steps involved in it
It appears that youd like to define referential integrity constraints for a database that involves the Cab Project based on the ER diagram and tables ... View full answer
Get step-by-step solutions from verified subject matter experts
