dbm 380 aid teaching effectively dbm380aiddotcom
TRANSCRIPT
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
1/21
BM 380 AI Teaching Effictel
y /dbm380aiddotcom
FOR MORE CLASSES VISIT
www.dbm380aid.com
http://www.dbm380aid.com/http://www.dbm380aid.com/
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
2/21
BM 380 Entire Course !e
"#
• DBM 380 $ee% & Indi'idual Assignment DataBase (a)er !e"# DBM 380 $ee% & D* & !e"# DBM 380 $ee% & D* + !e"# DBM 380$ee% + Team Assignment ,er'ice -e.uest ,-/ht/003 Change -e.uest + !e"# DBM 380 $ee% + Indi'idual Assignment Database En'ironment (a)er !e"# DBM 380 $ee% + D* & !e"# DBM 380 $ee% +D* + !e"# DBM 380 $ee% 3 Team Assignment ,er'ice -e.uest ,-/ht/003 Change -e.uest 3 !e"# DBM 380 $ee% 3 Indi'idual Assignment E-D Creation (roect !e"# DBM 380 $ee% 3 D* & !e"#
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
3/21
DBM 380 $ee% & D* & !e"#
• -eflect on the te1tboo% readings2 sing the search strings listed inthe Electronic -eser'e -eadings for $ee% one search for additionalinformation on database systems2 $hat information "ould
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
4/21
DBM 380 $ee% & D* + !e"#
• $hat limitations ha'e you or someone you %no" encountered in the )ast in using nonrelational structures such as in a Microsoft4 E1cel4 or $ord file# to store data5 $hat "ere the ad'antages5
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
5/21
BM 380 $ee% + * & !e"#
• Thin% of a situation "here null 'alue should be allo"ed and a situation "here it should not be allo"ed2 $hat are the conse.uences ofina))ro)riate null settings5
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
6/21
BM 380 $ee% + * + !e"#
• $hy it is necessary to choose a))ro)riate data ty)es for each datacolumn5
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
7/21
BM 380 $ee% + Indi'idual Assignment atab
ase En'ironment (a)er !e"#
• $rite a 670/ to &070/"ord )a)er in "hich you com)lete the follo"ing9 Choose a database en'ironment from the follo"ing9 An a))ro)riate database en'ironment "ithin your "or%)lace must be a))ro'ed by your instructor# An Art Museum that needs to trac% the art"or% artists and locations "here the art is dis)layed or stored "ithin the museum ,mith Consulting :irtual ;rganis s%ill sets and "hat )roects they are "or%ing on Analy
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
8/21
DBM 380 $ee% + Team Assignment ,er'ice -e.uest ,-/ht/003 Change -e.uest + !e"#
• Begin "or%ing on ,er'ice -e.uest ,-/ht/003 due in $ee% @i'e by com)leting Change -e.uest +2 Create documentation for this )roect that summari
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
9/21
DBM 380 $ee% 3 D* & !e"#
• A motor 'ehicle maintenance center "ants to im)ro'e its ser'icesby using database management systems DBM,# and data mining2$hat tables are needed in such a database and ho" can it hel) im)ro'e their ser'ices5
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
10/21
DBM 380 $ee% 3 D* + !e"#
• o" do you select the )rimary %ey from the candidate %eys5 o"do foreign %eys relate to candidate %eys5 (ro'ide e1am)les from either your "or%)lace or class assignments2
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
11/21
DBM 380 $ee% 3 Indi'idual Assignment E-D Creation (roect !e"#
• The follo"ing assignment is based on the database en'ironment chosen and discussed in the $ee% T"o Indi'idual Assignment2 sea Microsoft4 :isio4 diagram to create a detailed E-D using the data s)ecificationsnoted in the $ee% T"o Indi'idual Assignment2 Ma%e any necessary changes )ro'ided in your faculty>s feedbac%2 se aMicrosoft4 Access4 database to create the )reliminary database tables columns "ith data ty)es )rimary %eys and relationshi)s2
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
12/21
DBM 380 $ee% 3 Team Assignment ,er'ice -e.uest ,-/ht/003 Change -e.uest 3 !e"#
• Continue "or%ing on ,er'ice -e.uest ,-/ht/003 due in $ee% @i'eby com)leting Change -e.uest 32 Create documentation that e1)lains the )rocess of creating the entity/relationshi) diagrams in the change re.uest relati'e to this )roect2 @ormat your )a)er consistent "ith A(A guidelines2 ,ubmit a draft of your team>s documentation
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
13/21
BM 380 $ee% * & !e"#
• In your o"n "ords describe the nature and )ur)ose of the normali
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
14/21
BM 380 $ee% * + !e"#
• In "hat business database en'ironments is denormali
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
15/21
BM 380 $ee% Indi'idual Assignment !orm
ali
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
16/21
DBM 380 $ee% Team Assignment ,-/ht/003 Change -e.uest and 7 !e"#
• Continue "or%ing on ,er'ice -e.uest ,-/ht/003 due in $ee% @i'eby com)leting Change -e.uests and 72 Create documentation describing the )rinci)les and im)ortance of normali
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
17/21
DBM 380 $ee% 7 D* & !e"#
• Describe the ad'antages and disad'antages of DBM,/)ro'ided security2 Com)are it to net"or% or a))lication security2
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
18/21
DBM 380 $ee% 7 D* +!e"#
• ?ocate a hosted distributed database ser'ice2 E1)lore its featuresand tal% about your e1)eriences2 In "hat situations "ould an organi
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
19/21
DBM $ee 7 Team ss gnment ,er'ice -e.uest ,-/ht/003
!e"#• @inali
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
20/21
DBM 380 $ee% 7 Team Assignment ,er'ice -e.uest ,-/ht/003 (resentation !e"#
• Create a 3/ to 7/slide Microsoft4 (o"er(oint4 )resentation in "hich you e1)lain ho" the )rinci)les of database management and your recommendations "ere a))lie
d to the )roect2 ,ubmit your team )resentation to yourfacilitator2
-
8/18/2019 DBM 380 AID Teaching Effectively dbm380aiddotcom
21/21
BM 380 AI Teaching Efficte
ly /dbm380aiddotcomFOR MORE CLASSES VISIT
www.dbm380aid.com
http://www.dbm380aid.com/http://www.dbm380aid.com/