CREATE TABLE ALUNO (
    id_aluno INT PRIMARY KEY,
    nome VARCHAR(100) NOT NULL,
    email VARCHAR(100)
    );

CREATE TABLE DISCIPLINA (
    id_disciplina INT PRIMARY KEY,
    nome NOT NULL,
    carga_horaria INT
    );

CREATE TABLE PROFESSORES (
    id_professor INT PRIMARY KEY,
    nome NOT NULL,
    titulacao TEXT
    );

CREATE TABLE CURSO (
    id_curso INT PRIMARY KEY,
    nome NOT NULL,
    duracao_semestres INT
    );

CREATE TABLE MATRICULA (
    id_matricula INT PRIMARY KEY,
    id_aluno INT,
    id_disciplina INT,
    semestre VARCHAR(10),
    FOREIGN KEY (id_aluno) REFERENCES ALUNO (id_aluno),
    FOREIGN KEY (id_disciplina) REFERENCES DISCIPLINA (id_disciplina)
    );

INSERT INTO ALUNO VALUES 
(1,'Ana','ana@email.com'),
(2,'Carlos','carlos@email.com');

INSERT INTO DISCIPLINA VALUES
(1,'Banco de Dados',80),
(2,'Programacao',100);

INSERT INTO PROFESSORES VALUES
(1,'Roberto','Mestre'),
(2,'Juliana','Doutora');

INSERT INTO CURSO VALUES
(1,'ADS',6),
(2,'Engenharia',10);

INSERT INTO MATRICULA VALUES
(1,1,1,'2025-1'),
(2,2,2,'2025-1');
select * from aluno ;
select * from curso ;
select * from matricula ;