CREATE TABLE ALUNO  
( 
    NR_RGM          NUMBER   (8)  NOT NULL, 
    NM_NOME         VARCHAR2 (40) NOT NULL, 
    NM_PAI          VARCHAR2 (40), 
    NM_MAE          VARCHAR2 (40), 
    DT_NASCIMENTO   DATE          NOT NULL, 
    ID_SEXO         CHAR (1)      NOT NULL, 
    CONSTRAINT PK_ALUNO PRIMARY KEY (NR_RGM) 
)

CREATE TABLE CLASSE 
( 
    CD_CLASSE       NUMBER (8)   NOT NULL, 
    NR_ANOLETIVO   NUMBER (4)   NOT NULL, 
    NR_SERIE        NUMBER (2)   NOT NULL, 
    SG_TURMA        VARCHAR2 (2), 
    CD_ESCOLA       NUMBER (6)   NOT NULL, 
    CD_GRAU         NUMBER (2)   NOT NULL, 
    CD_PERIODO      NUMBER (2)   NOT NULL, 
    CONSTRAINT PK_CLASSE PRIMARY KEY (CD_CLASSE) 
)

CREATE TABLE MATRICULA 
( 
    NR_RGM          NUMBER (8) NOT NULL, 
    CD_CLASSE       NUMBER (8) NOT NULL, 
    DT_MATRICULA    DATE       NOT NULL, 
    CONSTRAINT PK_MATRICULA PRIMARY KEY (NR_RGM, CD_CLASSE) 
    CONSTRAINT FK_MATRICULA_REF_ALUNO FOREIGN KEY (NR_RGM) REFERENCES ALUNO (NR_RGM), 
    CONSTRAINT FK_MATRICULA_REF_CLASSE FOREIGN KEY (CD_CLASSE) REFERENCES CLASSE (CD_CLASSE) 
)

CREATE TABLE MATRICULA 
( 
    NR_RGM          NUMBER (8) NOT NULL, 
    CD_CLASSE       NUMBER (8) NOT NULL, 
    DT_MATRICULA    DATE       NOT NULL, 
    CONSTRAINT PK_MATRICULA PRIMARY KEY (NR_RGM, CD_CLASSE), 
    CONSTRAINT FK_MATRICULA_REF_ALUNO FOREIGN KEY (NR_RGM) REFERENCES ALUNO (NR_RGM), 
    CONSTRAINT FK_MATRICULA_REF_CLASSE FOREIGN KEY (CD_CLASSE) REFERENCES CLASSE (CD_CLASSE) 
)

INSERT INTO ALUNO 
( 
    (NR_RGM, NM_NOME, NM_PAI, NM_MAE, DT_NASCIMENTO, ID_SEXO) 
    VALUES 
    (235689, 'ANALYA SILVA', 'GERALDO SILVA', 'LUZIA SILVA', TO_DATE ('1989-02-24'), 'F') 
)

INSERT INTO ALUNO 
    (NR_RGM, NM_NOME, NM_PAI, NM_MAE, DT_NASCIMENTO, ID_SEXO) 
    VALUES 
    (235689, 'ANALYA SILVA', 'GERALDO SILVA', 'LUZIA SILVA', TO_DATE ('1989-02-24'), 'F')

INSERT INTO ALUNO 
    (NR_RGM, NM_NOME, NM_PAI, NM_MAE, DT_NASCIMENTO, ID_SEXO) 
    VALUES 
    (235689, 'ANALYA SILVA', 'GERALDO SILVA', 'LUZIA SILVA', DATE ('1989-02-24'), 'F')

INSERT INTO ALUNO 
    (NR_RGM, NM_NOME, NM_PAI, NM_MAE, DT_NASCIMENTO, ID_SEXO) 
    VALUES 
    (235689, 'ANALYA SILVA', 'GERALDO SILVA', 'LUZIA SILVA', DATE '1989-02-24', 'F')

INSERT INTO CLASSE 
    (CD_CLASSE, NR_ANOLETIVO, NR_SERIE, SG_TURMA , CD_ESCOLA, CD_GRAU, CD_PERIODO) 
    VALUES 
    (3374, 2021, 2, 'B', 2520, 2, 1)

INSERT INTO MATRICULA 
    (NR_RGM,  CD_CLASSE, DT_MATRICULA) 
    VALUES 
    (235689, 3374, DATE '2021-08-13')

SELECT * FROM ALUNO, MATRICULA, CLASSE