<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-1703071723259543372</id><updated>2020-04-11T23:48:38.133-07:00</updated><title type='text'>Rosemberg Lima</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://rosemberg-lima.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://rosemberg-lima.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Rosemberg Bezerra</name><uri>http://www.blogger.com/profile/07763219985104822784</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>6</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-1703071723259543372.post-4938345843097654732</id><published>2011-02-23T08:03:00.000-08:00</published><updated>2020-04-04T05:58:00.559-07:00</updated><title type='text'>Servlet + JSP</title><content type='html'>Nesses últimos meses, passei um bom tempo sem atualizar aqui.&lt;br /&gt;Mas agora estou voltando com força total para mostrar alguns exemplos de um determinado assunto.&lt;br /&gt;&lt;br /&gt;Hoje eu trabalho com Servlet e JSP, então o que faço no dia-a-dia no trabalho, vou postar aqui pequenas&lt;br /&gt;demonstrações, onde, com certeza, irão ajudar vocês.&lt;br /&gt;&lt;br /&gt;Muitos pensam que programação é algo do outro mundo, pelo fato de lidar com várias letrinhas (códigos) onde quem vê, não entende nada. Na verdade, nada é fácil, e o que é fácil não presta.&lt;br /&gt;Na área de Desenvolvimento de Sistemas, o que faz com que o programador saiba dominar bem uma certa linguagem é, além da prática, o estudo.&lt;br /&gt;&lt;br /&gt;Quem trabalha na área, consegue adquirir uma ampla experiência por um fato óbvio, a pratica daquela linguagem todos os dias. O difícil talvez aqui em Caruaru e Região seja arrumar esse trabalho.&lt;br /&gt;&lt;br /&gt;Falando um pouco do JSP, Java Server Page, é uma linguagem Web que manipula dados vindo de um formulário HTML. Isso estou falando de forma bem simples. Como o JSP recebe esses dados, pelo Servlet.&lt;br /&gt;Está explicado a função do Servlet agora né?!&lt;br /&gt;&lt;br /&gt;A logica é o seguinte: HTML -&amp;gt; Servlet -&amp;gt; Controlador -&amp;gt; DAO -&amp;gt; Banco de Dados.&lt;br /&gt;&lt;br /&gt;Essa é a ordem de entrada de dados, recebendo pelo método Post no formulario HTML.&lt;br /&gt;No Servlet exitem dois métodos, o Post e o Get. Vou nem falar para que serve, é algo lógico.&amp;nbsp;Conseqüentemente, em um formulário HTML, tambem existem esses dois tipos de form.&lt;br /&gt;&lt;br /&gt;O Controlador servirá para tratar informações, questão de validações de dados, condições e etc.&lt;br /&gt;O DAO servirá como repositório, ou seja, comandos de SQL.&lt;br /&gt;- Ponto Positivo: &amp;nbsp;para funcionalidades básicas como o CRUD, o DAO ja possui métodos prontos, isso quer dizer que você não precisa se estressar com comandos SQL.&lt;br /&gt;- Ponto Negativo: para funcionalidades com condições, envolvendo WHERE em consultas, por exemplo, você irá ter que aprofundar mais o conhecimento.&lt;br /&gt;&lt;br /&gt;Claro que eu vou postar aqui alguns exemplos. Relaxe!&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Bom, até logo.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Rosemberg Lima -</content><link rel='replies' type='application/atom+xml' href='http://rosemberg-lima.blogspot.com/feeds/4938345843097654732/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://rosemberg-lima.blogspot.com/2011/02/servlet-jsp.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/4938345843097654732'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/4938345843097654732'/><link rel='alternate' type='text/html' href='http://rosemberg-lima.blogspot.com/2011/02/servlet-jsp.html' title='Servlet + JSP'/><author><name>Rosemberg Bezerra</name><uri>http://www.blogger.com/profile/07763219985104822784</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1703071723259543372.post-2827767503774277482</id><published>2010-10-20T21:24:00.000-07:00</published><updated>2010-10-20T21:37:17.342-07:00</updated><title type='text'>Revisão - Banco de Dados Avançado (FAFICA)</title><content type='html'>&lt;p class=&quot;MsoNormal&quot; align=&quot;center&quot; style=&quot;text-align:center&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;Revisão de Banco de Dados Avançado&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;text-indent:-18.0pt;mso-list:l1 level1 lfo1&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;1-&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;Explique DETALHADAMENTE cada um os códigos a seguir evitando AMBIGÜIDADES e levando em consideração que o usuário &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;sicrano&lt;/i&gt; criou as tabelas DVD e cliente:&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto;text-indent:-18.0pt;mso-list:l2 level1 lfo2&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-bidi-font-family: Calibri;mso-bidi-theme-font:minor-latin;mso-ansi-language:EN-US&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;a)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;Usuário &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;sicrano&lt;/i&gt;: &lt;span style=&quot;mso-tab-count:1&quot;&gt;     &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;grant&lt;/b&gt; insert, select&lt;span style=&quot;mso-tab-count:1&quot;&gt;         &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;on&lt;/b&gt; cliente&lt;span style=&quot;mso-tab-count: 1&quot;&gt;           &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;to&lt;/b&gt; public&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language:EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- O usuário sicrano deu permissão de inserção e busca de dados para qualquer um usuário na tabela cliente.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto;text-indent:-18.0pt;mso-list:l2 level1 lfo2&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-bidi-font-family: Calibri;mso-bidi-theme-font:minor-latin;mso-ansi-language:EN-US&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;b)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;Usuário &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;sicrano&lt;/i&gt;:&lt;span style=&quot;mso-tab-count:1&quot;&gt;      &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;grant &lt;/b&gt;all&lt;span style=&quot;mso-tab-count:2&quot;&gt;                               &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;on &lt;/b&gt;dvd&lt;span style=&quot;mso-tab-count:2&quot;&gt;                 &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;to&lt;/b&gt; beltrano&lt;span style=&quot;mso-tab-count: 1&quot;&gt;         &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;with &lt;/b&gt;grant option&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language:EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- O usuário sicrano deu todas as permissões ao usuário beltrano, podendo também repassar as mesmas permissões para outros usuários.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto;text-indent:-18.0pt;mso-list:l2 level1 lfo2&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-bidi-font-family: Calibri;mso-bidi-theme-font:minor-latin;mso-ansi-language:EN-US&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;c)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;Usuário &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;beltrano&lt;/i&gt;:&lt;span style=&quot;mso-tab-count:1&quot;&gt;   &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;grant &lt;/b&gt;update, delete&lt;span style=&quot;mso-tab-count:1&quot;&gt;     &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;on &lt;/b&gt;dvd&lt;span style=&quot;mso-tab-count:2&quot;&gt;                 &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;to&lt;/b&gt; fulano&lt;span style=&quot;mso-tab-count: 1&quot;&gt;             &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;with &lt;/b&gt;grant option&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language:EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- O usuário beltrano deu a permissão de atualizar e deletar dados da tabela DVD para fulano, podendo também repassar as mesmas permissões para outros usuários&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto;text-indent:-18.0pt;mso-list:l2 level1 lfo2&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-bidi-font-family: Calibri;mso-bidi-theme-font:minor-latin;mso-ansi-language:EN-US&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;d)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;Usuário &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;fulano&lt;/i&gt;:&lt;span style=&quot;mso-tab-count:1&quot;&gt;       &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;grant &lt;/b&gt;update&lt;span style=&quot;mso-tab-count:2&quot;&gt;                     &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;on &lt;/b&gt;dvd&lt;span style=&quot;mso-tab-count:2&quot;&gt;                 &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;to&lt;/b&gt; josias&lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- O usuário fulano deu permissão de atualizar dados na tabela dvd para josias&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto;text-indent:-18.0pt;mso-list:l2 level1 lfo2&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-bidi-font-family: Calibri;mso-bidi-theme-font:minor-latin;mso-ansi-language:EN-US&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;e)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;Usuário &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;sicrano&lt;/i&gt;:&lt;span style=&quot;mso-tab-count:1&quot;&gt;      &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;revoke &lt;/b&gt;update&lt;span style=&quot;mso-tab-count:2&quot;&gt;                 &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;on &lt;/b&gt;dvd&lt;span style=&quot;mso-tab-count:2&quot;&gt;                 &lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;from&lt;/b&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;beltrano&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt; &lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left:54.0pt;mso-add-space:auto&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- O usuário sicrano retirou a permissão de atualizar dados na tabela dvd de beltrano, por isso o usuário fulano também perdeu essa permissão, por receber a mesma de beltrano e conseqüentemente o usuário josias também perdeu a mesma permissão por receber de fulano.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;text-indent:-18.0pt;mso-list:l1 level1 lfo1&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;2-&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;Tomando como base os tipos de RESTIÇÃO DE INTEGRIDADE apresentados em sala de aula (Integridade Referencial, Restrição de Chave, de Domínio e de Entidade) e os códigos abaixo, favor responder:&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;Codigo 1&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;table class=&quot;MsoTableGrid&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; style=&quot;margin-left:36.0pt;border-collapse:collapse;border:none;mso-border-alt:  solid black .5pt;mso-border-themecolor:text1;mso-yfti-tbllook:1184;mso-padding-alt:  0cm 5.4pt 0cm 5.4pt&quot;&gt;  &lt;tbody&gt;&lt;tr style=&quot;mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes&quot;&gt;   &lt;td width=&quot;576&quot; valign=&quot;top&quot; style=&quot;width:432.2pt;border:solid black 1.0pt;   mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;Create   table &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;departamentos&lt;/b&gt; (&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;codDepto   integer,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;nome   varchar(20) &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;check (&lt;/b&gt;&lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;nome in ‘Vendas’, ‘Pessoal’,’Finanças’,   ‘Administrativo’&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;)&lt;/b&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/i&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;font-size:   9.0pt;mso-ansi-language:EN-US&quot;&gt;andar integer &lt;b style=&quot;mso-bidi-font-weight:   normal&quot;&gt;check (&lt;/b&gt;andar between 1 and 10&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;)&lt;/b&gt;,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;font-size:   9.0pt;mso-ansi-language:EN-US&quot;&gt;orçamento numeric (20,2),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;font-size:9.0pt;mso-ansi-language:EN-US&quot;&gt;constraint &lt;/span&gt;&lt;/b&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;font-size:9.0pt;mso-ansi-language:EN-US&quot;&gt;DeptPK &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;primary key &lt;/b&gt;(codDepto));&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language:EN-US&quot;&gt;Código 2&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;table class=&quot;MsoTableGrid&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; style=&quot;margin-left:36.0pt;border-collapse:collapse;border:none;mso-border-alt:  solid black .5pt;mso-border-themecolor:text1;mso-yfti-tbllook:1184;mso-padding-alt:  0cm 5.4pt 0cm 5.4pt&quot;&gt;  &lt;tbody&gt;&lt;tr style=&quot;mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes&quot;&gt;   &lt;td width=&quot;576&quot; valign=&quot;top&quot; style=&quot;width:432.2pt;border:solid black 1.0pt;   mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;Create   table &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;Aluno_Disciplina &lt;/b&gt;(&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;id_aluno   int,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;id_disciplina   int,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;constraint &lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;fkAluno   &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;foreign key&lt;/b&gt; (id_aluno) &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;references&lt;/b&gt; Aluno(id_aluno),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;constraint&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;   fkDisciplina&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt; foreign key &lt;/b&gt;(id_disciplina)   &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;references &lt;/b&gt;Disciplina   (id_disciplina),&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;);&lt;/span&gt;&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;Código 3&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;table class=&quot;MsoTableGrid&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; style=&quot;margin-left:36.0pt;border-collapse:collapse;border:none;mso-border-alt:  solid black .5pt;mso-border-themecolor:text1;mso-yfti-tbllook:1184;mso-padding-alt:  0cm 5.4pt 0cm 5.4pt&quot;&gt;  &lt;tbody&gt;&lt;tr style=&quot;mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes&quot;&gt;   &lt;td width=&quot;576&quot; valign=&quot;top&quot; style=&quot;width:432.2pt;border:solid black 1.0pt;   mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;Create   table Aluno_Disciplina (&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;id_aluno   int,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;id_disciplina   int,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;constraint &lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;fkAluno   &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;foreign key&lt;/b&gt; (id_aluno) &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;references&lt;/b&gt; Aluno(id_aluno)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;ON DELETE CASCADE,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;constraint&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;   fkDisciplina&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt; foreign key &lt;/b&gt;(id_disciplina)   &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;references &lt;/b&gt;Disciplina   (id_disciplina)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;ON DELETE CASCADE&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt&quot;&gt;);&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto;text-indent:-18.0pt;mso-list:l3 level1 lfo3&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;a)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;Quais tipos de Restrições de Integridade são respeitadas de acordo com o código 1? Justifique sua resposta apontando que partes do código asseguram cada restrição.&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:35.4pt;mso-add-space: auto&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R – O primeiro código se refere às Restrições de Chave e de Entidade(&lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt;line-height:115%;color:red&quot;&gt;constraint &lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size:9.0pt;line-height:115%;color:red&quot;&gt;DeptPK &lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;primary key &lt;/b&gt;(codDepto));&lt;/span&gt;&lt;span style=&quot;color:red&quot;&gt;) onde a chave primária não pode ser nula (NOT NULL) e única (UNIQUE). Também utiliza a Restrição de Domínio (&lt;/span&gt;&lt;span style=&quot;font-size:9.0pt;line-height:115%; color:red&quot;&gt;nome varchar(20) &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;check (&lt;/b&gt;&lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;nome in ‘Vendas’, ‘Pessoal’,’Finanças’, ‘Administrativo’&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;)&lt;/b&gt;,&lt;/i&gt;andar integer &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;check (&lt;/b&gt;andar between 1 and 10&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;)&lt;/b&gt;,) &lt;/span&gt;&lt;span style=&quot;color:red&quot;&gt;pois coloca um limite nos dados da tabela.&lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/i&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto;text-indent:-18.0pt;mso-list:l3 level1 lfo3&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;b)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;Que tipo de Restrição de Integridade os códigos 2 e 3 asseguram? Justifique suas respostas apontando a parte do código que assegura a mesma.&lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:54.0pt;mso-add-space: auto&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:35.4pt;mso-add-space: auto&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- Ambos estão aderindo a Restrição de Integridade Referencial (&lt;/span&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;font-size:9.0pt;line-height:115%;color:red&quot;&gt;constraint &lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size:9.0pt;line-height:115%;color:red&quot;&gt;fkAluno &lt;b style=&quot;mso-bidi-font-weight: normal&quot;&gt;foreign key&lt;/b&gt; (id_aluno) &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;references&lt;/b&gt; Aluno(id_aluno)&lt;/span&gt;&lt;span style=&quot;color:red&quot;&gt;), ou seja, garante a integridade da base de dados quando os P.ks são referenciadas em outras relações. O terceiro código acrescenta o &lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;ON DELETE CASCADE&lt;/b&gt;, onde se o atributo pai for deletado, todos os filhos também serão. Com isso, no Codigo 2, se o atributo pai tentar se deletado, não será permitido, pois terá atributos dependente dele em outras tabelas.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left:35.4pt;mso-add-space: auto&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l1 level1 lfo1&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;3-&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;A tabela abaixo respeita a &lt;u&gt;segunda forma normal?&lt;/u&gt; Justifique suas resposta.&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;table class=&quot;MsoTableGrid&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; style=&quot;margin-left:36.0pt;border-collapse:collapse;border:none;mso-border-alt:  solid black .5pt;mso-border-themecolor:text1;mso-yfti-tbllook:1184;mso-padding-alt:  0cm 5.4pt 0cm 5.4pt&quot;&gt;  &lt;tbody&gt;&lt;tr style=&quot;mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes&quot;&gt;   &lt;td width=&quot;576&quot; valign=&quot;top&quot; style=&quot;width:432.2pt;border:solid black 1.0pt;   mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;ALUNOS   ( &lt;u&gt;CodAluno, &lt;/u&gt;Nome, Morada, &lt;u&gt;CodDisciplina&lt;/u&gt;, Disciplina)&lt;o:p&gt;&lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/b&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- Não, pois não são todos os atributos que depende das chaves primárias.&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;O jeito certo de fazer essa tabela seria separá-los por dependência. Ou seja:&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;ALUNOS(&lt;u&gt;CodAluno&lt;/u&gt;, Nome, Morada)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;DISCIPLINA(&lt;u&gt;CodDisciplina&lt;/u&gt;, Disciplina)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l1 level1 lfo1&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;4-&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;A tabela abaixo respeita a &lt;u&gt;primeira forma normal?&lt;/u&gt; Justifique sua resposta.&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;table class=&quot;MsoTableGrid&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; style=&quot;border-collapse:collapse;border:none;mso-border-alt:solid black .5pt;  mso-border-themecolor:text1;mso-yfti-tbllook:1184;mso-padding-alt:0cm 5.4pt 0cm 5.4pt&quot;&gt;  &lt;tbody&gt;&lt;tr style=&quot;mso-yfti-irow:0;mso-yfti-firstrow:yes&quot;&gt;   &lt;td width=&quot;111&quot; valign=&quot;top&quot; style=&quot;width:83.4pt;border:solid black 1.0pt;   mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;background:black;mso-background-themecolor:text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; align=&quot;center&quot; style=&quot;margin:0cm;   margin-bottom:.0001pt;mso-add-space:auto;text-align:center;line-height:normal&quot;&gt;&lt;u&gt;CodAluno&lt;o:p&gt;&lt;/o:p&gt;&lt;/u&gt;&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;113&quot; valign=&quot;top&quot; style=&quot;width:3.0cm;border:solid black 1.0pt;   mso-border-themecolor:text1;border-left:none;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;background:black;mso-background-themecolor:text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; align=&quot;center&quot; style=&quot;margin:0cm;   margin-bottom:.0001pt;mso-add-space:auto;text-align:center;line-height:normal&quot;&gt;Nome&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;94&quot; valign=&quot;top&quot; style=&quot;width:70.85pt;border:solid black 1.0pt;   mso-border-themecolor:text1;border-left:none;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;background:black;mso-background-themecolor:text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; align=&quot;center&quot; style=&quot;margin:0cm;   margin-bottom:.0001pt;mso-add-space:auto;text-align:center;line-height:normal&quot;&gt;Morada&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;257&quot; valign=&quot;top&quot; style=&quot;width:192.9pt;border:solid black 1.0pt;   mso-border-themecolor:text1;border-left:none;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;background:black;mso-background-themecolor:text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; align=&quot;center&quot; style=&quot;margin:0cm;margin-bottom:   .0001pt;mso-add-space:auto;text-align:center;line-height:normal&quot;&gt;Disciplinas&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt;  &lt;tr style=&quot;mso-yfti-irow:1&quot;&gt;   &lt;td width=&quot;111&quot; valign=&quot;top&quot; style=&quot;width:83.4pt;border:solid black 1.0pt;   mso-border-themecolor:text1;border-top:none;mso-border-top-alt:solid black .5pt;   mso-border-top-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;1214&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;113&quot; valign=&quot;top&quot; style=&quot;width:3.0cm;border-top:none;border-left:none;   border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Rua Costa&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;94&quot; valign=&quot;top&quot; style=&quot;width:70.85pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Rua A&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;257&quot; valign=&quot;top&quot; style=&quot;width:192.9pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Português, Matemática, Física&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt;  &lt;tr style=&quot;mso-yfti-irow:2&quot;&gt;   &lt;td width=&quot;111&quot; valign=&quot;top&quot; style=&quot;width:83.4pt;border:solid black 1.0pt;   mso-border-themecolor:text1;border-top:none;mso-border-top-alt:solid black .5pt;   mso-border-top-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;1250&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;113&quot; valign=&quot;top&quot; style=&quot;width:3.0cm;border-top:none;border-left:none;   border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Ana Maria&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;94&quot; valign=&quot;top&quot; style=&quot;width:70.85pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Rua B&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;257&quot; valign=&quot;top&quot; style=&quot;width:192.9pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Latim, Português, inglês&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt;  &lt;tr style=&quot;mso-yfti-irow:3&quot;&gt;   &lt;td width=&quot;111&quot; valign=&quot;top&quot; style=&quot;width:83.4pt;border:solid black 1.0pt;   mso-border-themecolor:text1;border-top:none;mso-border-top-alt:solid black .5pt;   mso-border-top-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;1356&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;113&quot; valign=&quot;top&quot; style=&quot;width:3.0cm;border-top:none;border-left:none;   border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Carla Silva&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;94&quot; valign=&quot;top&quot; style=&quot;width:70.85pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Av. ABC&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;257&quot; valign=&quot;top&quot; style=&quot;width:192.9pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Economia, Matemática, Direito&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt;  &lt;tr style=&quot;mso-yfti-irow:4;mso-yfti-lastrow:yes&quot;&gt;   &lt;td width=&quot;111&quot; valign=&quot;top&quot; style=&quot;width:83.4pt;border:solid black 1.0pt;   mso-border-themecolor:text1;border-top:none;mso-border-top-alt:solid black .5pt;   mso-border-top-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;1456&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;113&quot; valign=&quot;top&quot; style=&quot;width:3.0cm;border-top:none;border-left:none;   border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Hugo Leal&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;94&quot; valign=&quot;top&quot; style=&quot;width:70.85pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Bairro DEF&lt;/p&gt;   &lt;/td&gt;   &lt;td width=&quot;257&quot; valign=&quot;top&quot; style=&quot;width:192.9pt;border-top:none;border-left:   none;border-bottom:solid black 1.0pt;mso-border-bottom-themecolor:text1;   border-right:solid black 1.0pt;mso-border-right-themecolor:text1;mso-border-top-alt:   solid black .5pt;mso-border-top-themecolor:text1;mso-border-left-alt:solid black .5pt;   mso-border-left-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin:0cm;margin-bottom:.0001pt;   mso-add-space:auto;line-height:normal&quot;&gt;Português, Matemática&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt;  &lt;p class=&quot;MsoListParagraph&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;R- Não, pois a Primeira Forma exige que todos os atributos sejam Monovalorados, ou seja, possuam apenas um valor. O Atributo DISCIPLINA não obedece a essa regra.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraph&quot; style=&quot;text-indent:-18.0pt;mso-list:l1 level1 lfo1&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;5-&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;De acordo com a figura abaixo e tomando como base os conceitos de Modelo EER, favor assinalar a alternativa &lt;u&gt;falsa&lt;/u&gt;:&lt;span style=&quot;color:red&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot; align=&quot;center&quot; style=&quot;text-align:center&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;FIGURA&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot;&gt;( &lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;) Um empregado pode ser apenas um docente&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot;&gt;( &lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;) Um empregado pode ser apenas um pesquisador&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot;&gt;( &lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;) O símbolo ‘o’ presente na figura representa uma restrição de especialização do tipo &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;overlap &lt;/i&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;ou &lt;i style=&quot;mso-bidi-font-style: normal&quot;&gt;sobreposição.&lt;o:p&gt;&lt;/o:p&gt;&lt;/i&gt;&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot;&gt;( &lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;) Um empregado pode ser um pesquisado e um docente ao mesmo tempo.&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot;&gt;(&lt;span style=&quot;color:red&quot;&gt;X&lt;/span&gt; ) Um empregado não pode exercer o cargo de docente e pesquisador ao mesmo tempo.&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;text-indent:-18.0pt;mso-list:l1 level1 lfo1&quot;&gt;&lt;b style=&quot;mso-bidi-font-weight:normal&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri; mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;6-&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;Com base nos comandos básicos de SQL, e sempre que necessário, fazendo o uso das sintaxes dadas, faça o que se pede nos itens abaixo:&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;table class=&quot;MsoTableGrid&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; style=&quot;margin-left:36.0pt;border-collapse:collapse;border:none;mso-border-alt:  solid black .5pt;mso-border-themecolor:text1;mso-yfti-tbllook:1184;mso-padding-alt:  0cm 5.4pt 0cm 5.4pt&quot;&gt;  &lt;tbody&gt;&lt;tr style=&quot;mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes&quot;&gt;   &lt;td width=&quot;576&quot; valign=&quot;top&quot; style=&quot;width:432.2pt;border:solid black 1.0pt;   mso-border-themecolor:text1;mso-border-alt:solid black .5pt;mso-border-themecolor:   text1;background:black;mso-background-themecolor:text1;padding:0cm 5.4pt 0cm 5.4pt&quot;&gt;   &lt;p class=&quot;MsoListParagraphCxSpLast&quot; align=&quot;center&quot; style=&quot;margin:0cm;margin-bottom:   .0001pt;mso-add-space:auto;text-align:center;line-height:normal&quot;&gt;Select   nome(s)_da(s)_coluna(s) from nome_da_tabela where condição&lt;/p&gt;   &lt;/td&gt;  &lt;/tr&gt; &lt;/tbody&gt;&lt;/table&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;Cliente (&lt;u&gt;id&lt;/u&gt;, nome, sexo, data_de_nascimento, idade, cidade, estado)&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;DVD (&lt;u&gt;id&lt;/u&gt;, nome, gênero, direto, duração)&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;Cliente_loca_dvd (id_cliente,&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;id_dvd, data_locacao)&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;a)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização apenas dos campos &lt;u&gt;nome&lt;/u&gt; e &lt;u&gt;idade&lt;/u&gt; da tabela cliente&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select nome,idade from cliente&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;b)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização de &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;todos&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;os dados &lt;/i&gt;da tabela &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;cliente&lt;/i&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/i&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select * from cliente&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;c)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização dos &lt;u&gt;nomes&lt;/u&gt; dos clientes do &lt;u&gt;sexo&lt;/u&gt; masculino&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red; mso-ansi-language:EN-US&quot;&gt;Select nome from cliente where sexo =’M’&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;d)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização dos &lt;u&gt;nomes &lt;/u&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;dos clientes que moram no &lt;u&gt;estado &lt;/u&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;de Pernambuco&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select nome from cliente where estado = ‘PE’&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;e)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização dos &lt;u&gt;nomes&lt;/u&gt; dos clientes que NÃO moram no &lt;u&gt;estado &lt;/u&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;de Pernambuco&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select nome from cliente where estado != ‘PE’&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;f)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;       &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização de &lt;i style=&quot;mso-bidi-font-style:normal&quot;&gt;todos os dados &lt;/i&gt;&lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;da tabela DVD apresentados em ordem decrescente de nome de filme.[ORDER BY]&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot; style=&quot;margin-left:18.0pt;text-indent:17.4pt&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red;mso-ansi-language:EN-US&quot;&gt;Select * from DVD order by nome &lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;desc&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraph&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;g)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização dos &lt;u&gt;nomes&lt;/u&gt; dos DVDs que tem &lt;u&gt;duração&lt;/u&gt; maior que 150 OU são do &lt;u&gt;gênero&lt;/u&gt; drama. [OPERADOR LOGICO]&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot; style=&quot;margin-left:35.4pt&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red;mso-ansi-language:EN-US&quot;&gt;Select nome from DVD where duração &gt; 150 or genero = ‘drama’&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraph&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;h)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização dos campos &lt;u&gt;nome&lt;/u&gt; e &lt;u&gt;estado&lt;/u&gt; na tabela cliente, dos clientes que moram nos &lt;u&gt;estados &lt;/u&gt;começados com a letra “P”.[LIKE]&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot; style=&quot;margin-left:35.4pt&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select nome,estado from cliente where estado&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;like = ‘P%’&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraph&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;i)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;        &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização dos clientes nascidos ente janeiro e abril&lt;/p&gt;  &lt;p class=&quot;MsoNormal&quot; style=&quot;margin-left:35.4pt&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red;mso-ansi-language:EN-US&quot;&gt;Select nome from cliente where month(data_nascimento)&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;between 1 and 4 &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;j)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;        &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva um código para visualização da &lt;u&gt;data_de_locacao&lt;/u&gt; e dos &lt;u&gt;nomes&lt;/u&gt; dos clientes que locaram o filme “Tropa de Elite 2”.[JUNÇÕES]&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;c.nome, cld.data_de_locacao&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;From cliente c, dvd d, cliente_loca_dvd cld&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Where d.nome = ‘Tropa de Elite’ &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red; mso-ansi-language:EN-US&quot;&gt;and c.id = cld.id_cliente&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red; mso-ansi-language:EN-US&quot;&gt;and d.id = cld.id_dvd&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;k)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreve o código para criação de uma view que permita a visualização dos nomes dos clientes do sexo feminino que possuam a menor idade. [SUBCONSULTA]&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red; mso-ansi-language:EN-US&quot;&gt;Create view Nome_Cliente as&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;color:red; mso-ansi-language:EN-US&quot;&gt;Select &lt;span style=&quot;mso-spacerun:yes&quot;&gt; &lt;/span&gt;nome from cliente where sexo = ‘F’ and idade &lt; (select min(idade) from cliente)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span lang=&quot;EN-US&quot; style=&quot;mso-ansi-language: EN-US&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;l)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;        &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreve o código para criação de uma view&lt;span style=&quot;mso-spacerun:yes&quot;&gt;  &lt;/span&gt;que permita a visualização dos nomes do DVDs cujo tempo de duração é acima da média.[SUBCONSULTA].&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Create view Nome_DVDs as&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select nome from DVD where duração &gt; (select avg(duracao) from DVD)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;m)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;    &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva os códigos que permitem a visualização destas views&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Select * from nomedaview&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;text-indent:-18.0pt;mso-list:l0 level1 lfo4&quot;&gt;&lt;span style=&quot;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin&quot;&gt;&lt;span style=&quot;mso-list:Ignore&quot;&gt;n)&lt;span style=&quot;font:7.0pt &amp;quot;Times New Roman&amp;quot;&quot;&gt;      &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Escreva os códigos que permitem a remoção desta view.&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpMiddle&quot;&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/p&gt;  &lt;p class=&quot;MsoListParagraphCxSpLast&quot;&gt;&lt;span style=&quot;color:red&quot;&gt;Drop view Nomedaview&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://rosemberg-lima.blogspot.com/feeds/2827767503774277482/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/10/revisao-banco-de-dados-avancado-fafica.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/2827767503774277482'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/2827767503774277482'/><link rel='alternate' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/10/revisao-banco-de-dados-avancado-fafica.html' title='Revisão - Banco de Dados Avançado (FAFICA)'/><author><name>Rosemberg Bezerra</name><uri>http://www.blogger.com/profile/07763219985104822784</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1703071723259543372.post-1848422009638185226</id><published>2010-04-22T13:32:00.000-07:00</published><updated>2010-04-22T14:10:05.706-07:00</updated><title type='text'>Engenharia de Software</title><content type='html'>Falar um pouco sobre essa disciplina.&lt;br /&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;O que é Engenharia de Software?&lt;/li&gt;&lt;li&gt;Como surgiu?&lt;/li&gt;&lt;li&gt;Quais suas vantagens?&lt;/li&gt;&lt;/ul&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;      A Engenharia de Software consiste em uma engenharia relacionada a todos os aspectos de produção de softwares.&lt;/p&gt;&lt;p&gt;     Surgiu em 1969 quando as empresa de desenvolvimento de software se uniram para discutir uma maneira de desenvolver sistemas sem ter tanto atraso e aumento nos custos prejudicando os seus clientes.&lt;/p&gt;&lt;p&gt;   A vantagem da Engenharia de Software é a forma mais eficiente de desenvolvimento de um software. Sendo assim, melhorando a qualidade e diminuindo o tempo e os custos.&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt; - Existem vários tipos para o Desenvolvimento de um Software.&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;ol&gt;&lt;li&gt;Cascata&lt;/li&gt;&lt;li&gt;Prototipação&lt;/li&gt;&lt;li&gt;Iterativo&lt;/li&gt;&lt;li&gt;Espiral&lt;/li&gt;&lt;/ol&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;Qual o melhor? DEPENDE DO CLIENTE.&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Cascata:&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;Levantamento de Requisitos - Analise de Requisitos - Projeto - Implementação - Teste - Implantação.&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;Levantamento de Requisitos = Principal fase para um desenvolvimento de software, pois colhe os requisitos de uma empresa ( A nessecidade da Empresa).&lt;/p&gt;&lt;p&gt;Análise de Requisitos = Tenta entender essa &quot;necessidade&quot; que a Empresa tem.&lt;/p&gt;&lt;p&gt;Projeto = Desenha a Planta Baixa do Software para ser codificada.&lt;/p&gt;&lt;p&gt;Implementação = Codifica o Software.&lt;/p&gt;&lt;p&gt;Teste = Faz testes no software buscando os problemas na codificação para que esses erros sejam corrigidos antes de ser implantado no cliente.&lt;/p&gt;&lt;p&gt;Implantação = É a parte de instalação/treinamento do sistemas.&lt;/p&gt;&lt;p&gt;O modelo Cascata é mais indicado para Clientes de Pequeno porte, pois é um sistema que corre o risco de sair com o custo maior que o esperado.&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Prototipação&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;A Primeira fase desse moledo é a criação de um protótipo, para que o cliente veja como o sistema irá ser. &lt;/p&gt;&lt;p&gt;LADO POSITIVO&lt;/p&gt;&lt;p&gt;- O Cliente visualiza a construção&lt;/p&gt;&lt;p&gt;- Requisitos Adequados&lt;/p&gt;&lt;p&gt;LADO NEGATIVO&lt;/p&gt;&lt;p&gt;- O Cliente pode pensar que já está pronto o sistema&lt;/p&gt;&lt;p&gt;- Baixo re-uso&lt;/p&gt;&lt;p&gt;- Dificil manutenção&lt;/p&gt;&lt;p&gt;- Risco no Projeto&lt;/p&gt;&lt;p&gt;É indicado para clientes que querem ver como a &quot;cara&quot; do sistema irá ser, pois ele pode querer mudar quando o sistema tiver feito, e assim causando um atraso na entrega.&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Iterativo&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;Utiliza a mesma estrutura do Espiral, porem existe uma ligação direta entre as fases do desenvolvimento.&lt;/p&gt;&lt;p&gt;LADO POSITIVO&lt;/p&gt;&lt;p&gt;- Desenvolvimento Evolutivo&lt;/p&gt;&lt;p&gt;- Projeto Componentizado&lt;/p&gt;&lt;p&gt;LADO NEGATIVO&lt;/p&gt;&lt;p&gt;- Refactoring&lt;/p&gt;&lt;p&gt;- Custo de Mudança&lt;/p&gt;&lt;p&gt;É indicado para empresa que podem mudar alguns requisitos durante o desenvolvimento.&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Espiral&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;Requisitos - Engenharia - Implementação - Avaliação&lt;/p&gt;&lt;p&gt;É um sistema de desenvolvimento que é indicado para altos investimentos, pois tem um baixo risco de erros, pois é desenvolvida por cada requisito e sempre interagindo com a empresa.&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt; &lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://rosemberg-lima.blogspot.com/feeds/1848422009638185226/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/engenharia-de-software.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/1848422009638185226'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/1848422009638185226'/><link rel='alternate' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/engenharia-de-software.html' title='Engenharia de Software'/><author><name>Rosemberg Bezerra</name><uri>http://www.blogger.com/profile/07763219985104822784</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1703071723259543372.post-8177867752384896061</id><published>2010-04-19T05:23:00.000-07:00</published><updated>2020-04-04T05:58:41.745-07:00</updated><title type='text'>Conceito Básico de PILHA</title><content type='html'>- Pilha utiliza o FIFO ( First IN, Fist OUT), ou seja, o ultimo que entrar na pilha será o primeiro a sair.&lt;br /&gt;&lt;br /&gt;Ex:&lt;br /&gt;&lt;br /&gt;* Quando fizemos uma pilha de prato, o ultimo que colocamos se torna o topo e quando for retirado para uso, esse ultimo será o primeiro a sair.&lt;br /&gt;&lt;br /&gt;Para manusear isso, o JAVA contem alguns comandos como o POP, PUSH, PRINT e PEAK.&lt;br /&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Push - Serve para inserir valor na Pilha&lt;/li&gt;&lt;/ul&gt;Ex: Temos aqui uma variável Pilha p e queremos introduzir elementos (a, b, c) à ele:&lt;br /&gt;Então;&lt;br /&gt;p.push(&quot;a&quot;);&lt;br /&gt;p.push(&quot;b&quot;);&lt;br /&gt;p.push(&quot;c&quot;);&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Pop - Serve para retirar o top da pilha&lt;/li&gt;&lt;/ul&gt;Ex: Continuando com a variavel Pilha p contendo os elementos {a, b, c}, vamos agora retirar o topo da pilha , ou seja, o elemento c:&lt;br /&gt;Então;&lt;br /&gt;p.pop();&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Print - Serve para imprimir os elementos da pilha&lt;/li&gt;&lt;/ul&gt;Ex: Efetuando esses comandos em cima, quero saber agora quais elementos então na Pilha p:&lt;br /&gt;Então; &lt;br /&gt;p.print();&lt;br /&gt;//*No console irá aparecer {a,b}&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Peak - Serve para mostrar qual o elemento que está no topo da pilha&lt;/li&gt;&lt;/ul&gt;Ex: E se eu quiser saber o elemento que está no topo da Pilha p:&lt;br /&gt;Entao;&lt;br /&gt;p.peak();&lt;br /&gt;Detalhe: Para declarar uma Pilha, você tem que fazer o seguinte...&lt;br /&gt;Pilha p = new Pilha (TAMANHO);&lt;br /&gt;Isso se chama instanciar, pois ja existe um método.&lt;br /&gt;Pilha = Tipo da variável&lt;br /&gt;p = Variável;&lt;br /&gt;new Pilha = Manipular a Variavel &quot;p&quot; o usando o Método de Pilha criado.&lt;br /&gt;ex:&lt;br /&gt;public class Pilha{&lt;br /&gt;public static void main(String[] args){&lt;br /&gt;Pilha p = new Pilha (10);&lt;br /&gt;__________________________________________________________&lt;br /&gt;Espero ter ajudado.&lt;br /&gt;:D</content><link rel='replies' type='application/atom+xml' href='http://rosemberg-lima.blogspot.com/feeds/8177867752384896061/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/conceito-basico-de-pilha.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/8177867752384896061'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/8177867752384896061'/><link rel='alternate' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/conceito-basico-de-pilha.html' title='Conceito Básico de PILHA'/><author><name>Rosemberg Bezerra</name><uri>http://www.blogger.com/profile/07763219985104822784</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1703071723259543372.post-3400616882323917312</id><published>2010-04-16T13:11:00.000-07:00</published><updated>2010-04-16T13:32:45.415-07:00</updated><title type='text'>Conceito - Banco de Dados</title><content type='html'>Postando aqui alguns Conceitos sobre Banco de Dados.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Esquema&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;- &lt;/strong&gt;Representa as colunas ( Atributos ) em uma tabela de banco de dados.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Instancia&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;- &lt;/strong&gt;Representa as linhas ( Valores ) em uma tabela de banco de dados&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Banco de Dados&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;-  &lt;/strong&gt;É uma coleção de dados armazenados de maneira estruturada, que possuem uma ligação representando algo específico.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;SGBD ( &lt;/strong&gt;&lt;em&gt;Sistema de Gerenciamento de Banco de Dados &lt;strong&gt;)&lt;/strong&gt;&lt;/em&gt;&lt;br /&gt;&lt;strong&gt;&lt;em&gt;&lt;/em&gt;&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;&lt;em&gt;- &lt;/em&gt;&lt;/strong&gt;É uma coleção de programa que serve para criar e manter os bancos.&lt;br /&gt;Ex: Oracle, MySql, Access, FireBird, SqlServer, etc.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Observação&lt;/strong&gt;: Cuidado com a seguinte pergunta: &quot;Qual o melhor banco de dados: Oracle ou Acess?&quot;&lt;br /&gt;&lt;br /&gt;Oracle e Access não são banco de dados, e sim um Sistema de Gerenciamento de Banco de Dados.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Vantagens do SGBD:&lt;/strong&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;&lt;em&gt;Velocidade&lt;/em&gt;&lt;/li&gt;&lt;li&gt;&lt;em&gt;Facilidade de Acesso&lt;/em&gt;&lt;/li&gt;&lt;li&gt;&lt;em&gt;Evita-se inconsistência&lt;/em&gt;&lt;/li&gt;&lt;li&gt;&lt;em&gt;Segurança&lt;/em&gt;&lt;/li&gt;&lt;li&gt;&lt;em&gt;Entre outros.&lt;/em&gt;&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;&lt;em&gt;&lt;/em&gt; &lt;/p&gt;&lt;p&gt;&lt;em&gt;&lt;/em&gt; &lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://rosemberg-lima.blogspot.com/feeds/3400616882323917312/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/conceito-banco-de-dados.html#comment-form' title='0 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/3400616882323917312'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/3400616882323917312'/><link rel='alternate' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/conceito-banco-de-dados.html' title='Conceito - Banco de Dados'/><author><name>Rosemberg Bezerra</name><uri>http://www.blogger.com/profile/07763219985104822784</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1703071723259543372.post-1602535757721000368</id><published>2010-04-16T06:02:00.000-07:00</published><updated>2010-04-16T06:59:37.498-07:00</updated><title type='text'>Dicas para Modelo E-R e Relacional ( Banco de Dados )</title><content type='html'>Bom, já que hoje tem prova de Banco de dados, resolvi postar aqui algumas dicas minha que pode facilitar o entendimento de vocês.&lt;br /&gt;Primeiramente, temos que criar o modelo E-R de acordo com o texto passado. Em seguida é que fazemos o Modelo Relacional.&lt;br /&gt;Aqui vai alguns significados:&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Entidade Forte&lt;/strong&gt;: É uma entidade que possui um &lt;strong&gt;Atributo&lt;/strong&gt; &lt;strong&gt;Chave&lt;/strong&gt;.&lt;br /&gt;Representação: RENTANGULO.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Entidade Fraca&lt;/strong&gt;:&lt;strong&gt; &lt;/strong&gt;É uma entidade que não possui um Atributo Chave. É composta apenas por um &lt;strong&gt;Atributo Parcial&lt;/strong&gt;.&lt;br /&gt;Representação: DUPLO RENTANGULO.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Atributo Chave&lt;/strong&gt;: É um atributo, cujo seu valor será único para cada cadastro.&lt;br /&gt;Representação: ELIPSE SUBLINHADA.&lt;br /&gt;Ex: CPF, Código, Matricula, CNPJ, etc.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Atributo Chave Parcial&lt;/strong&gt;: É um atributo que não é tão único em uma entidade, tendo uma possibilidade de ter valor repetitivo nos cadastro. Para identificá-lo terá que existir um bom-senso.&lt;br /&gt;Representação: ELIPSE SUBLINHADA (PONTILHADO)&lt;br /&gt;Ex: Nome, Data_Nascimento, etc.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Atributo Monovalorado&lt;/strong&gt;: É um atributo simples, será atribuido um único valor.&lt;br /&gt;Representação: ELIPSE.&lt;br /&gt;Ex: Nome, Sexo, Idade, etc.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Atributo Multivalorado&lt;/strong&gt;: É um atributo que irá conter mais de um valor cadastrado.&lt;br /&gt;Representação: DUPLA ELIPSE.&lt;br /&gt;Ex: Emails, Fones, etc.&lt;br /&gt;&lt;strong&gt;&lt;/strong&gt;&lt;br /&gt;&lt;strong&gt;Atributo Determinante: &lt;/strong&gt;É um atributo que irá definir o valor de outro atributo.&lt;br /&gt;Representação: ELIPSE.&lt;br /&gt;Ex: Data_Nascimento, Data_Construção, etc.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Atributo Derivado&lt;/strong&gt;: É um atributo pré-determinado.&lt;br /&gt;Representação: ELIPSE PONTILHADA.&lt;br /&gt;Ex: Idade, Tempo_de_Obra, etc.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Atributo Composto&lt;/strong&gt;: É um atributo que liga outros atributos que contém o mesmo conteúdo, criando um único atributo.&lt;br /&gt;Representação: ELIPSE LIGANDO OUTRAS ELIPSES.&lt;br /&gt;Ex: Endereço ( Cidade, CEP, Bairro ), Nome (Primeiro_Nome, Ultimo_Nome), etc.&lt;br /&gt;&lt;br /&gt;Infelizmente eu não tive essa idéia antes, de criar um blog para colocar algumas explicações dos assuntos que poderiam cair nas provas. Mas vou começar a fazer isso. Segunda - feira irá ter prova de Estrutura de Dados. Brevemente aqui vai estar algo sobre pilha.&lt;br /&gt;&lt;br /&gt;&lt;p&gt;&lt;/p&gt;&lt;p&gt;Mais tarde terá algo sobre o resto do &lt;strong&gt;Modelo E-R&lt;/strong&gt; e as Regras do &lt;strong&gt;Modelo Relacional&lt;/strong&gt;.&lt;/p&gt;Aqui agora um exemplo simples.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;a href=&quot;http://2.bp.blogspot.com/_wqrEzUVRy9E/S8hqWk35aWI/AAAAAAAAADU/Eh_S5ZurEIk/s1600/TESTE.png&quot;&gt;&lt;img style=&quot;WIDTH: 402px; HEIGHT: 156px; CURSOR: hand&quot; id=&quot;BLOGGER_PHOTO_ID_5460731484274518370&quot; border=&quot;0&quot; alt=&quot;&quot; src=&quot;http://2.bp.blogspot.com/_wqrEzUVRy9E/S8hqWk35aWI/AAAAAAAAADU/Eh_S5ZurEIk/s320/TESTE.png&quot; /&gt;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://rosemberg-lima.blogspot.com/feeds/1602535757721000368/comments/default' title='Postar comentários'/><link rel='replies' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/dicas-para-modelo-e-r-e-relacional.html#comment-form' title='1 Comentários'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/1602535757721000368'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1703071723259543372/posts/default/1602535757721000368'/><link rel='alternate' type='text/html' href='http://rosemberg-lima.blogspot.com/2010/04/dicas-para-modelo-e-r-e-relacional.html' title='Dicas para Modelo E-R e Relacional ( Banco de Dados )'/><author><name>Rosemberg Bezerra</name><uri>http://www.blogger.com/profile/07763219985104822784</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://2.bp.blogspot.com/_wqrEzUVRy9E/S8hqWk35aWI/AAAAAAAAADU/Eh_S5ZurEIk/s72-c/TESTE.png" height="72" width="72"/><thr:total>1</thr:total></entry></feed>