Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE SOFTWARE(ID_SOFTWARE NUMBER(9) NOT NULL, NOME_SOFTWARE VARCHAR(30) NOT NULL, VERSAO_SOFTWARE NUMBER(10), DESENVOLVEDORA_SOFTWARE VARCHAR(100), FINALIDADE_SOFTWARE VARCHAR(100), TAMANHO_SOFTWARE VARCHAR(5) NOT NULL);
- CREATE TABLE NOTEBOOK(ID_NOTEBOOK NUMBER(20) NOT NULL, MATRICULA_ALUNO NUMBER(30) NOT NULL, ID_SOFTWARE NUMBER(20) NOT NULL, MARCA_NOTEBOOK VARCHAR(20) NOT NULL, MODELO_NOTEBOOK VARCHAR(20), SIST_OP_NOTEBOOK VARCHAR(30) NOT NULL, MEM_RAM_NOTEBOOK NUMERIC(2), MEM_HD_NOTEBOOK NUMBER(4));
- CREATE TABLE ALUNO(MATRICULA_ALUNO NUMBER(20) NOT NULL, NOME_ALUNO VARCHAR(100) NOT NULL, DATA_NASC_ALUNO DATE, CURSO_ALUNO VARCHAR(100), CPF_ALUNO NUMERIC(11) NOT NULL, SEXO_ALUNO VARCHAR(1));
- ALTER TABLE SOFTWARE ADD PRIMARY KEY (ID_SOFTWARE);
- ALTER TABLE NOTEBOOK ADD PRIMARY KEY (ID_NOTEBOOK);
- ALTER TABLE ALUNO ADD PRIMARY KEY (MATRICULA_ALUNO);
- ALTER TABLE NOTEBOOK ADD FOREIGN KEY (MATRICULA_ALUNO) REFERENCES ALUNO (MATRICULA_ALUNO);
- ALTER TABLE NOTEBOOK ADD FOREIGN KEY (ID_SOFTWARE) REFERENCES SOFTWARE (ID_SOFTWARE);
- INSERT INTO ALUNO (MATRICULA_ALUNO, NOME_ALUNO, CPF_ALUNO) VALUES ('1234', 'PEDRO AUGUSTO', '09394445901');
- INSERT INTO ALUNO (MATRICULA_ALUNO, NOME_ALUNO, CPF_ALUNO) VALUES ('4321', 'HENRIQUE FONSECA', '09378945611');
- INSERT INTO SOFTWARE (ID_SOFTWARE, NOME_SOFTWARE, TAMANHO_SOFTWARE) VALUES ('00001', 'COREL DRAW', '500');
- INSERT INTO SOFTWARE (ID_SOFTWARE, NOME_SOFTWARE, TAMANHO_SOFTWARE) VALUES ('00002', 'PHOTOSCAPE', '100');
- INSERT INTO NOTEBOOK (ID_NOTEBOOK, MATRICULA_ALUNO, ID_SOFTWARE, MARCA_NOTEBOOK, SIST_OP_NOTEBOOK) VALUES ('00099', '1234', '00001', 'DELL', 'WIN 10');
- INSERT INTO NOTEBOOK (ID_NOTEBOOK, MATRICULA_ALUNO, ID_SOFTWARE, MARCA_NOTEBOOK, SIST_OP_NOTEBOOK) VALUES ('00077', '4321', '00002', 'POSITIVO', 'UBUNTU');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement