Question

Activity 4 Setting Column constraints
1. Create another table called months and set the following structure with
constraints:
monthid
integer not null unique key
monthname char (15) not null
days
integer default - 30
year
integer
new year
integer check (newyear >year)
season
char (15)
check (season in ('Summer', 'Winter', 'Autumn', 'Spring)​

Answer 1

Explanation:

Activity 4 Setting Column constraints

1. Create another table called months and set the following structure with

constraints:

monthid

integer not null unique key

monthname char (15) not null

days

integer default - 30

year

integer

new year

integer check (newyear >year)

season

char (15)

check (season in ('Summer', 'Winter',