School Basic
Statement 1
CREATE TABLE Aluno
Rgm NUMBER (8) NOT NULL
Nm_Nome VARCHAR2 (40)
Nm_Pai VARCHAR2 (40)
Nm_Mae VARCHAR2 (40)
Dt Nascimento DATE Id_Sexo CHAR (1) )
Table created.
Statement 2
ALTER TABLE Aluno ADD CONSTRAINT Aluno PK PRIMARY KEY ( Nr_Rgm )
Table altered.
Statement 3
CREATE
TABLE Classe
Cd_C1asse NUMBER (8) NOT NULL
Nr_AnoLetivo NUMBER (4) Nr_Serie NUMBER (2)
sg_Turma VARCHAR2 (2)
Cd_Esc01a NUMBER (6)
Cd_Grau NUMBER (2)
Cd_ Periodo NUMBER (2) )
Statement
ALTER TABLE Classe ADD CONSTRAINT Classe PK PRIMARY KEY ( Cd_C1asse )
Table altered.
Statement 5
CREATE
TABLE Matricula
Dt Matricula DATE NOT NULL
Nr_Rgm NUMBER (8) NOT NULL
Cd_C1asse NUMBER (8) NOT NULL )
Table created.
Statement 6
ALTER TABLE Matricula ADD CONSTRAINT Matricula_PK PRIMARY KEY ( Dt_Matricu1a )
Table altered.
Statement 7
ALTER TABLE Matricula ADD CONSTRAINT
Cd Classe FK FOREIGN KEY ( Cd_C1asse )
REFERENCES Classe ( Cd_C1asse )
Table altered.
Statement 8
ALTER TABLE Matricula ADD CONSTRAINT
FOREIGN KEY ( Nr_Rgm ) REFERENCES Aluno ( Nr_Rgm )
Table altered.
Statement 9
CREATE
TABLE Aluno
Nr_Rgm NUMBER (8) NOT NULL
Nm_Nome VARCHAR2 (40)
Nm_Pai VARCHAR2 (40)
Nm_Mae VARCHAR2 (40)
Dt Nascimento DATE
Id Sexo CHAR (1) )
Statement 10
ALTER TABLE Aluno ADD CONSTRAINT Aluno PK PRIMARY KEY ( Nr_Rgm )
Table altered.
Statement 11
CREATE
TABLE Classe
Cd_C1asse NUMBER (8) NOT NULL
Nr_AnoLetivo NUMBER (4) Nr_Serie NUMBER (2)
sg_Turma VARCHAR2 (2)
Cd_Esc01a NUMBER (6)
Cd_Grau NUMBER (2)
Cd_Periodo NUMBER (2) )
Table created.
Statement 12
ALTER TABLE Classe ADD CONSTRAINT Classe PK PRIMARY KEY ( Cd _Classe )
Table altered.
Statement 13
CREATE
TABLE Matricula
Dt Matricula DATE NOT NULL
Nr_Rgm NUMBER (8) NOT NULL
Cd_C1asse NUMBER (8) NOT NULL
Table created.
Statement 14
ALTER TABLE Matricula ADD CONSTRAINT Matricula_PK PRIMARY KEY ( Dt_Matricu1a )
Table altered.
Statement 15
ALTER TABLE Matricula ADD CONSTRAINT FOREIGN KEY ( Cd_C1asse ) REFERENCES Classe ( Cd_Classe )
Statement 16
ALTER TABLE Matricula ADD CONSTRAINT FOREIGN KEY ( Nr_Rgm ) REFERENCES Aluno ( Nr_Rgm )
Table altered.
0 2022 Oracle • Live SQL 22.1.3, running Oracle Database 19c Enterprise Edition - 19.8.0.0.0 • Database Documentation • Ask Tom • Dev GymBuilt with using Oracle
