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.

Quiz for Exam - Create PointOfInterest and Town Table

Code:

sample.sql

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)
);

Recommended:

Leave a Comment

Your email address will not be published. Required fields are marked *

x