spcfCswq

1Create database if not exists Projectores;
2Use Projectores;
3Create Table projectores(Nome varchar(30) Not Null,modelo varchar(15) Not Null,Funcional varchar(3),Cod_Projector Varchar(100)not null primary key);
4create table professores(NrProfessor varchar(50)not null primary key,Nome varchar(50) not null,GrupoDisciplinar varchar (15)not null);
5create table REQUISIÇoES(NrRequisicao varchar (100)not null primary key,dia date not null,tempo varchar(5) not null, foreign key (NrProfessor) REFERENCES professores(NrProfessor), foreign key (Cod_Projector) references projectores(Cod_Projector));