Details of this Paper

Assignment 1

Description

solution


Question

;;I M P ORTA N T I N F ORMA T I ON;You must submitthe a ss i g nment e l ec t r o n ically b ythe dued a te viat h e onl i nesubmis s ion l i nk on the C I S 2002 S tudy D e sk.;You must usethe o f fi c ialUSQ d a tamodell i ng a ndnorm a l iz a t i on methodo l o g y. This methodolo g yis bas e d onCl i ve F inkelst e i n ? s te c hn i qu e s (R ea di n g s 2.1 a nd 2.2) a nd a llthe e x a mp l e s in t hele c tur e s,stu d ybook a nd the tutor i a ls u s eth i s methodolo g y.;I f y ou do not use theU S Q m e thodo l o g y, y ou willpro ba b l ybe a w a r d e d ama r k of z e ro.;I t i s p e r fe c t l y ac c e ptableif y ou submitn ea t han d - dr a wn E RD ? s (whi c h y ou ca n s ca n a nd;p a ste into y our a ss i g n m e nt).Alte r n a t i v e l y, y ou m i g ht wish to use W ordor a n yot h e r so f t w a re to dr a w thedi a g r a m s. I f y o u useaCASE or d r a wingtoo l, y ou must ad a pt t hedr a wi n gto c onfo r m t o the USQ methodolo g ies.;S ECTI O N A(A P P LI E D D A TABASETH E O R Y) (20 m a r k s);B TC AU is thes e c ond l a rg e st B i t c oin e x c h a n g e c ompa n yin Aust r a l i a. W hi l eitfo c us e d on k ee pi n gup with i ts co r ebusin e ss i n an e w a nd e me r g ing e nvironme n t B TC AU p a id sc a nt a t t e nt i on to m a n a g i n gther e st of i t s r a pid l y e x p a ndingbusin e s s op e r a t i ons.Int e g r a t i on ofi t s busin e ss pro ce sses w i t hIT b eca me o n eof the p rio r i t ies of B TC AU.;The c ur r e nt app r o ac h to i tsb ac kroom d a ta h a ndl i ngma n a g e menth a s b ee n a d hoc a nd pie ce m e a l. Th e re w a s noov e r a llmap, pl a n, orm o d e l g uided a pproa c h tothe e volu t ion of its s y stems. R ec o rds ofp a stbusin e ss pe r fo r ma n c e h a veb ee n h a rd to e l i c itf r o m t hetr a di t ional filepro c e ss i n g s y stems l ea vi n gthe c ompa n ywith an in a bi l i t yto g a in i nsights t odrive busin e ss p l a nningf o r wa rd.;The C I O ofthe c ompa n y S a mN a k a mo t ow a nts t o look at ad a tab a s e a ppr o ac h to i nt e g r a t i n g the v a rious a ppl i ca t i ons c ur re nt l yrun n i n gwith i n the o r g a ni z a t i onwith t hehopeoful t i m a te l y usingthe d a ta to supportd ec is i on making a nd d e v e lop i ngn e w insi g htsforman a g e ment in ord e r to g a i n c om p e t i t i ve a dv a nt a g e.;As abusin e ss consultantto B TC A U, y ou a r e a s k e d to dev e lop a sho r t bri e ftoman a g e ment, in t hefo r m of a n e s s a y(around1000 wo r ds), h i g h l i g ht i ngt h efollowin g;1. The e xistingandp o t e n tial p r o b le m s w i th thec u rre n t d ata pr o c ess i n gap p r o a ch.;2. The n e e df o ra d atab a s ea p p r o ach t os a tisfy t h eir o r g a n i z ati o n al a n ddecis i o n m a ki n g d e m a nd s o f t h e c o m p a n y.;3. A s ugg es t ed d a t a b ase d e v e l o pm ental a pp r o ach;4. The p ri m ary a ct i v itiesas s o ciatedwith data b a s e d esi g nproce s s.;You are re qu ir e dto e x ten sively re s e a r c honthe r e levant t o p ics and p r e s e n t c o n c ise and w o r k a b le so l u tion.;T h er eis n o re qu ir e m e n t f or f o r m al i n - t e x t r e fe re n c i n g inthis q u e stio n.Ho w e v er, it is rec o mme nd e dyou pu t a list of re f ere n ce s at t h e e n dofthe m e m o s h owi n g the p u b l i s h e d m a t e r ia l s that you r e s e a rc h e d w h i l ea n s w er i n gthis qu e stio n.;S ECTI O N B (S Q L) (40 m a r ks);F or e a c h qu e stio n, m a rk s w i ll b e a w a r d e d f or t h e S QLa n d f orthe c o rrec t outp u t.;Thefollowing E - R di a g r a m r e p r e s e nts a CarHire d a tab a s e.;I_ Cus t o m er I_B o o k i n g;I_ C ar I_ M o d el;I_ C a r G ro u p;I n t h i s qu e s t i on

 

Paper#63250 | Written in 18-Jul-2015

Price : $27
SiteLock