SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira –...
Transcript of SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira –...
![Page 1: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/1.jpg)
Sistema de Gerenciamento de Pessoas e ProjetosSGPP – CITi
II Entrega - APS
![Page 2: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/2.jpg)
Equipe
Flávio Juvenal – fjsj
Lais Varejão – lvv
Paulo Oliveira – phslfo
Victor Alencar - vaca
![Page 3: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/3.jpg)
Roteiro
Evolução da Arquitetura
Projeto de Casos de UsoCRUD Pessoa
Projeto de Subsistema
Enviar Chamada por email
Projeto de Banco de Dados
![Page 4: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/4.jpg)
Segundo Padrões de Projeto
Evolução da Arquitetura
![Page 5: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/5.jpg)
![Page 6: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/6.jpg)
PASSIVE VIEW MVC
FACADEITERATOR
BRIDGE
![Page 7: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/7.jpg)
1º Projeto de Caso de Uso
CRUD Pessoa
![Page 8: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/8.jpg)
CRUD Pessoa
CRUD Pessoa
![Page 9: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/9.jpg)
CRUD Pessoa
Operação que insere uma nova Pessoa no sistema e permite visualizá-la, editá-la e removê-la.
![Page 10: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/10.jpg)
Classes de Análise
![Page 11: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/11.jpg)
Elementos de Projeto
![Page 12: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/12.jpg)
Mapeamento de Análise para ProjetoClasses de Análise Elementos de Projetos
![Page 13: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/13.jpg)
Mapeamento de Análise para ProjetoClasses de Análise Elementos de Projetos
![Page 14: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/14.jpg)
Mapeamento de Análise para ProjetoClasses de Análise Elementos de Projetos
![Page 15: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/15.jpg)
Diagrama de Sequência - Análise
![Page 16: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/16.jpg)
Diagrama de Sequência - Projeto
![Page 17: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/17.jpg)
Diagrama de Classe - Análise
![Page 18: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/18.jpg)
Diagrama de Classe - Projeto
![Page 19: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/19.jpg)
Projeto de Subsistema
Enviar Chamada por Email
![Page 20: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/20.jpg)
Enviar Chamada por Email
EnviarEmail
![Page 21: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/21.jpg)
Enviar Chamada por Email
Operação que envia um email com uma chamada de desenvolvedores para um projeto escolhido. Os recipientes desse e-mail serão todos os endereços de email contidos em um arquivo de texto.
![Page 22: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/22.jpg)
Classes de Análise
![Page 23: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/23.jpg)
Elementos de Projeto
![Page 24: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/24.jpg)
Mapeamento de Análise para ProjetoClasses de Análise Elementos de Projetos
![Page 25: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/25.jpg)
Mapeamento de Análise para Projeto
![Page 26: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/26.jpg)
Diagrama de Sequência - Análise
![Page 27: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/27.jpg)
Diagrama de Sequência - Projeto
![Page 28: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/28.jpg)
Diagrama de Classes - Análise
![Page 29: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/29.jpg)
Diagrama de Classes - Projeto
![Page 30: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/30.jpg)
Projeto de Banco de Dados
![Page 31: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/31.jpg)
Mapeamento de Classes Persistentes
![Page 32: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/32.jpg)
Mapeamento dos Relacionamentos
![Page 33: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/33.jpg)
Mapeamento dos Relacionamentos
![Page 34: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/34.jpg)
Identificação de Índices
Os índices identificados foram todas as chaves primárias, já representadas no diagrama e alguns outros atributos. São eles:
Na tabela Pessoa: CPF, RG, email.
Na tabela Membro: login, emailCITi.
Na tabela Contratante: CPF, CNPJ.
![Page 35: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/35.jpg)
Restrições de Integridade
As restrições de integridade foram definidas através do SGBD na criação das tabelas por definição de CONSTRAINTS estabelecendo a integridade de Chaves Primárias e Estrangeiras.
![Page 36: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/36.jpg)
Estruturas de Armazenamento
Tabela Endereço
CREATE TABLE IF NOT EXISTS `ENDERECO` ( `IDENDERECO` INT NOT NULL AUTO_INCREMENT , `RUA` VARCHAR(45) NULL , `NUMERO` SMALLINT NULL , `COMPLEMENTO` VARCHAR(15) NULL , `BAIRRO` VARCHAR(45) NULL , `CIDADE` VARCHAR(45) NULL , `ESTADO` VARCHAR(45) NULL ,
`CEP` VARCHAR(10) NULL , PRIMARY KEY (`IDENDERECO`) , UNIQUE INDEX `IDENDERECO_UNIQUE` (`IDENDERECO` ASC) ) ENGINE = INNODB;
![Page 37: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/37.jpg)
Estruturas de Armazenamento
Tabela PessoaCREATE TABLE IF NOT EXISTS ` PESSOA` ( `IDPESSOA` INT NOT NULL AUTO_INCREMENT , `NOME` VARCHAR(45) NOT NULL , `CPF` VARCHAR(14) NULL , `RG` VARCHAR(7) NULL , `DATANASC` DATE NULL , `EMAIL` VARCHAR(45) NOT NULL , `TELEFONE` VARCHAR(20) NULL , `CELULAR` VARCHAR(20) NULL , `SKYPE` VARCHAR(45) NULL , `MSN` VARCHAR(45) NULL , `OBS` TEXT NULL , `FOTO` VARCHAR(300) NULL , `CURRICULO` VARCHAR(300) NULL , `CURSO` VARCHAR(45) NULL , `INSTITUICAO` VARCHAR(45) NULL , `ENTRADACURSO` DATE NULL , `CONCLUSAOCURSO` DATE NULL ,
`IDENDERECO` INT NULL , PRIMARY KEY (`IDPESSOA`) , UNIQUE INDEX `IDPESSOA_UNIQUE` (`IDPESSOA` ASC) , INDEX `FK_PESSOA_ENDERECO1` (`IDENDERECO` ASC) , UNIQUE INDEX `CPF_UNIQUE` (`CPF` ASC) , UNIQUE INDEX `RG_UNIQUE` (`RG` ASC) , CONSTRAINT `FK_PESSOA_ENDERECO1` FOREIGN KEY (`IDENDERECO` ) REFERENCES ` ENDERECO` (`IDENDERECO` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = INNODB;
![Page 38: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/38.jpg)
Características de Armazenamento.
O banco de dados será armazenado no mesmo servidor do sistema, para isso serão necessários a princípio, cerca de 2GB de memória.
![Page 39: SGPP – CITi II Entrega - APS. Flávio Juvenal – fjsj Lais Varejão – lvv Paulo Oliveira – phslfo Victor Alencar - vaca.](https://reader036.fdocument.pub/reader036/viewer/2022081518/552fc130497959413d8d468f/html5/thumbnails/39.jpg)
Dúvidas?