DBMS (ASS4)
1. CREATE TABLE SAILOR( SID VARCHAR2(4) PRIMARY KEY CHECK(SID LIKE 's%'), SNAME VARCHAR2(10) CHECK(SNAME= INITCAP(SNAME)), MNAME VARCHAR2(10), SURNAME VARCHAR2(10) NOT NULL, RATING NUMBER(2) DEFAULT 0, AGE NUMBER(3,1) NOT NULL ); 2. CREATE TABLE BOAT( BID NUMBER(3) PRIMARY KEY , BNAME VARCHAR2(10) CHECK (BNAME=UPPER(BNAME)), COLOR VARCHAR2(6) CHECK (COLOR IN ('red','green','blue')) ); 3. CREATE TABLE RESERVED( SID VARCHAR2(4), BID NUMBER(3), FOREIGN KEY(SID) REFERENCES SAILOR(SID), FOREIGN KEY(BID) REFERENCES BOAT(BID), DAY DATE CHECK(DAY<'1-JAN-2000'), ...