MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| creche             |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.02 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
5 rows in set (0.00 sec)

MariaDB [(none)]> create database escola;
Query OK, 1 row affected (0.00 sec)


MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| escola             |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.00 sec)

MariaDB [(none)]> use escola;
Database changed
MariaDB [escola]> create table Professor;
ERROR 1113 (42000): A table must have at least 1 column
MariaDB [escola]> create table Professor(idP int auto_increment primary key, Nome varchar(200) not null, CPF int not null, Telefone int not null, Endereco varchar(200) not null, Nascimento Date not null);
Query OK, 0 rows affected (0.03 sec)





MariaDB [escola]> create table Atividades(idA int auto_increment primary key, Nome varchar(200));
Query OK, 0 rows affected (0.03 sec)

MariaDB [escola]> create table turma(idT int auto_increment, primary key(idT) , idM int, nome varchar(200) );

create table agenda(idP int , idT int, idA int, Dia_da_Semana date, FOREIGN KEY (idP) references Professor(idP),FOREIGN KEY (idT) references turma(idT), FOREIGN KEY (idA) references Atividades(idA));

MariaDB [escola]> describe agenda;

MariaDB [escola]> create table aluno(idM int auto_increment primary key, CPF int not null, Nome_aluno varchar(200) not null, Telefone int not null, idT int, endereco varchar(255), email varchar(200), responsavel varchar(200));

ALTER TABLE turma
ADD FOREIGN KEY (idM) REFERENCES aluno(idM); 


create table Disciplina (ID_disciplina int, CargaHorariaDisciplina int, NomeDisciplina varchar(200) );


create table historico (cod_aluno int,
 CONSTRAINT cod_aluno FOREIGN KEY (idM) REFERENCES aluno(idM),
 Situacao_aluno varchar(200),
 nota int,
 cod_disciplina int,
 CONSTRAINT cod_disciplina FOREIGN KEY (ID_disciplina) REFERENCES Disciplina(ID_disciplina)
 );