Create PointOfInterest and Town Table in SQL

Question:

Create PointOfInterest and Town Table

Create PointOfInterest and Town tables based on the structure and the constraints given below.

CODE:–

create table PointofInterest(
    pointID number,
    describe varchar2(30),
    opentime varchar(10),
    closetime varchar2(10),
    townID number,
    constraint PK primary key (pointID)
);
create table Town(
    townID number,
    townname varchar(30),
    state varchar(30),
    longitude varchar(30),
    latitude varchar(30),
    summertemp number,
    wintertemp number,
    sealevel number,
    constraint PK2 primary key(townID)
);

rdbms programs | rdbms programs with output | rdbms programming languages | rdbms database program