FOR FREE CONTENT

CREATE TABLES AND INSERT VALUES

CREATE TABLE SAILORS:

CREATE TABLE sailors(

sid NUMBER(5) PRIMARY KEY,

sname VARCHAR(50),

rating NUMBER(5),

age NUMBER(3)); 

Table Sailors is created.

Insert the values in the table "SAILORS":

INSERT INTO sailors VALUES(1, 'Anirban Das', 10, 20)

INSERT INTO sailors VALUES(2, 'Jufishan Boksha', 7, 21)

INSERT INTO sailors VALUES(3, 'Ramesh', 5, 25)

INSERT INTO sailors VALUES(4, 'Sumana Das', 8, 23)

INSERT INTO sailors VALUES(5, 'Shiladitya', 6, 21)

INSERT INTO sailors VALUES(6, 'Rahul', 8, 23)

INSERT INTO sailors VALUES(7, 'Rajib', 4, 27)

Output:

7 rows created

CREATE Table BOATS:

CREATE TABLE boats(

bid NUMBER(5) PRIMARY KEY,

bname VARCHAR2(50),

color VARCHAR2(20));

Output:

Table Boats is created.

Insert the values in the table "BOATS":

INSERT INTO boats VALUES(1, 'Interlake', 'Red')

INSERT INTO boats VALUES(2, 'Jhil', 'Green')

INSERT INTO boats VALUES(3, 'Blacker', 'Yellow')

INSERT INTO boats VALUES(4, 'Sea King', 'Red')

INSERT INTO boats VALUES(5, 'Time', 'Red') ;

Output:

5 rows created.

CREATE Table RESERVES:

CREATE TABLE reserves(

sid NUMBER(5) REFERENCES sailors(sid),

bid NUMBER(5) REFERENCES boats(bid),

day NUMBER(5));

Output:

Table Reserves is created.

Insert the values in the table "RESERVES":

INSERT INTO reserves VALUES(1, 1, 10)

INSERT INTO reserves VALUES(2, 2, 3)

INSERT INTO reserves VALUES(3, 5, 4)

INSERT INTO reserves VALUES(4, 3, 3)

INSERT INTO reserves VALUES(5, 1, 1);

Output:

5 rows created.