Question

desenvolver um script para a tabela matricula e classe

Answer 1

create table matricula (
id_matricula serial NOT NULL,
nome_matricula character varying (40) NOT NULL,
ano_matricula numeric (10,2),
CONSTRAINT pk_matricula PRIMARY KEY (id_matricula)); 

create table classe (
id_classe serial NOT NULL,
id_matricula  NOT NULL,
nome_classe character varying (40) NOT NULL,
obs_classe character varying (40) NOT NULL, 
constraint fk_matricula FOREIGN KEY (id_matricula)
CONSTRAINT pk_matricula PRIMARY KEY (id_matricula));