practical 15

 

CREATE TABLE STREAM (

    s_id INT PRIMARY KEY,

    s_name VARCHAR(20)

);

CREATE TABLE STUDENT (

    adno INT PRIMARY KEY,

    fname VARCHAR(20),

    lname VARCHAR(20),

    class VARCHAR(5),

    sec CHAR(1),

    fee INT,

    mobile BIGINT,

    area VARCHAR(30),

    s_id INT,

    FOREIGN KEY (s_id) REFERENCES STREAM(s_id)

);

INSERT INTO STREAM VALUES 

(10, 'PCMC'),

(20, 'PCMB'),

(30, 'PCBH'),

(40, 'HECA'),

(50, 'MECA'),

(60, 'Arts');

INSERT INTO STUDENT VALUES 

(1001, 'Ramesh', 'Babu', 'xii', 'a', 5000, 9988776655, 'Benson Town', 10),

(1002, 'Dipti', 'Rai', 'xii', 'b', 4500, 8877665599, 'Cooke Town', 20),

(1003, 'Rahul', 'Pai', 'xii', 'c', 4000, 7766559988, 'Fraser Town', 30),

(1004, 'Shruthi', 'Saravanan', 'xii', 'c', 4000, 6655998877, 'Benson Town', 30),

(1005, 'George', 'Davis', 'xi', 'a', 4500, 5599887766, 'Cooke town', 10),

(1006, 'Tinu', 'Anna', 'xi', 'b', 4200, 9988776611, 'Benson Town', 20),

(1007, 'Abrar', 'Sultan', 'xi', 'c', 4100, 9988776622, 'Cooke town', 40),

(1008, 'Iffath', 'Khan', 'xii', 'a', 5000, 9988776633, 'Fraser Town', 10),

(1009, 'Hansika', 'Singh', 'xii', 'b', 4500, 9988776644, 'Cleveland Town', 20),

(1010, 'Kailash', 'Dharyanani', 'xii', 'c', 4000, 9988776633, 'Richard Town', 50);