MIS 310 - Syllabus 2 - Lecture notes 1 PDF

Preview

Summary

lecture 1...

Description

MI S31 0:Dat aba s eManagementSys t e ms( Spr i ng2 017 ) Cour s e Name :Da t a bas eMana ge me ntS ys t e ms( MI S310) Me e t i ngPl ac e :David King Jr. Hall 2053 Me e t i ngTi me :Mon7: 20pm t o10: 00pm We bs i t e : / /mymas on. gmu. e du Pr e r e qui s i t e :MI S301

I ns t r uc t or Pr of e s s or :J oydi pBa ner j ee Phone :( 202)6895993 bane r j e @gmu. e du Emai l :j Offic eHour :Byappoi nt me nt

Cour s eMa t e r i al s a . Pr i mar yTe xt book: Da t aba s eConc ept s7t hEdi t i on, byKr oe nkea ndAue r , Pr e nt i c eHal l ,I SBN10 :01 327 429 26, I SBN1 3:9 780 13 2 742 924 . b .Re qui r e dSof t wa r e : Mi c r os of tAc c e s s2 010a ndMi c r os of tVi s i o Pr of es s i onal201 0a r er e qui r e df ort hi sc our s e .The s es of t wa r ea r ea va i l a bl e f orf r e edownl oadandi ns t al l a t i ononyourpe r s onalc omput e r st hr ought he Mi c r os of tDe ve l ope rNe t wor kAc a de mi cAl l i anc e( MSDNAA) .I ns t r uc t i ons onhow t odownl oa dt hes of t wa r ewi l lbepos t e donBl ac kboar dors e ntby e mai l . Not et ha tt he r ea r enoMacve r s i onsoft hes of t wa r e .I ti syour r e s pons i bi l i t yt oma kes ur eyouras s i gnme nt sme e tt her e qui r e dPC s t a ndar ds . c .Thi sc our s ewi l lus eBl ac kboar dt ode l i ve rc our s ema t e r i al ss uc ha s l e c t ur enot e s ,announc e me nt s ,onl i nedi s c us s i ons , a nda s s i gnme nt s , e t c . Addi t i ona lma t e r i a l sbe yondt het e xt bookma ya l s obepos t e don Bl ac kboar d.I ti si mpor t a ntf oryout ovi s i tBl a c kboa r d

( ht t p: / /mymas on. gmu. e du)r e gul ar l yf orc our s ema t e r i a l sa nd a nnounc e me nt s . Cour s eDes c r i pt i on Comput e r i ze dda t a bas e sar evi t alt ot hef unc t i oni ngofmode r n or gani za t i ons .Bus i ne s s e sc ol l e c tl ar gea mountofda t as uc hasna me s , a ddr e s s e s , andc r e di tc a r dnumbe r sonadai l ybas i s .Al lt hi si nf or ma t i oni s s t or e di nda t abas e s .Wi t ht hepr ol i f e r a t i onoft heI nt e r ne tandt heme a nst o c a pt ur eda t ai nc omput e r i z e df or m,avas tamountofda t ai sa va i l abl ea tt he c l i c kofamous ebut t on.Or ga ni zi ngt he s eda t af ore as eofr e t r i e valand mai nt e nanc ei spar amount . Thusmana gi ngda t aba s e shasbe c omeavi t al t as ki nmos tor gani z a t i ons . I nt hi sc our s e ,wewi l ls t udyt hef unda me nt a lc onc e pt sandt e c hni que sof mode l i nga ndde s i gni ngr e l a t i onalda t abas e s .Wewi l ldi s c us swhy da t aba s e sar eus e d,andde s c r i bet hema i nc ompone nt sofda t aba s e mana ge me nts ys t e ms .Fur t he r ,wewi l lc ove rt hef undame nt alSt r uc t ur e d Que r yLangua ge( SQL)s t a t e me nt sus e dt ode finea ndpr oc e s sda t abas e s . Us i ngawe a l t hofs ampl eda t a ba s e sande xa mpl e s ,s t ude nt swi l lgai ns ki l l s t os ys t e ma t i c al l ys ol vebas i ca ndadvanc e dpr obl e msi nque r yf or mul a t i on, da t amode l i ng,andnor mal i za t i on. Thec our s ewi l lus eMi c r o s o f tAc c e s sas t her e l a t i onalda t a bas emana ge me nts ys t e mt oi mpl e me ntt hec onc e pt s c ove r e di nc l as s . Le ar ni ngObj ec t i ve s a . De s c r i bet hec ompone nt sofada t a bas emana ge me nts ys t e m. b .I nt r oduc et her e l a t i onalmode la ndde fineke yr e l a t i ona lda t a bas et e r ms . c .Appl yt heSt r uc t ur e dQue r yLangua ge( SQL) . d.Mode lr e l a t i onalda t a ba s e sus i ngMi c r os of tVi s i o. e .Desi gnpr ac t i c a lda t abas e sus i ngMi c r os of tAc c e s s . Le ar ni ngGoa l s Le a r ni ngg o a l sf o rt h eSOM Unde r g r a dua t ePr o gr a ms a .Ours t udent swi l lbec ompet enti nt he i rdi s c i pl i ne . b.Ours t udent swi l lbea war eoft heus esoft ec hnol ogyi nbus i nes s .

c .Ours t ude nt swi l lbee ffe c t i vec ommuni c a t or s . d.Ours t ude nt swi l lha vea ni nt e r di s c i pl i nar ype r s pe c t i ve . e .Ours t ude nt swi l lbeknowl e dge a bl eaboutgl obalbus i ne s sandt r ade . f . Ours t ude nt swi l lr e c ogni zet hei mpor t anc eofe t hi c a lde c i s i ons . g.Ours t ude nt swi l lbeknowl e dge abl ea boutt hel e ga le nvi r onme ntof bus i ne s s . h.Ours t ude nt swi l lbeknowl e dge abl ea boutt e a m dyna mi c sandt he c ha r ac t e r i s t i c sofe ffe c t i vet e a ms . i . Ours t ude nt swi l lunde r s t andt heval ueofdi ve r s i t yandt hei mpor t a nc e ofmana gi ngdi ve r s i t yi nt hec ont e xtofbus i ne s s . j .Ours t ude nt swi l lbec r i t i c a lt hi nke r s . Le a r ni ngGo a l so ft heI nf o r ma t i o nSy s t e msa ndOp e r a t i o nsMa na g e me ntPr o gr a m a . Appl yknowl e dgeofi nf or ma t i ont e c hnol ogya ndbus i ne s sf unc t i onst o unde r s t andi t sappl i c a t i oni na s s e s s i ng,de s i gni ngandi mpr ovi ngbus i ne s s pr oc e s s e s . b.Deve l opda t aor gani z a t i on, s t or a gea ndpr oc es s i ngs ol ut i onst o s uppor tor gani z at i ona lneedsf ori nf or ma t i onmanage ment .The ywi l l a l s oha vet heopt i onofdeve l opi ngs ki l l si nt hear e aofs uppor t i ng dec i s i onma ki ngt hr oughbus i nes si nt el l i ge nc es ol ut i ons . c .Us eknowl e dgeofc omput e rne t wor ksaspa r toft heI Ts ol ut i onsf or i mpr ovi ngbus i ne s spr oc e s s e s .The ywi l la l s oha veopt i onofde ve l opi ng mor ea dva nc e ds ki l l si nt hear e a sofne t wor kands e c ur i t y . d.Effe c t i ve l ymana gei nf or ma t i ont e c hnol ogypr oj e c t s . e .Unde r s t a ndt heove r a l ls ys t e msde ve l opme ntl i f ec yc l ea ndbeabl et o r e c omme ndI Ts ys t e ms ol ut i onsac c or di ngl y .The ywi l la l s oha veopt i onof l e a r ni ngappr opr i a t ede ve l opme ntt ool st ode ve l oppr ot ot ypeofI T s ol ut i onsf orbus i ne s smana ge me nt . Gr adi ng:

Gr adi ngPar t i c i pa t i on

As s i gnme nt s

6 % St ude nt sa r ee xpe c t e dt o a c t i ve l ypa r t i c i pa t ei n di s c us s i onsi nt hec l as s r oom. Thr e e( 3 )t oFour( 4) 2 4% a s s i gnme nt swi l lbegi ve n

Qui zze s

Mi dt e r m Exam

Fi nalExam

dur i ngt hes e me s t e r .The s e wi l lc ons i s tofpr obl e ms e t s de s i gne dt ogi veyouval uabl e pr a c t i c eande nhanc eyour unde r s t a ndi ngoft he c onc e pt sc ove r e di nc l as s . I ns t r uc t i onsf ort he home wor ka s s i gnme nt sand s ubmi s s i ongui de l i ne swi l lbe pos t e donbl ac kboar d. 1 5% Thequi zze swi l lc ons i s tof mul t i pl ec hoi c e s , fil li nbl a nk, ors hor ta ns we rt ype que s t i onsbas e dont he l e c t ur e s , book,andot he r r e qui r e dr e adi ngs . I fyout ake a l lf our( 4 )qui z ze s , onl yyour be s tt hr e e( 3 )s c or e swi l lbe us e di nt hefina lgr ade c al c ul a t i on.Qui zze sar e c l os e dbookandc l os e dnot e s . Cove rt hefir s tha l foft he 2 5% s e me s t e r .Cl os e dbookand c l os e dnot e s . 3 0% Co ve rt hee nt i r es e me s t e r .

Cl o s e db o o ka ndc l o s e d no t e s .

S t ude nt smus tbeoffic i a l l yr e gi s t e r e di nt hi sc our s et or e c e i veagr a de .I ti s t hes ol er e s pons i bi l i t yoft hes t ude ntt ove r i f yt he i rownr e gi s t r a t i ons t a t us . Youwi l lnotr e c e i veagr a dei fyournamedoe snotappe a ront heoffic i al c l a s sl i s t . Re gi s t r a t i onpr obl e mss houl dbedi r e c t e dt oe i t he rt heSOM Offic e ofS t ude ntSe r vi c e sort heRe gi s t r a r ’ sOffic e . Gr adi ngf ort hec our s ewi l lbeba s e dont ot alpoi nt se a r ne dbyt hee ndof t hec our s e . Fi nalc our s el e t t e rgr adeas s i gnme nt swi l la ppr oxi ma t et het abl e be l ow: A AB+ B B-

93% -1 00% 90% -9 2. 99 % 87 % -89. 9 9% 83% -8 6. 99 % 80 % -82. 9 9%

C+ C D F

77% -7 9. 99 % 70% -7 6. 99 % 60% -6 9. 99 % Be l ow 60 %

I fyouha veaque s t i onaboutyourgr adeoryoube l i e vet ha tyouwe r e gr ade di nc or r e c t l y , pl e as es ubmi taf or ma lr e que s tde s c r i bi ngt hes i t ua t i on a ndt her e as onst ha tj us t i f yyourr e que s tf orr e gr a di ng.I nt hi sc as e ,Iwi l l r e gr a det hee nt i r ewor k,andt hegr adema ygoupordo wn. Youc a n r e que s tar e vi e w ofa nygr adewi t hi nonewe e kf ol l owi ngt heda yt he gr ade das s i gnme nt /qui z /e xa mi sdi s c us s e dorr e t ur ne dt ot hec l as s .Af t e r t ha tpe r i odnogr adewi l lber e vi s e d. Youa r ea l s or e qui r e dt oke e pal lgr a de dma t e r i alt ha ti sr e t ur ne dt oyout i l l a f t e rt hes e me s t e ri sove randyouha vec he c ke dyourfinalgr ade . I ft he r ei s adi s c r e panc ybe t we e nmyr e c or dsa ndyours c or e sf oranyoft hegr ade d ma t e r i ala tanyt i me ,myr e c or dswi l lbea l t e r e donl yi fyouc anpr oduc et he gr ade dma t e r i a lt ha tIha ver e t ur ne dt oyouase vi de nc e–f ai l i ngwhi c hno c ha nge swi l lbemade . Cl as sPar t i c i pa t i on Al ls t ude nt sa r ee xpe c t e dt opar t i c i pa t ei nc l as sdi s c us s i ons . Your par t i c i pa t i on( e . g. ,a s kandans we rque s t i ons )i shi ghl yr e c omme nde df or t hi sc our s ea ndc ount sf or6% oft hefina lc our s egr ade .Ir e c ogni zet ha tnot a l ls t ude nt sar ee qua l l yc omf or t abl ewi t hpa r t i c i pa t i ngi nc l as s ;howe ve r , t hi si sar e l a t i ve l yl ow r i s ke nvi r onme nti nwhi c ht opr a c t i c es ki l l st ha tyou wi l lne e dl a t e ri nl i f e .Qua l i t yofc ont r i but i oni nc l as si smuc hmor e i mpor t antt hanquant i t y . Al ls t ude nt sa r ee xpe c t e dt oc onduc tt he ms e l ve si napr of e s s i ona lmanne r . Thi si nc l ude sf ac t or ss uc hasc omi ngt oc l as sont i mee ve r yda y .Enga gi ngi n a c t i vi t i e st ha tar eunr e l a t e dt ot hec l as ss uc has ,t e x t i ng,pl a yi ngonl a pt op, doi ngwor kofot he rc l a s s e s ,oranyt hi nge l s et ha tde t r ac t sf r om t hei nc l as s l e a r ni nge nvi r onme nt( e . g. , c omi ngl a t e ,l e a vi nge a r l yori nt hemi ddl eofa c l a s s )i snotac c e pt abl eandwi l laffe c tyourpa r t i c i pa t i ongr ade .Be c our t e oust oandr e s pe c t f ult oyourc ol l e a gue sa ndt hei ns t r uc t ori nc l as s . Pl e as edonotbr i ngande a tf oodsdur i ngc l as s .

Cour s ePol i c i es At t e ndanc e Cl a s sAt t e nda nc ei syourr e s pons i bi l i t y ,a ndyoua r es ol e l y r e s pons i bl ef ora l las s i gnme nt s , di s c us s i ons , ma t e r i al pr e s e nt e d/pr ovi de dandannounc e me nt sma dei nc l a s s .

La t eAs s i gnment Al las s i gnme nt sar eduea tt hebe gi nni ngoft hec l a s sont hedueda t e , s ubmi s s i onsaf t e rc l as sbe gi nswi l lbec ons i de r e dl a t e .Pl e as epr e par e i na dvanc es ot ha tyouwi l lnote nc ount e rt e c hni c a ldi ffic ul t i e st ha t wi l lr e s ul ti nyourwor kbe i ngc ons i de r e dl a t eornota c c e pt e d.I fyou c a nnota t t e ndc l as sont heda yana s s i gnme nti sdue , pl e a s ema ke pr i orar r a nge me nt swi t hmeort ur ni nt heas s i gnme nte ar l y . La t ea s s i gnme nts ubmi s s i onsar es ubj e c tt ope nal t i e s :  La t ewi t hi n1hour-5% off  La t emor et han1hourbutl e s st han2 4hour s-15 % off  La t emor et han24hour sbutl e s st ha n4 8hour s-30 % off  Pe nal t yaf t e r48hour s-Notac c e pt e d MakeupExams / Qui z zes Abs e nc ef r om ane xam/qui zwi l lr e s ul ti nas c or eofz e r oandmake up e xa ms /qui z ze swi l lnotnor mal l ybeoffe r e d.A s t ude ntwhomi s s e s ane xam duet oane me r ge nc yma ype t i t i onf oramake upe xa m.The pe t i t i onmus tbei nwr i t i nga ndbeac c ompa ni e dbyappr opr i a t e doc ume nt a t i onaboutt hee me r ge nc y .Pe t i t i oni ngf oramake upe xam doe snotguar ant e et ha tonewi l lbeoffe r e d. Tha tde c i s i oni sa tt he s ol edi s c r e t i onoft hei ns t r uc t orwhowi l lde t e r mi newhe t he rt he e vi de nc eoffe r e dbyt hes t ude ntj us t i fie st heabs e nc e . Communi c a t i ons

Al lc ommuni c a t i onsf r om met oyouwi l lbedi r e c t e dvi ae mai l . Iwi l l addr e s sal lofmye ma i l sonl yt oyourGMUe ma i la ddr e s sf or c onc e r nsofpr i va c yandc onfide nt i al i t y . I fyouus eanot he re mai l ac c ounta syour

pr i ma r ye ma i l ,pl e a s ebes ur et of or war dyourGMUe ma i lt ot ha t ac c ount . Youa r ee nc our a ge dt opos tyourque s t i onsr e l a t e dt ot he l e c t ur e sandas s i gnme nt st ot heDi s c us s i onBoar donBl a c kboa r d.

Announc ement sandUpda t e s Announc e me nt sandupda t e sma ybepos t e donBl a c kboa r d;i ti syour r e s pons i bi l i t yt oc he c kBl ac kboar dr e gul ar l yf ort he s eanda ny s uppl e me nt alc our s ema t e r i a l s .Emai la nnounc e me nt sbe t we e nc l as s me e t i ngsma ybes e ntt oyourGMUe mai lac c ount . Pol i c yonEl ec t r oni cDevi c e s Te c hnol ogyc angr e a t l yas s i s tl e a r ni ng, buti tc a na l s obeadi s t r ac t i on. Pl e as eke e pc e l lphone s ,pa ge r s ,andot he rc ommuni c a t i vede vi c e s s t owe da wa yandi ns i l e nt /vi br a t i onmode .Lapt opsorot her e l e c t r oni cde vi c e ss houl ds t r i c t l ybeus e df orc l as sr e l a t e dac t i vi t i e s s uc ha st aki ngnot e sorf ol l owi ngl e c t ur e s . Enga gi ngi nac t i vi t i e snot r e l a t e dt ot hec our s e( e . g. ,gami ng,e mai l , c ha t ,e t c . )i ss t r i c t l y pr ohi bi t e dandwi l laffe c tyourpa r t i c i pa t i ongr ade . Di s abi l i t y I fyoua r eas t ude ntwi t hadi s a bi l i t yandyour e qui r ea c a de mi c ac c ommoda t i ons , pl e as es e emeandc ont ac tt heOffic eofDi s abi l i t y Se r vi c e s( ODS)a t( 7 03 )993 24 74( ht t p: / /ods . gmu. e du/) ,a tt he be gi nni ngoft hes e me s t e r .Al lac ade mi cac c ommoda t i onsduet o di s abi l i t ymus tbea r r ange dt hr ought heODSands houl dbema de dur i ngt hefir s tt wowe e ksoft hes e me s t e r .

HONORCODE TheHonorCodei sani nt e gr alpa r tofuni ve r s i t yl i f e .St ude nt sar e r e s pons i bl e ,t he r e f or e , f orunde r s t andi ngt hec ode ’ spr ovi s i ons . I nt he s pi r i toft hec ode ,as t ude nt ’ swor di sade c l ar a t i onofgoodf ai t h ac c e pt a bl east r ut hi nal lac ade mi cma t t e r s .Che a t i nganda t t e mpt e d c he a t i ng,pl a gi ar i s m,l yi ng,a nds t e al i ngofa c ade mi cwor ka ndr e l a t e d ma t e r i al sc ons t i t ut eHonorCodevi ol a t i ons .Toma i nt ai nanac a de mi c c ommuni t yac c or di ngt ot he s es t anda r ds ,s t ude nt sandf ac ul t ymus t r e por ta l lal l e ge dvi ol a t i onst ot heHonorCommi t t e e . Anys t ude nt

whohasknowl e dgeof ,butdoe snotr e por t , avi ol a t i onma ybe ac c us e dofl yi ngunde rt heHonorCode . TheUni ve r s i t y' sHonorCodei sde s i gne dt oe ns ur et ha tt hepr i nc i pl e s ofac a de mi chone s t yandi nt e gr i t yar euphe l d.Al ls t ude nt sa r e e xpe c t e dt oadhe r et ot hi sc ode .Al lac t sofac a de mi cdi s hone s t ywi l l bede a l twi t hi na c c or danc ewi t ht hepr ovi s i onsoft hi sc ode . Mor e de t ai lonUni ve r s i t y' sHonorCodea vai l abl eonl i nea t ht t p: / /c a t al og. gmu. e du/c ont e nt . php? c a t oi d=17&na voi d=1 310 #Honor.

School of Business Recommendations for Honor Code Violations Adopted by the faculty May 2012 UG-Non Freshman Students (including transfer students) Type of Violation Plagiarism—failure to cite/attribute sources

First Offense An F in the class; multiple visits to the Writing Center required; and Academic Integrity Seminar Attendance

Plagiarism—representing someone else’s work as the student’s own

An F in the class; multiple visits to the Writing Center required; and Academic Integrity Seminar Attendance

Cheating on an assignment, homework, class participation, or minor project Cheating on a major project, test, or exam

An F in the class; and Academic Integrity Seminar Attendance

Egregious Violation [e.g., stealing an exam; submitting coursework from another class as original work; lying to an employer about academic performance]

An F in the class; Academic Integrity Seminar Attendance; and at least one semester suspension Dismissal from the program; at least one year suspension; and attendance at Academic Integrity Seminar at the time of hearing and just prior to reenrollment

Tent a t i veCour s eSc he dul e

Second Offense An F in the class; multiple visits to the Writing Center required; Academic Integrity Seminar Attendance; dismissal from the program; and possible suspension or expulsion An F in the class; multiple visits to the Writing Center required; Academic Integrity Seminar Attendance (at times of hearing and reenrollment if relevant); dismissal from the program; and possible suspension or expulsion Expulsion

Expulsion

Expulsion

Thi ss c he dul ei ss ubj e c tt oc hangeanda nyc hangewi l lbedul yannounc e d i nt hec l as sand/ori nBl ac kboar d. Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

Date 23-Jan 30-Jan 6-Feb 13-Feb 20-Feb 27-Feb 6-Mar 13-Mar 20-Mar 27-Mar 3-Apr 10-Apr 17-Apr 24-Apr 1-May 8-May

Topics Ch. 1: Database Fundamentals (Getting Started) Ch. 1: Database Fundamentals (Getting Started) Ch. 2: The Relational Model Ch. 2: The Relational Model (Normalization) Ch. 3: Structured Query Language (SQL) – Part 1 * SQL exercise using Microsoft Access * Midterm Exam Spring Break Ch. 4: Data Modeling Ch. 4: Data Modeling Data Modeling exercise using Microsoft Visio * Ch. 5: Database Design Ch. 5: Database Design * Ch. 3: Structured Query Language (SQL) – Part 2 * Review Final Exam (Starts at 7:30 pm)

Deliverables

Quiz 1 Assignment 1 Due Quiz 2

Assignment 2 Due Quiz 3 Assignment 3 Due Quiz 4 Assignment 4 Due...