ISM 6215 Syllabus (Wang) 2020-fall-module 1 PDF

Preview

Summary

Syllabus...

Description

I SM 6215:BUSI NESSDATA SYSTEMSI Fal l2020–Modul e1 I ns t r uc t or Yi ni ngWangyi ni ng. wang@war r i ngt on. ufl. edu Depar t me ntofI SOM,War r i ngt onCol l e geofBus i ne s sAdmi ni s t r a t i on Cl as sTi me TRper i od56( 11: 45a m1: 40pm)orpe r i od9 10( 4: 05pm6: 00pm) Cl as sLoc at i on TBD Offic e STZ35 1A Offic eHour s 11: 00am t o12 : 30pm e ver yWednes da y ,orbyappoi nt me nt( e ma i l23da ysahea d t oma keanappoi nt menti fyouha vec l as sdur i ngoffic ehour s ) TA Yi nLuyi n. l u@ufl. edu TA Offic eHour sTi me&Loc a t i on: t obeannounc edbyt heTA

COURSEDESCRI PTI ON I SM 621 5wi l lf oc usoni nt r o duc t o r yc o nc e pt sa ndpr a c t i c e sofmode r nda t abas es ys t ems .Topi c st ha twi l lbe c over e di nt hi sc l as si nc l udet hel ogi c alde s i gnofr e l a t i onalda t abas es ys t e ms ,phys i c ali mpl eme nt a t i onof da t abas e sandbas i c soft heSQLl angua ge ,auni ver s all angua geus edi nc r ea t i ng, quer yi ng,c hangi ngand upda t i ngda t abas e s . Pl e as es e et hes yl l abusf oramor edet ai l edl i s toft opi c st ha twi l lbec over e di nt hi sc l as s .

TEXTBOOK AND READI NGS Re qui r edText book

t h Mode r nDa t abas eManage me nt ,11 edi t i on,byJ . A. Hoffe r ,V.Rames h,H. Topi .

Cl as sWe bs i t e Announc eme nt s ,as s i gnment s ,c our s es c hedul e ,addi t i onalr e adi ngs , andot her i nf or ma t i onar ea vai l abl eonCanvasa tht t ps : / /ufl. i ns t r uc t ur e . c om/. Youwi l lal s one edt heda t aanal ys i sands t a t i s t i c als of t war e ,STATA.I ti sf r eea t ht t ps : / /i nf o. apps . ufl. e du/. COVI D19PANDEMI CUPDATE Duet ot heunf or t una t epande mi cs i t ua t i onst hee nt i r ec l as si snow 100% onl i ne .Thef ol l owi ngar eaf e w c l ar i fic a t i onsonhow t hi saffec t st hi sc l as s . 1. Lec t ur es .Le c t ur e swi l lbegi venus i ngZo o m me e t i ngs .Be f or et hel e c t ur e sIwi l ls endoutZoom mee t i ngI Dsandpas s wor dsvi at heAnnounc eme ntt oolonCa nvas .Iwi l lal s oupl oads l i de s be f or el e c t ur es . Iwi l lnotpr er e c or dvi de osbutIwi l lr ec or dvi de osasI ’ ml e c t ur i ngl i ve .Soyouc anvi e wt he vi deosaf t e rt hel e c t ur es . At t e ndanc ear ee nf or c e dt hr ought her egi s t r a t i onf e a t ur eofzoom mee t i ngs .I ’ l lal s ol oc kt he mee t i ngaf t er10mi nut e ss ot ha tl a t e c ome r swon’ tbeabl et oa t t e nd.I fyouha ver e as onst obe abs entorl a t ef ormyc l as spl e as el e tmeknow be f or ehand.

1

2. Exams .Pe rr e qui r e me nt sf r om t hec ol l e ge , e xamsac c ount i ngf ormor et han15% oft het ot algr ade mus tbepr oc t or edand,i nt hi st i meofpande mi c s ,mus tbec onduc t e dus i ngHo no r l o c k .Iha ve upl oade das t udentgui de l i nef orHonor l oc konCanvas . Ther ear et woe xams( mi dt e r m/final )i nt hi sc our s e .De s pi t et hee xamsbe i ngt akenr emot e l y , t he r ear es t r i c tt i mec ons t r ai nt s .Bot he xamsmus tbet ake ni nas hor t2hours pan( whenyou us ual l ya t t e ndt hec l as sl ec t ur e s )ande ac he xam hast he i rownt i mel i mi t s( e nf or c e dby Honor l oc k) .I ns pec i alc i r c ums t anc es( e . g. ,di ffer e ntt i mezone s )Ima yal l ow t hee xamsbe i ng t ake nahe adoft her e gul arl ec t ur et i mewi t hi n24hour s .Res c he dul i nge xamsbe yond24hour si s i nge ne r alnotpos s i bl eandgove r ne dbyt hepol i c i e ss t a t edi nt hes yl l abusl a t e r . 3. As s i gnment s .The r ear et woas s i gnment si nt hi sc our s e .The yar enotpr oc t or e dandt he r e f or eyou don’ tnee dt ous eHonor l oc kt oans wert he m. Youar ehowe ve rr e qui r edt owor ki nde pendent l y ands houl dnotdi s c us swi t hyourc l as s ma t esunt i lt heas s i gnment sar es ubmi t t ed. Ast hec l as spr oc ee dsi ft he r ear ene w upda t e sIwi l lannounc et he m onCanvas . Pr i vac ys t at ement . Our class sessions may be audio visually recorded for students in the class to refer back and for enrolled students who are unable to attend live. Students who participate with their camera engaged or utilize a profile image are agreeing to have their video or image recorded. If you are unwilling to consent to have your profile or video image recorded, be sure to keep your camera of and do not use a profile image. Likewise, students who un-mute during class and participate orally are agreeing to have their voices recorded. If you are not willing to consent to have your voice recorded during class, you will need to keep your mute button activated and communicate exclusively using the "chat" feature, which allows students to type questions and comments live. The chat will not be recorded or shared. As in all courses, unauthorized recording and unauthorized sharing of recorded materials is prohibited. WORKLOAD We l c omet ot heWar r i ngt onCol l e geofBus i ne s sAdmi ni s t r a t i on,whe r ee ve r yoneadmi t t ed–i nc l udi ng you–i sat ops t udent .I nor de rt oc hal l engeyouandt r ul yaddt oyoureduc a t i on,t heWar r i ngt onCol l e ge ofBus i nes sAdmi ni s t r a t i on i sc ommi t t e dt or i gor ous ,c ut t i ngedgec l as s e s .Thi sme anst ha tyou c an e xpec tas ubs t ant i alwor kl oad. Ourgoali st ohe l pyougobe yondbe i ngat ops t udent .Ourvi s i oni st ha tyouwi l lbec omeapr oduc t i ve e mpl oye e ,aneffec t i vepr oj ec tl ea der ,af ut ur edi vi s i onl ea de r ,per hapsaf ut ur eCEO.Someofyouwi l l wor ki nt r adi t i onalc ompani e s ;s omewi l lwor kf ornonpr ofit s ;s omewi l lbe c omepr of es s i onalbus i ne s s c ons ul t ant s ;s omewi l lgr ow af ami l ybus i ne s sors t ar tyourowns uc c e s s f ulbus i ne s s .Al lt he s ec ar e er pa t hsha ves omet hi ng i nc ommon:t os uc c ee di n ac ons t ant l yc hangi ng bus i ne s swor l d,you mus t c ons t ant l ys ee k ne wi nf or ma t i on f r om t hee nvi r onment ,makes e ns eofi twi t h yourc ol l e aguesand bus i nes spar t ner s ,andac toni tt ode ve l opandi mpl eme ntyourbus i ne s ss t r a t e gy .Youmus tbeabl et o t hi nkc r i t i c al l y . I nor dert ot hi nkc r i t i c al l y ,younee daknowl edgebas e .A s i gni fic antpar tofI SM6215i nvol ve sr e adi ng, l e ar ni ng,andpr ac t i c i ng.Le ar ni ngt he s eba s ec onc e pt swi l lgi veyouaf ounda t i onf ort hi nki ngc r i t i c al l y ands ol vi ngr e albus i ne s spr obl ems .ThegoalofI SM6215i st ode l i verl ea r ni ngt ha twi l ls e r veyoui nt he f ut ur e ,bot ha tUFandi nyourc ar ee r .

2

EVALUATI ON OFYOURPERFORMANCE Thefinall e t t ergr adei nt hec l as swi l lbebas e d on ac ur ve .You ma ye xpe c tt hef ol l owi ng gr ade di s t r i but i on:appr oxi ma t e l y4045% wi l lr ec ei veanA-orabove ,about5% wi l lr e c ei veaC+orbe l ow,and 4560% wi l lr ec ei veaB+,B,orB.Howe ver ,t hegr adedi s t r i but i onandt hea ve r a gec oul dc hangei ft he ove r al lc l as spe r f or manc ee xc e edst hei ns t r uc t or ’ se xpe c t a t i ons . Thebr e akdownofyourfinalgr adei sasf ol l ows :

De l i ve r a bl eDet ai l

Poi nt s

Cl as sPa r t i c i pa t i ona ndI nc l a s sQui zz es As s i gnment s( 2as s i gnme nt s ,5poi nt se ac h) Ex ams( 2e xams ,30f orExam 1,40f orExam 2)

1 0 1 0 7 0

Gr oupPr oj ec t( Pr es ent a t i on+Fi nalRepor t )

10

Tot alPoi nt s

1 00

1 .Cl a s sPar t i c i pa t i on Toge tt hemos tf r om t hi sc l as s ,i ti si mpor t antt ha tyouc omet oc l as sr e adyt oj oi nt hedi s c us s i onont he da y’ st opi c .Youar ee xpe c t edt or e adal lt heas s i gne dr e adi ngma t er i al sbe f or ec l as s ,be ha vepr ope r l yi n t hec l as sr oom,and c ont r i but eac t i ve l yt ot hec l as sdi s c us s i on.Pl e as eus eanamec ar dt ohe l pt he i ns t r uc t orandyourpee r sr e me mbe ryourname .Si t t i ngr oughl ya tt hes ames poti ne ac hc l as sc oul dhe l p s pe edupt hi spr oc es s .Whe ne val ua t i ngc l as spar t i c i pa t i on,Ikee pt hec r i t er i aasf ol l ows :  At t e ndi ngc l as sr e gul ar l y 

Di s pl a yi ngpos i t i vebeha vi or ss uc hasac t i vel i s t e ni ngt ot hei ns t r uc t orandpee r s ,as ki ngi ns i ght f ul ques t i ons ,r e s pondi ngt oque s t i ons ,s ynt he s i zi ngot he r s ’i dea s , br i ngi ngappr opr i a t er e al l i f e e xper i enc e s ,anddi s a gr e ei ngc ons t r uc t i ve l y

2 .Qui z ze s Oc c as i onal l y ,t he r ewi l lbequi zze sgi ve nonc l as sc ont e nt .

3 .As s i gnme nt s I Ts ki l l sf ori ndi vi dualpr oduc t i vi t ywi l lbeane c e s s i t yf oranybus i ne s spr of e s s i onal si nt he i rc ar ee r s .To he l ps t udent s ma s t er bas i c da t a anal yt i c ss ki l l s ,t her e ar e TWO home wor k as s i gnment s .Thos e as s i gnme nt swi l ls i mul a t er e al l i f et as ksandas ks t ude nt st os ol vet he m byus i ngt hede s i gna t e dt ool s. Spec i ficde t ai l sf ort he s eas s i gnme nt swi l lbepos t e donCa nvas .

4 .Exams Ther ear et woi nc l as se xams( s eeCour s eSc hedul ef ordet ai l s ) .Ane xam r e vi e ws e s s i onwi l lbepr ovi ded be f or ee ac he xam.Examswi l lc ombi ne mul t i pl e c hoi c e and es s a yf or ma tques t i ons .Unl e s sunder s i gni fic ant l ye xt r emec i r c ums t anc e s ,makeupe xamswi l lNOTbear r ange d.The extreme emergency must be approved by the instructor BEFORE the exam date. Mor edet ai l edr ul esasf ol l ows : 4. 1. Exam 1c annotber e s c hedul e dorr e t akenunderanyc i r c ums t anc es ,e xc eptf ort i mez onedi ffer enc e s ( i nwhi c hc as et hee xam c anbes c he dul e dbef or et her e gul are xam t i meandupt o24hour s ) .I ft her e ar eeme r ge nc i e sors c he dul i ngc onfli c t sr e s ul t i ngi nabs enc ei nExam 1 ,t hei ns t r uc t orwi l l ,whe n not i fie di nadvanc e ,as s i gnt hes c or e si nExam 1t oExam 2; 3

4. 2. Exam 2 c an onl y be r es c he dul ed unde rs i gni fic ant l ye xt r e me c i r c ums t anc es .The f ol l owi ng c i r c ums t anc e sar eNOTc ons i der eds i gni fic ant l ye xt r eme :i nt er vi e w orons i t evi s i t sa tpot e nt i alj obs , pl anne dper s onalt r a ve l s ,pl anne dper s onalhomevi s i t s ,e t c . 4. 3. I ft her edoe se xi s ts i gni fic ant l ye xt r emec i r c ums t anc es ,ands uc hc i r c ums t anc e sar eappr ovedbyt he i ns t r uc t orbef or et heexam dat e,ar e s c hedul ed e xam da t ec an bea gr ee d,whi c h mus thappen bef or et her egul arex am dat e.Thee xam c annotber e s c he dul e d/r et akenaf t ert her e gul are xam da t e ,unl e s st he r ei sanunf or e s e e abl emedi c alc ondi t i onont hee xam da t et ha tf or bi dst hes t udentt o t ake t he e xam.I fs uc h unf or e s e e abl e medi c alc ondi t i onsoc c ur ,doc t or ’ snot es /a t t es t a t i on ar e nec es s ar yt oj us t i f yt hes t udent ’ sabs enc e .

5 .Gr oupPr oj e c t Thec l as swi l lha veagr ouppr oj e c t .A gr oupofbe t we enf ourt os i xs t udent sc anwor kt oget heront he pr oj e c t .Thedet ai l edde s c r i pt i onf ort hi spr oj ec twi l lbegi venl a t eri nt hemodul e.

6 .Cha nge s Thi sc our s ewi l lbeve r ydynami c ,s oEXPECTc hanges .Change si ns c he dul e swi l lbepos t edonc our s e we bs i t e .I ti st hes t udent ’ sr e s pons i bi l i t yt okee pupwi t ht hec hange st ha tar epos t e donc our s ewe bs i t e .

7 .Ext r aCr e di t Ther ewi l lbenooppor t uni t yt or ai s eyourc our s egr adebydoi ngi ndi vi duale xt r ac r e di twor ka tany poi ntdur i ngoraf t e rt hes eme s t e r ,ast hi swoul dvi ol a t eUni ver s i t ypol i c y .

POLI CI ES Fairness, Deliverable Deadlines, and Time Management De l i ve r abl e s ar ea s s i gne d be c aus e wor k out s i de of c l as ss uppl e me nt sa nd r ei nf or c e sl ea r ni ng. De l i ve r abl e sar eal s oduea tde s i gna t e dt i me sandi ns pec i ficf or ma t s ,al lofwhi c hwi l lbede s c r i bedi n as s i gnme ntc r i t e r i a .Tobef ai rt oe ve r yonei nc l as sand t oge tas s i gnment sgr ade d and r e t ur ne di na t i me l yf as hi on,weha vet oha vede adl i ne s .Pl e as et ur nt hi ngsi nont i me .  De l i ve r abl e shandedi naf t e rbutwi t hi n24hour soft hedueda t e /t i mewi l lr e c ei vehal fc r e di t .



De l i ve r a bl e swi l lnotbea c c e pt e dmor et han24hour sa f t e rt hedueda t e .

Cl a s s r oom pol i c y Pl e as eal s ot ur noffyourmobi l ephone sandot he re l ec t r oni cde vi c e st oa voi ddi s t ur bi ng.Pl ea s ear r i veon t i meandl e a veaf t erc l as sends .Remembert ha tyourc l as s r oom c i t i ze ns hi pwi l lbec ons i de r edi nyouri nc l as spar t i c i pa t i ongr ade s .

Us i ngEma i lf orOffic i alCor r e s pondenc et oSt udent s Emai li sr e c ogni zedasanoffic i almodeofuni ver s i t yc or r es ponde nc e ;t her e f or e ,youar er e s pons i bl ef or r e adi ngyouremai lf oruni ver s i t yandc our s e r e l a t e di nf or ma t i onandannounc e me nt s .Youar e r e s pons i bl ef orke epi ngt heuni ve r s i t yi nf or me daboutc hange st oyoure ma i laddr e s s .Yous houl dc hec k youre mai lr e gul ar l yandf r e que nt l y–Ir ec omme nddai l y–t os t a yc ur r entwi t huni ver s i t yr e l a t e d c ommuni c a t i ons , s omeofwhi c hma ybet i me c r i t i c al .

4

Doc ument edDi s a bi l i t ySt a t e me nt St ude nt sr eque s t i ngac c ommoda t i onf ordi s abi l i t i esmus tfir s tr e gi s t erwi t ht heDe anofSt udent sOffic e ( ht t p: / /www. ds o. ufl. edu/dr c /) .TheDe anofSt udent sOffic ewi l lpr ovi dedoc ument a t i ont ot hes t ude nt whomus tt he npr ovi det hi sdoc ument a t i ont ot hei ns t r uc t orwhe nr eque s t i ngac c ommoda t i on.Youmus t s ubmi tt hi sdoc ument a t i onpr i ort os ubmi t t i ngas s i gnment sort aki ngt hequi zze sore xams . Ac c ommoda t i onsar enotr e t r oac t i ve ,t her e f or e ,s t udent ss houl dc ont ac tt heoffic eass oonaspos s i bl ei n t het er mf orwhi c ht he yar es ee ki nga c c ommoda t i ons .

I SOM Depar t mentPol i c yonHonorCodeVi ol a t i ons Foranyac ademi cc l as sac t i vi t y , s t udent smus tf ol l ow t heUni ver s i t yofFl or i daSt udentHonorCode ht t p: / /www. ds o. ufl. edu/s t ude nt s . php) .Anyvi ol a t i onoft hec odewi l laut oma t i c al l yr es ul t si naf ai l i ng ( gr ade( E)f ort hi sc our s eandyouwi l lber e por t e dt ot heOffic eoft heDea nofSt ude nt s .TheDe anof St ude nt smi ghti mpos ef ur t hers anc t i ons ,s uc hass us pens i onore xpul s i on.

5

I SM 6 21 5Cl a s sSc he dul e–Yi ni ngWa ng Where to find the readings: Ch.#: Textbook chapters Thi ss c he dul ei ss ubj e c tt oc ha nge .

Wk 1 2 3

4 5 6 7

Cl 1 2 3 4 5 6

Da t e TSep1 RSe p3 TSep8 RSe p10 TSep15 RSe p17

7 8 9 10 11 12 13 14

TSep22 RSe p24 TSep29 ROc t1 TOc t6 ROc t8 TOc t13 ROc t15

Cl as s Cour s eI nt r oduc t i on,ERmode l s( r e vi e w) l ogi c alda t abas ede s i gn Nor malf or ms Phys i c alda t abas ede s i gn Wor kda y( noc l as s ) As s i gnme nt1andExam 1r e vi e w,Q/A s es s i on Exa m #1( mi dt er m) Exam 1s ol ut i on,I nt r oduc t i ont oSQL SQL–Par tI SQL–Par tI I SQL–Par tI I I As s i gnme nt2a ndFi nalr e vi e w;pr e s ent a t i ons Pr oj e c tpr e s e nt a t i ons( c ont ’ d) Exam #2( final )

Re adi ngs Chapt e r1 Chapt e r s1 ,2 Chapt e r4 Chapt e r5 Wor konAs s i gnme nt1

Del i ver abl es

As s i gnme nt1pos t e d Gr oupf or ma t i onduea tt hebe gi nni ngofc l as s As s i gnme nt1duea tt hebe gi nni ngofc l as s

I ns t al lMySQLWor kbenc h Chapt e r s6 ,7 Chapt e r s6 ,7 Chapt e r s6 ,7

As s i gnme nt2pos t e d

As s i gnme nt2duea tt hebe gi nni ngofc l as s Fi nalpape rduebyemai lonTue s da y9 : 00 pm EST

6...