Preciso de Ajuda
339 palavras
2 páginas
1 – create database bancodedados;2 – use bancodedados;
3 – insert into aluno values ( ‘1’, ‘Marcos’, ‘marcos@hotmail.com’, ‘44554432’, ‘98789989’, 5, 500, 10); insert into aluno values ( ‘2’, ‘Alfredo’, ‘alfredo@hotmail.com’, ‘44154432’, ‘98889989’, 4, 800, 11); insert into aluno values ( ‘3’, ‘paula’, ‘paula@hotmail.com’, ‘44354432’, ‘98788889’, 5, 500, 10); insert into aluno values ( ‘4’, ‘Margarida’, ‘margarida@gmail.com’, ‘44234432’, ‘98899989’, 3, 800, 11); insert into aluno values ( ‘5’, ‘Pedro’, ‘pedro@uol.com.br’, ‘44534432’, ‘98819989’, 7, 900, 12); insert into aluno values ( ‘6’, ‘Marcia’, ‘marcia@gmail.com’, ‘44551232’, ‘98789879’, 3, 500, 13); insert into aluno values ( ‘7’, ‘Ronaldo’, ‘ronaldo@ig.com.br’, ‘44891432’, ‘98949989’, 7, 200, 14); insert into aluno values ( ‘8’, ‘Narcisa’, ‘narcisa@hotmail.com’, ‘44558952’, ‘98787419’, 4, 700, 10); insert into aluno values ( ‘9’, ‘Antonieta’, ‘antonieta@hotmail.com’, ‘44552032’, ‘98000989’, 8, 600, 13); insert into aluno values ( ‘10’, ‘Rogerio’, ‘rogerio@hotmail.com’, ‘44552432’, ‘98712189’, 3, 400, 10);
4 – insert into curso
(cur_codigo, cur_sigla, cur_nome, cur_duracao, cur_coordenador);
Insert into curso
Values (10, ‘info’, ‘informatica’, ‘3’, ‘Celso’);
Insert into curso
Values (11, ‘Rh’, ‘Recursos’, ‘3’, ‘Mario’);
Insert into curso
Values (12, ‘Adm’, ‘Administração’, ‘2’, ‘Amarildo’);
Insert into curso
Values (13, ‘Log’, ‘Logistica’, ‘2’, ‘Ana’);
Insert into curso
Values (14, ‘Ads’, ‘Sistemas’, ‘3’, ‘Paula’);
5 – alter table aluno
Add alu_anoinicio integer;
6 – select cur_nome, cur_coordenador
From curso
Order by cur_nome;
7 – select alu_ra, alu_nome, alu_valormensalidade
From aluno a, curso c
Where cur_nome-=’logistica’ and
c.cur_codigo=a.cur_codigo
order by alu_nome desc;
8 – select alu_nome, alu_email, alu_celular
From aluno
Where alu_email=’%gmail%’
Order by alu_email;
9 – select alu_nome, cur_nome
From aluno a, curso c
Where a.alu_ra=c.cur_codigo