Buscar

ABS 2 - Conceitos de variáveis e de dados primários e secundários Construção de bancos de dados

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Você também pode ser Premium ajudando estudantes

Faça como milhares de estudantes: teste grátis o Passei Direto

Esse e outros conteúdos desbloqueados

16 milhões de materiais de várias disciplinas

Impressão de materiais

Agora você pode testar o

Passei Direto grátis

Você também pode ser Premium ajudando estudantes

Prévia do material em texto

WƌŽĨ͘�<ĂůůŝŶĞ�ĚĞ��ůŵĞŝĚĂ��ĂƌƌĞƚŽ
�ĂĚŽƐ�ĞƉŝĚĞŵŝŽůſŐŝĐŽƐ
^ĆŽ�ƉƌŽĚƵnjŝĚŽƐ�ƉĂƌĂ�ĚĞƐĐƌĞǀĞƌ͕�ĂĐŽŵƉĂŶŚĂƌ�Ğ�ĐŽŵƉĂƌĂƌ�ĐĂƌĂĐƚĞƌşƐƚŝĐĂƐ�ĚĞ�ƉŽƉƵůĂĕƁĞƐ͕�
ŐƌƵƉŽƐ�ĚĞ�ŝŶĚŝǀşĚƵŽƐ�ĞƚĐ͘
�
�ŽŵƉĂƌĂƌ�ƚĂŵďĠŵ�ŽĐŽƌƌġŶĐŝĂ�Ğ�ĚŝƐƚƌŝďƵŝĕĆŽ�ĚŽƐ�ĞǀĞŶƚŽƐ�ĚĞ�ƐĂƷĚĞ�
WŽĚĞŵ�ƐĞƌ�ĐŽŶƚĂŐĞŶƐ�ŽƵ�ƋƵĂŶƚŝĚĂĚĞƐ�;ĨƌĞƋƵġŶĐŝĂƐͿ�
K�ƋƵĞ�ƐĆŽ�ǀĂƌŝĄǀĞŝƐ͍
�ĂĚŽƐ͗�ƋƵĂůƋƵĞƌ�ŝŶĨŽƌŵĂĕĆŽ�ĐŽůĞƚĂĚĂ�Ğ�ƌĞŐŝƐƚƌĂĚĂ�ĚĞ�ƵŵĂ�ǀĂƌŝĄǀĞů�
sĂƌŝĄǀĞŝƐ͗�ĐŽŶĚŝĕĆŽ�ŽƵ�ĐĂƌĂĐƚĞƌşƐƚŝĐĂ�ĚĞ�ƵŵĂ�ƵŶŝĚĂĚĞ�ĚĂ�ƉŽƉƵůĂĕĆŽ�
�ĂĚŽƐ�Ğ�ǀĂƌŝĄǀĞŝƐ
�ŽŵŽ�ƵŶŝĚĂĚĞ�ĚĞ�ĂŶĄůŝƐĞ�ĚŽ�ĚĂĚŽ�ĞŶƚĞŶĚĂͲƐĞ�Ž�ŽďũĞƚŽ�ĚĂ�ĚĞƐĐƌŝĕĆŽ͕�ĐůĂƐƐŝĨŝĐĂĕĆŽ͕�
ĞŶƵŵĞƌĂĕĆŽ�ŽƵ�ŵĞĚŝĚĂ͘�/ƐƚŽ�Ġ͕�Ž�ƋƵĞ�ŽƵ�ƋƵĞŵ�ƐĞ�ƉƌĞƚĞŶĚĞ�ĚĞƐĐƌĞǀĞƌ͕�ĐůĂƐƐŝĨŝĐĂƌ͕�
ĐŽŶƚĂƌ�ŽƵ�ŵĞĚŝƌ͘��dž͘�ϭϮϬŬŐ
�
��ǀĂƌŝĄǀĞů�ŽƵ�ĚŝŵĞŶƐĆŽ�ĐŽŶƐƚŝƚƵŝ�Ž�ĞůĞŵĞŶƚŽ�ĚŽ�ĚĂĚŽ�ƋƵĞ�ƋƵĂůŝĨŝĐĂ�Ğ�ĞƐƉĞĐŝĨŝĐĂ�Ž�
ŽďũĞƚŽ�ĚĂ�ĐŽŶƚĂŐĞŵ�;Ă�ƵŶŝĚĂĚĞ�ĚĞ�ĂŶĄůŝƐĞͿ͘��ƋƵŝ�ƐĞ�ĚĞĨŝŶĞŵ�ĂƚƌŝďƵƚŽƐ�Ğ�ĐĂƌĂĐƚĞƌşƐƚŝĐĂƐ�
ĚŽ�ƋƵĞ�ƐĞ�ƉƌĞƚĞŶĚĞ�ĚĞƐĐƌĞǀĞƌ͕�ĐůĂƐƐŝĨŝĐĂƌ͕�ƋƵĂŶƚŝĨŝĐĂƌ�ŽƵ�ŵĞĚŝƌ͘��dž͘�/D�
�
/ŶĨŽƌŵĂĕĆŽ
ZĞĨŝŶĂŵĞŶƚŽ�ĚŽƐ�ĚĂĚŽƐ�
K�ƋƵĞ�ƐĞ�ƉƌĞƚĞŶĚĞ͕�ƉŽƌ�ĞdžĞŵƉůŽ͕�ĂŽ�ƌĞĂůŝnjĂƌ�Ž�ƌĞŐŝƐƚƌŽ�ĚĞ�ƚŽĚŽƐ�ŽƐ�ĐĂƐŽƐ�ĚĞ�ƵŵĂ�
ĚŽĞŶĕĂ�ĂƚĞŶĚŝĚŽƐ�Ğŵ�Ƶŵ�ƐĞƌǀŝĕŽ�ĚĞ�ƐĂƷĚĞ�ŽƵ�ŝĚĞŶƚŝĨŝĐĂĚŽƐ�ƉŽƌ�Ƶŵ�ŝŶƋƵĠƌŝƚŽ�
ĚŽŵŝĐŝůŝĂƌ�Ġ�ƉŽĚĞƌ�ĂƉůŝĐĂƌ�Ž�ĚĂĚŽ�ĂƉƵƌĂĚŽ Ͳ Ž�ŶƷŵĞƌŽ�ĚĞ�ĐĂƐŽƐ�Ͳ ĂŽ�ĐŽŶŚĞĐŝŵĞŶƚŽ Ğ�
ĞŶƚĞŶĚŝŵĞŶƚŽ�ĚĂ�ŽĐŽƌƌġŶĐŝĂ�ĚŽ�ƉƌŽďůĞŵĂ�ĚĞ�ƐĂƷĚĞ�ŶĂ�ƉŽƉƵůĂĕĆŽ͖
�
�ƚĞŶƚĂƌͲƐĞ�ă�ƋƵĂůŝĚĂĚĞ�ŵĞƚŽĚŽůſŐŝĐĂ�ĚĞƐƐĂ�ŝŶĨŽƌŵĂĕĆŽ�
sĂƌŝĄǀĞŝƐ�ƋƵĂůŝƚĂƚŝǀĂƐ�ŽƵ�ĐĂƚĞŐſƌŝĐĂƐ
^Ğ�ǀŽĐġ�ƉĞƌŐƵŶƚĂƌ�Ă�ĂůŐƵĠŵ�ƐĞ�ƚĞǀĞ�ĚĞŶŐƵĞ͕�Ă�ƌĞƐƉŽƐƚĂ�Ġ�Ɛŝŵ�ŽƵ�ŶĆŽ�;ĞŶƚĆŽ�Ă�ǀĂƌŝĄǀĞů�
ŶĆŽ�Ġ�ƋƵĂŶƚŝƚĂƚŝǀĂ͕�ƉŽŝƐ�ŶĆŽ�Ġ�Ƶŵ�ŶƷŵĞƌŽͿ͖�Ă�ŝŶĨŽƌŵĂĕĆŽ ƋƵĞ�ǀŽĐġ�ǀĂŝ�ŐĞƌĂƌ�ĚĞƐƐĂ�
ǀĂƌŝĄǀĞůͬĚĂĚŽ�Ġ�ƋƵĞ�ǀĂŝ�ƐĞƌ�ƋƵĂŶƚŝƚĂƚŝǀĂ͕�ƉŽƌƋƵĞ�Ăş�ǀŽĐġ�ǀĂŝ�ǀĞƌ�ƋƵĂŶƚŽƐ�ƚġŵ�ĚĞŶŐƵĞ�
ŽƵ�ŶĆŽ͘�/ƐƐŽ�ƐĞ�ĐŚĂŵĂ�ĨƌĞƋƵġŶĐŝĂ͘���ƵŵĂ�ĂŶĄůŝƐĞ͘�
�
YƵĂůŝƚĂƚŝǀĂƐ͗�ĞdžƉƌĞƐƐĂŵ�ƵŵĂ�ĐĂƌĂĐƚĞƌşƐƚŝĐĂ�ŶĆŽ�ŵĞŶƐƵƌĄǀĞů�Ğŵ�ŶƷŵĞƌŽƐ
EŽŵŝŶĂŝƐ͗�ĐĂƚĞŐŽƌŝĂƐ�ĞdžĐůƵƐŝǀĂƐ�ƐĞŵ�ŽƌĚĞŵż
KƌĚŝŶĂŝƐ͗�ĐĂƚĞŐŽƌŝĂƐ�ĞdžĐůƵƐŝǀĂƐ�ĐŽŵ ŽƌĚĞŵż
�
�ŽŶĐĞŝƚŽƐ�ĚĞ�ǀĂƌŝĄǀĞŝƐ�Ğ�ĚĞ�ĚĂĚŽƐ�ƉƌŝŵĄƌŝŽƐ�Ğ�
ƐĞĐƵŶĚĄƌŝŽƐ͘��ŽŶƐƚƌƵĕĆŽ�ĚĞ�ďĂŶĐŽƐ�ĚĞ�ĚĂĚŽƐ
ƐĄďĂĚŽ͕�ϭϱ�ĚĞ�ũĂŶĞŝƌŽ�ĚĞ�ϮϬϮϮ Ϯϭ͗Ϯϯ
sĂƌŝĄǀĞŝƐ�ƋƵĂŶƚŝƚĂƚŝǀĂƐ�ŽƵ�ŶƵŵĠƌŝĐĂƐ
�ŝƐĐƌĞƚĂƐ͗�ŶƷŵĞƌŽƐ�ŝŶƚĞŝƌŽƐ�;Ğdž͘�ŶƷŵĞƌŽ�ĚĞ�ĨŝůŚŽƐ͕�ƋƚĚ�ĚĞ�ſďŝƚŽƐͿ�
�ŽŶƚşŶƵĂƐ͗�ŶƷŵĞƌŽƐ�ĨƌĂĐŝŽŶĂĚŽƐ�;Ğdž͘�ƉĞƐŽ͕�ĂůƚƵƌĂͿ�
&ŽŶƚĞƐ�ĚĞ�ĚĂĚŽƐ
&ŽŶƚĞƐ�ƉƌŝŵĄƌŝĂƐ͗�ĚĞƐƚĂĐĂŵͲƐĞ�ŽƐ�ƉƌſƉƌŝŽƐ�ŝŶĚŝǀşĚƵŽƐ�ƉĂƌƚŝĐŝƉĂŶƚĞƐ�ĚĂƐ�ŝŶǀĞƐƚŝŐĂĕƁĞƐ�
ƋƵĞ�ƐĆŽ�ĞdžĂŵŝŶĂĚŽƐ�ŽƵ�ĞŶƚƌĞǀŝƐƚĂĚŽƐ͕�ĐŽŵŽ�Ġ�Ž�ĐĂƐŽ�ĚŽƐ�ŝŶƋƵĠƌŝƚŽƐ�Ğ�ĚŽƐ�ĞƐƚƵĚŽƐ�
ŽďƐĞƌǀĂĐŝŽŶĂŝƐ�Ğŵ�ĞƉŝĚĞŵŝŽůŽŐŝĂ
�
&ŽŶƚĞƐ�ƐĞĐƵŶĚĄƌŝĂƐ͗�ƌĞŐŝƐƚƌŽ�ƐŝƐƚĞŵĄƚŝĐŽ�ĚĂƐ�ĂƚŝǀŝĚĂĚĞƐ�ĚĞ�ƉƌŽĨŝƐƐŝŽŶĂŝƐ�ĚĞ�ƐĂƷĚĞ�Ğŵ�
ƐĞƌǀŝĕŽƐ�ĚŝǀĞƌƐŽƐ�Ğ�ƋƵĂŶĚŽ�ĚĂ�ĐŽŶĚƵĕĆŽ�ĚĞ�ĂĕƁĞƐ�Ğ�ŝŶƚĞƌǀĞŶĕƁĞƐ�ĐŽŶƐƚŝƚƵĞŵ�ĨŽŶƚĞƐ�
ĞƐƉĞĐŝĂŝƐ�ĚĞ�ĚĂĚŽƐ͕�ĐŽŵŽ�ŶŽ�ĐĂƐŽ�ĚŽƐ�ĚĂĚŽƐ�ĚĞ�ƌĞŐŝƐƚƌŽ�ĐŽŶƚşŶƵŽ�Ğŵ�ƐĂƷĚĞ�ƋƵĞ�
ĂůŝŵĞŶƚĂŵ�ƐŝƐƚĞŵĂƐ�ĚĞ�ŝŶĨŽƌŵĂĕĆŽ
�
�ĂƌĂĐƚĞƌŝnjĂĕĆŽ
�ĂĚŽ�ƉƌŝŵĄƌŝŽ͗�ƐĆŽ�ĂƋƵĞůĞƐ�ŽďƚŝĚŽƐ�ĚŝƌĞƚĂŵĞŶƚĞ�ƉŽƌ�ƋƵĞŵ�ĨŽƌŵƵůŽƵ�Ğ�ĞƐĐŽůŚĞƵ�ŽƐ�
ŵĠƚŽĚŽƐ͕�ƉůĂŶĞũŽƵ�Ă�ĐŽůĞƚĂ�ĞͬŽƵ�ƉĂƌƚŝĐŝƉĂƌĄ�ĚĂ�ƐƵĂ�ĂŶĄůŝƐĞ�Ͳ ŽƐ�ƉĞƐƋƵŝƐĂĚŽƌĞƐ
�
�ĂĚŽ�ƐĞĐƵŶĚĄƌŝŽ͗�ĂƋƵĞůĞ�ĐŽůĞƚĂĚŽ�ƉŽƌ�ŽƵƚƌŽƐ�ƉĞƐƋƵŝƐĂĚŽƌĞƐ�Ğ�ƋƵĞ�ĞƐƚĄ�ă�ĚŝƐƉŽƐŝĕĆŽ�
ƉĂƌĂ�ƵƚŝůŝnjĂĕĆŽ�ƉŽƌ�ŽƵƚƌŽƐ�ĞƐƚƵĚŽƐ�ĞƉŝĚĞŵŝŽůſŐŝĐŽƐ
�
�ĂĚŽƐ
�ĂĚŽƐ�ĚĞ�ƌĞŐŝƐƚƌŽ�ĐŽŶƚşŶƵŽ�Ͳ ſƌŐĆŽƐ�ĚŽ�ŐŽǀĞƌŶŽ
^/Dż
^/E�^�ż
^/E�Eż
/�'�ż
�
�ĂĚŽƐ�ĚĞ�ƌĞŐŝƐƚƌŽ�ƉĞƌŝſĚŝĐŽ
WĞƐƋƵŝƐĂƐ�ĂŵŽƐƚƌĂŝƐ͕�ĐŽŵŽ�ŽƐ�ŝŶƋƵĠƌŝƚŽƐ�ĚŽŵŝĐŝůŝĂƌĞƐ�ƐŽďƌĞ�ƐŝƚƵĂĕĆŽ�ĚĞ�ƐĂƷĚĞ�ŽƵ�
ŶŽƐ�ůĞǀĂŶƚĂŵĞŶƚŽƐ�ƋƵĞ�ĐŽďƌĞŵ�ƚŽĚŽ�Ž�ƵŶŝǀĞƌƐŽ�ƉŽƉƵůĂĐŝŽŶĂů͕�ĐŽŵŽ�ŽƐ�ĐĞŶƐŽƐ�
ĚĞŵŽŐƌĄĨŝĐŽƐ
ż
�
�ŶĄůŝƐĞ�ĚĞ�ĚĂĚŽƐ
�ĂƐĞŝĂͲƐĞ�Ğŵ�ƌĞƐƵůƚĂĚŽƐ�ĐŽůĞƚŝǀŽƐ�ĚĞ�ĂŵŽƐƚƌĂƐ�
'ĞƌĂ�ŽƐ�ƌĞƐƵůƚĂĚŽƐ͕�ƋƵĞ�ƉŽĚĞŵ�ƐĞƌ�ŵĞĚŝĚŽƐ�Ğŵ͗
&ƌĞƋƵġŶĐŝĂƐ�;Ğdž͘�ϯϮ�ŚŽŵĞŶƐ�Ğ�ϯϱ�ŵƵůŚĞƌĞƐͿż
DĞĚŝĚĂƐ�ĚĞ�ƚĞŶĚġŶĐŝĂ�ĐĞŶƚƌĂů�;Ğdž͘�ŵĠĚŝĂ͕�ŵŽĚĂ�Ğ�ŵĞĚŝĂŶĂͿż
�
�ĂŶĐŽ�ĚĞ�ĚĂĚŽƐ
^ĆŽ�ŽƐ�ůŽĐĂŝƐ�ŽŶĚĞ�ƐĞ�ĂƌŵĂnjĞŶĂŵ�ƚŽĚŽƐ�ŽƐ�ĚĂĚŽƐ�ĚĂƐ�ǀĂƌŝĄǀĞŝƐ�ĐŽůĞƚĂĚĂƐ�
�Ɛ�ĨƵŶĕƁĞƐ�ƉĂƌĂ�ďĂŶĐŽ�ĚĞ�ĚĂĚŽƐ�ĨŽƌĂŵ�ĐƌŝĂĚĂƐ�ƉĂƌĂ�ĚĂƌ�ŵĞůŚŽƌ�ƉƌŽĐĞƐƐĂŵĞŶƚŽ�ĚĞ�
ĨƵŶĕƁĞƐ�Ğŵ�ƚƌĂďĂůŚŽ�ĐŽŵ�ďĂƐĞƐ�ŵƵŝƚŽ�ŐƌĂŶĚĞƐ
�
�ůĞƐ�ƉŽĚĞŵ�ƐĞƌ�ŵŽĚŝĨŝĐĄǀĞŝƐ�Ğ�ĂũƵƐƚĂĚŽƐ�ƉŽƌ�ƋƵĞŵ�ĂŶĂůŝƐĂ�
�ƉſƐ�ŽƐ�ĂũƵƐƚĞƐ͕�ƐĞƌĆŽ�ƌĞĂůŝnjĂĚĂƐ�ĂƐ�ĂŶĄůŝƐĞƐ�ĚŽƐ�ĚĂĚŽƐ͕�ĚĞ�ĂĐŽƌĚŽ�ĐŽŵ�Ž�ƋƵĞ�ƐĞ�ĚĞƐĞũĂ�
ŽďƚĞƌ
�
�ƌŝĂŶĚŽ�Ƶŵ�ďĂŶĐŽ�ĚĞ�ĚĂĚŽƐ
WŽĚĞ�ƐĞƌ�ĐƌŝĂĚŽ�Ğŵ�ƋƵĂůƋƵĞƌ�ƉůĂŶŝůŚĂ�ĞůĞƚƌƀŶŝĐĂ͗��džĐĞů͕�^^W^͖
�ĞƐǀĂŶƚĂŐĞŵ͗�ĨĂĐŝůŵĞŶƚĞ�ĞĚŝƚĄǀĞů͕�Ž�ƋƵĞ�ƉŽĚĞ�ĐŽŵƉƌŽŵĞƚĞƌ�Ă�ƋƵĂůŝĚĂĚĞ�ĚŽƐ�
ĚĂĚŽƐ
ż
�
WŽĚĞͲƐĞ�ƵƚŝůŝnjĂƌ�ŵĄƐĐĂƌĂƐ�ƉĂƌĂ�Ă�ĞŶƚƌĂĚĂ�ĚĞ�ĚĂĚŽƐ�ƋƵĞ�ƉŽĚĞŵ�ƐĞƌ�ĐŽŶƐƚƌƵşĚĂƐ͖
�Ɖŝ/ŶĨŽ͕�ƋƵĞ�ƉŽĚĞ�ƐĞƌ�ŽďƚŝĚŽ�ŐƌĂƚƵŝƚĂŵĞŶƚĞ�ŶŽ�ƐŝƚĞ�ĚŽ����ż
^W^^�ĚĂƚĂ�ĞŶƚƌLJż
�
�Ž�ĐƌŝĂƌ�Ƶŵ�ďĂŶĐŽ͕�ůĞŵďƌĂƌ͗
�ŽůŽĐĂƌ�Ž�ŶŽŵĞ�ĚĞ�ĐĂĚĂ�ǀĂƌŝĄǀĞů�ŶĂ�ƉƌŝŵĞŝƌĂ�ůŝŶŚĂ�ĚĂ�ƉůĂŶŝůŚĂ�
�ĂĚĂ�ůŝŶŚĂ�ƌĞƉƌĞƐĞŶƚĂ�Ƶŵ�ƐƵũĞŝƚŽ�
�ĂĚĂ�ĐŽůƵŶĂ�Ġ�ƵŵĂ�ǀĂƌŝĄǀĞů�
�ĂĚĂ�ǀĂƌŝĄǀĞů�Ɛſ�ƉŽĚĞ�ĂƉĂƌĞĐĞƌ�ƵŵĂ�ǀĞnj�ŶŽ�ďĂŶĐŽ�
�ĂĚŽƐ�ƉĞƌĚŝĚŽƐ�;ŵŝƐƐŝŶŐͿ͗�Ġ�ŵĂŝƐ�ĨĄĐŝů�ĚĞŝdžĂƌ�Ă�ĐĂƐĞůĂ�ǀĂnjŝĂ�
EĆŽ�ĐŽůŽĐĂƌ�ůĞƚƌĂƐ�Ğŵ�ŶĞŶŚƵŵĂ�ŚŝƉſƚĞƐĞ�;ĐƌŝĂƌ�ĚŝĐŝŽŶĄƌŝŽͿ�
��ǀĂƌŝĄǀĞů�ƚĞƐƚĞͬĐŽŶƚƌŽůĞ�Ġ�ƵŵĂ�ǀĂƌŝĄǀĞů�
�ŵ�ĐĂƐŽ�ĚĞ�ĚĂĚŽƐ�ůŽŶŐŝƚƵĚŝŶĂŝƐ͕�ĐƌŝĂƌ�ǀĂƌŝĄǀĞů�ƚĞŵƉŽ�Ğ�ĐĂĚĂ�ŶŽǀĂ�ŵĞĚŝĚĂ�Ġ�Ƶŵ�ŶŽǀŽ�
ĐĂƐŽ�;ůŝŶŚĂͿ
�
dŽĚŽ�Ž�ďĂŶĐŽ�ĚĞǀĞ�ĞƐƚĂƌ�Ğŵ�ƵŵĂ�Ɛſ�ƉůĂŶŝůŚĂ�
�Ɖŝ/ŶĨŽ
��Ƶŵ�ƉĂĐŽƚĞ�ĚĞ�ĨĞƌƌĂŵĞŶƚĂƐ�ƉĂƌĂ�ĞůĂďŽƌĂĕĆŽ�ĚĞ�ďĂƐĞƐ�ĚĞ�ĚĂĚŽƐ�Ğ�ĨŽƌŵƵůĄƌŝŽƐ�ĚĞ�
ĞŶƚƌĂĚĂ�ĚĞ�ĚĂĚŽƐ͕�ĐŽŵ�ĂŶĄůŝƐĞ�ĚĞ�ĞƐƚĂƚşƐƚŝĐĂƐ͕�ŐƌĄĨŝĐŽƐ�Ğ�ŵĂƉĂƐ�ĞƉŝĚĞŵŝŽůſŐŝĐŽƐ�ƉĂƌĂ�
ƉƌŽĨŝƐƐŝŽŶĂŝƐ�ĚĂ�ƐĂƷĚĞ�ƉƷďůŝĐĂ�ƋƵĞ�ŶĆŽ�ƉŽƐƐƵĂŵ�ĐŽŶŚĞĐŝŵĞŶƚŽƐ�ĚĞ�ƚĞĐŶŽůŽŐŝĂƐ�ĚĂ�
ŝŶĨŽƌŵĂĕĆŽ
�

Continue navegando