Create PointOfInterest and Town Table in SQL


Create PointOfInterest and Town Table

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


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

Sharing Is Caring

Leave a Comment