Untitled

-- Creating Officer Table -- 

create table officer (
    Oid number (2) primary key,
    phone number (6),
    zone varchar2 (10)
)

create table member (
    Mid number (2) primary key,
    Mname varchar2 (25),
    Dutyohur number (3,2)
)

create table receiver (
    Rid number (2) primary key,
    Rname varchar2 (25),
    Paytype varchar2 (10)
)

create table supervise (
    Oid number (2) primary key,
    Mid number (2),
    Rid number (2),
    constraint m foreign key (Mid) references member (Mid),
    constraint r foreign key (Rid) references receiver (Rid)
)

create table assist (
    Mid number (2) primary key,
    Mname varchar2 (25),
    Dutyohur number (3,2),
    Rid number (2),
    constraint ri foreign key (Rid) references receiver (Rid)
)

describe assist