BIS 245http://www.homeworkmotivator.com/products/bis-245?pagesize!2 BIS 245 "I#$% &'$()*+, !- .hich ob/ect wou0d 1ou use to e2ter3 de0ete3 or modi41 data?)*+, !- .hich ob/ect wou0d 1ou use to retrieve customers who 0ive i2 5erma21 a2d the 62ited States?)*+, !- *o desig2 a report 1ou shou0d do a00 o4 the 4o00owi2g &'+&7*)*+, !- .hich o4 the 4o00owi2g is #,* a 8eport Sectio2?)*+, !- $ 9etai0 0i2e is used to)*+, 2- "or the 4o00owi2g image3 which o4 the 4o00owi2g is *86&?)*+, 2- $ s1mbo0 used i2 &8 diagrams 4or a2 e2tit1 is a)*+, :- $ propert1 that provides a ;user 4rie2d01< 2ame to a co0um2 i2 9atasheet =iew is a)*+, :- Summarized data i2 a2 eas1-to-read view is k2ow2 as a)*+, :- .hich o4 the 4o00owi2g is #,* true o4 a propert1?)*+, 4- .hich o4 the 4o00owi2g does #,* describe the 4o00owi2g o2e-to-o2e re0atio2ship?)*+, 5- .hich 4orm t1pe disp0a1s records i2 a tabu0ar 4ormat simi0ar to a 9atasheet view but has more editi2g optio2s such as addi2g graphics?)*+, 5- $ ca0cu0ated co2tro0)*+, >- .hich o4 the 4o00owi2g is a term used to describe the 2ames o4 co2tro0s3 4ie0ds3 or properties?)*+, >- 9ata aggregates)*+, ?- .he2 maki2g vertica0 data compariso2s3 1ou shou0d use the 4o00owi2g chart.)*+, ?- 9iscrete data)*+, @- $ switchboard is a)*+, A- *o secure a2 $ccess database3 a00 o4 the 4o00owi2g shou0d be do2e &'+&7*)*+, A- $00 o4 the 4o00owi2g describe a certi4icatio2 authorit1 &'+&7*)*+, !B- .hich o4 the 4o00owi2g 4i0e 4ormat t1pes removes a00 =B$ code 4rom the database a2d prohibits users 4rom maki2g cha2ges to 4orms a2d reports?)*+, 4- *he term ;cascadi2g< re4ers to)*+, !- 9escribe three-tier architecture. &Cp0ai2 the 4u2ctio2s per4ormed b1 each tier.)*+, 2- &Cp0ai2 busi2ess 0ogic a2d describe how it re0ates to a re0atio2a0 database)*+, 4- "rom 4irst 2orma0 4orm3 seco2d 2orma0 4orm3 or third 2orma0 4orm3 se0ect o2e o4 these 4orms a2d eCp0ai2 )!- how that 2orma0 4orm is o4te2 vio0ated b1 i2eCperie2ced database desig2ers a2d )2- how to correct such a vio0atio2 o4 that 2orma0 4orm)*+, 4- &Cp0ai2 !#"3 2#"3 a2d :#" as re0ated to database desig2http://www.homeworkmotivator.com/product/bis-245-fnal-exam BIS 245 9IS+6SSI,# D6&S*I,#S $%% ? .&&ES.eek ! 9D ! F 9atabases a2d 5atheri2g 8eGuireme2ts.eek ! 9D 2 F +hoosi2g a 9atabase.eek 2 9D ! F &2tit1 8e0atio2ship )&8- (ode0i2g.eek 2 9D 2 F 9atabase *ab0e 9esig2.eek : 9D ! F +o2ceptua0 9atabase 9esig2.eek : 9D 2 F 8eGuireme2ts $2a01sis.eek 4 9D ! F +reati2g Dueries 4rom woodcra4t 9atabase.eek4 9D 2 F +reati2g Dueries 4rom #orth.eeki2d 9atabase.eek 5 9D ! F 9ata #orma0izatio2.eek 5 9D 2 F 9ata =a0idatio2.eek > 9D ! F 9ata 8eporti2g.eek > 9D 2 F 7rese2ti2g 9ata &44ective01.eek ? 9D ! F 9atabase #avigatio2.eek ? 9D 2 F 9atabase Securit1http://www.homeworkmotivator.com/product/bis-245-discussion-questions-all-7-weeks BIS 245 *I8& +,68S& 9&=8HBIS 245 All 7 Weeks Discussions .eek ! 9D ! F 9atabases a2d 5atheri2g 8eGuireme2ts .eek ! 9D 2 F +hoosi2g a 9atabase .eek 2 9D ! F &2tit1 8e0atio2ship )&8- (ode0i2g .eek 2 9D 2 F 9atabase *ab0e 9esig2 .eek : 9D ! F +o2ceptua0 9atabase 9esig2 .eek : 9D 2 F 8eGuireme2ts $2a01sis .eek 4 9D ! F +reati2g Dueries 4rom woodcra4t 9atabase .eek4 9D 2 F +reati2g Dueries 4rom #orth.eeki2d 9atabase .eek 5 9D ! F 9ata #orma0izatio2 .eek 5 9D 2 F 9ata =a0idatio2 .eek > 9D ! F 9ata 8eporti2g .eek > 9D 2 F 7rese2ti2g 9ata &44ective01 .eek ? 9D ! F 9atabase #avigatio2 .eek ? 9D 2 F 9atabase Securit1BIS 245 .eek ! %abBIS245 .eek 2 %ab F Ski00s 9eve0opme2t i2 =isioBIS 245 .eek : %ab F =isio &89BIS 245 .eek 4 %ab F &8 9iagramBIS 245 .eek 5 %ab F &8 9iagram a2d &8 (atriCBIS 245 .eek > i%ab +reati2g 8eportsBIS 245 .eek ? i%abBIS 245 "i2a0 &Camhttp://www.homeworkmotivator.com/product/bis-245-entire-course-devr BIS 245 I%$BS !-? I#*8,96+*I,# *, (S =ISI, $#9 (S $++&SSBIS 245 .eek ! %abBIS245 .eek 2 %ab F Ski00s 9eve0opme2t i2 =isioBIS 245 .eek : %ab F =isio &89BIS 245 .eek 4 %ab F &8 9iagramBIS 245 .eek 5 %ab F &8 9iagram a2d &8 (atriCBIS 245 .eek > i%ab +reati2g 8eportsBIS 245 .eek ? i%abhttp://www.homeworkmotivator.com/product/bis-245-ilabs-!-7-introduction-to-ms-visio-and-ms-access BIS 245 .&&E ! %$B%ab ! 7art + Duestio2s:!. &2tities i2 the co2ceptua0 mode0 eve2tua001 are co2verted to tab0es i2 the database3 a2d the attributes co2vert to the 4ie0ds withi2 the tab0es. 5ive2 this i24ormatio23 0ist the attributes )4ie0ds- 4ou2d i2 the supp0ier tab0e.2. .ith the +ustomers tab0e sorted i2 a0phabetica0 order b1 cit13 what is the 2ame o4 the 4irst customer to appear i2 the tab0e?:. .ho are the +ustomers 0ocated i2 the *e22essee?4. %ist the tab0es a0o2g with the primar1 ke1 4or each.5. %ist the tab0es ;re0ated< to the ,rders tab0e.>. ,pe2 Guer1 ;I2ve2tor1 o2 Io0d< b1 doub0e c0icki2g that Guer1. .hat data is i2 this Guer1 )give the co0um2 2ames-? .hat is the Dua2tit1 o2 Io0d 4or #orthwi2d 9ried 70ums?http://www.homeworkmotivator.com/product/bis-245-week-!-lab BIS 245 .&&E : %$B F =ISI, &897art $: +reate a =isio &89 4rom 9ata 8eGuireme2ts a2d Busi2ess 8u0esStep !: ,pe2 =isioa. ,pe2 (icroso4t ,44ice3 =isio app0icatio2 orb. I4 1ou are usi2g +itriC3 c0ick o2 (icroso4t ,44ice $pp0icatio2s 4o0der to start =isio.Step 2: Ide2ti41 a2d create the e2titiesa. ,pe2 a 2ew b0a2k 9atabase (ode0 9iagram.b. Save the 4i0e as Hour#ameJ%ab:.vsd.c. Based o2 the i24ormatio2 provided be0ow3 create the 2ecessar1 e2tities 4or the 7ages i2 *ime database. I4 1ou 2eed assista2ce to create the e2tities3 re4er to 0abs 4rom .eeks ! a2d 2.7ages i2 *ime7ages i2 *ime is a sma00 bookstore carr1i2g a variet1 o4 books. *he ow2ers have decided to computerize the books avai0ab0e through the store so that the1 ca2 determi2e more easi01 what books are o2 ha2d a2d which books 2eed to be specia0 ordered to meet customer 2eeds. Because customers do 2ot a0wa1s remember the 2ame o4 a desired book3 the ow2ers wa2t to be ab0e to 0ook 4or books b1 author or b1 t1pe )ge2re-. *he1 a0so wa2t to be ab0e to 4i2d the pub0isher"s i24ormatio2 usi2g the s1stem so that the1 ca2 order books more easi01.$4ter visiti2g with the ow2ers3 1ou have gathered the 4o00owi2g i24ormatio2 o2 data reGuireme2ts a2d busi2ess ru0es to deve0op aco2ceptua0 desig2 )&89-3 prepare it 4or co2versio2 to a2 $ccess database3 a2d the2 create the actua0 database.9$*$ 8&D6I8&(*SHou have determi2ed that 1ou wi00 2eed at 0east the 4o00owi2g e2tities to reso0ve the re0atio2ships that eCist i2 the data.+6S*,(&8SI9#ame )store data i2 its sma00est parts-7ho2e$ddress )store data i2 its sma00est parts-7ho2e #umber&-mai0 $ddress7re4erred +o2tact (ethod,89&8S#umber9ate8eceived 9ate+ustomer +o2tacted )Hes or #o-B,,ESISB# #umber*it0e7urchase 7riceHear 7ub0ished"ictio2 or #o24ictio2*1pe )5e2re-I2 stock$6*I,8I9#ame )store data i2 sma00est partsK-Short Biograph176B%ISI&8I9#ame$ddress7ho2e 2umber+o2tact 7erso2"aC #umber.ebsiteStep :: Ide2ti41 a2d create attributes )4ie0ds-#,*&: Because 1ou are creati2g 1our diagram i2 =isio3 it wi00 be easier to create the attributes prior to the re0atio2ships.a. 8e4er to the data reGuireme2ts 4rom Step 2 o4 this 0ab. I4 1ou have 2ot a0read1 created the attributes )4ie0ds- i2 1our &893 add them at this time.b. Be sure that 1ou store data i2 its sma00est parts.c. Save 1our 4i0e3 a2d co2ti2ue to Step 4.Step 4: Ide2ti41 a2d desig2ate the ke1sa. 9etemi2e whether a2 attribute eCists i2 each tab0e that wi00 satis41 the reGuireme2ts o4 a primar1 ke1. I4 2o appropriate 4ie0d eCists3 create a 4ie0d 4or this purpose.b. +heck the 7rimar1 Ee1 propert1 4or the 4ie0d i2 each tab0e usi2g the =isio co0um2 properties.Step 5: Ide2ti41 the re0atio2shipsa. 6si2g the i24ormatio2 be0ow o2 the busi2ess ru0es 4or 7ages i2 *ime3 create the re0atio2ships betwee2 the e2tities created i2 Step 2.b. #otice that whe2 (a21-to-(a21 re0atio2ships eCist3 1ou wi00 2eed to create associative e2tities.c. "or a21 associative e2tities created3 e2ter 2ecessar1 4ie0ds. Hou ma1 a0so 2eed to desig2ate or create a primar1 ke1.B6SI#&SS 86%&SBusi2ess ru0es he0p determi2e the re0atio2ships betwee2 data that shou0d he0p 1ou desig2 the re0atio2ships betwee2 1our e2tities.!. &ach customer ca2 p0ace ma21 orders over time3 but each order is p0aced b1 o201 o2e customer.2. &ach order ma1 i2c0ude ma21 books3 a2d a book ma1 be i2c0uded o2 ma21 orders.:. &ach book ma1 have mu0tip0e authors3 a2d each author ma1 have writte2 mu0tip0e books.4. &ach book has o201 o2e pub0isher3 but a pub0isher ma1 pub0ish ma21 books.Step >: 9etermi2e a2d speci41 the data t1pesa. 6si2g the i24ormatio2 be0ow3 se0ect the data t1pe 4or each attribute )4ie0d- i2 1our diagram3 a2d set the t1pe i2 the attribute properties.$s the data t1pes a2d 4ie0d 0e2gths are 2ot i2c0uded i2 the data reGuireme2ts3 1ou shou0d make a se0ectio2 based o2 1our k2ow0edge o4 the t1pe o4 data a2d approCimatio2 o4 0e2gth reGuired. *he =isio a2d $ccess data t1pe eGuiva0e2ts are show2 be0ow:$ccess=isio#umberI2teger*eCt*eCt(emo%o2g*eCt9ate/*ime9ate*ime+urre2c1+urre2c1Hes/#oBi2ar1$uto#umber%o2gI1per0i2k#o eGuiva0e2tFuse *eCtStep ?: (odi41 the =isio Setti2gs to show the 9ata t1pe a2d 4ie0d size i2 the diagram.a. +ha2ge 1our =isio setti2gs so that these appear o2 the actua0 diagram. *o do this3 go to the 9atabase ribbo23 9isp0a1 ,ptio2s. I2 the 9isp0a1 ,ptio2s dia0og boC3 se0ect the *ab0e tab. Hou wi00 the2 cha2ge the data t1pes to Show 7h1sica0. +0ick the ,E butto2 to app01 the 2ew setti2g. *he1 data t1pes wi00 the2 appear i2 1our diagram. #ote that 1ou ma1 2eed to move the e2tities so that the1 are easi01 viewed as the1 are 2ow 0arger.b. Be sure to save the 4i2a0 versio2 o4 1our 4i0e.&2d o4 7art $7art B: +reate the $ccess 9atabase 4rom the &897reparatio2,pe2 the =isio 4i0e created i2 7art $ o4 this 0ab3 1ou wi00 re4ere2ce this 4i0e i2 7art B.Step !: Start (S $ccess a2d ,pe2 a #ew B0a2k 9atabase.a. +reate a 2ew B0a2k 9atabaseL re4er to the .eek 2 %ab 4or more detai0ed i2structio2s.b. Save the database as Hour#ame%ab:.c. #ote: I4 1ou are u2sure how to comp0ete a21 steps i2 this i%ab3 re4er to the previous weekMs i%abs.Step 2: +reate the *ab0esa. Based o2 the =isio diagram 4rom 7art $3 create the tab0es 4or 1our database.b. &2ter the 4ie0d 2ames a2d the data t1pe.c. 9esig2ate the primar1 ke1s 4or each tab0ed. Set the attribute properties as 2eeded 4ora. "ie0d 0e2gthb. 8eGuiredStep :: +reate the re0atio2shipsa. ,pe2 the database re0atio2ships wi2dow.b. Based o2 the =isio diagram 4rom 7art $3 create the re0atio2ships 4or 1our database.c. Be sure to e24orce re4ere2tia0 i2tegrit1 4or each re0atio2ship.Save 1our 4i0e.&2d o4 7art Bhttp://www.homeworkmotivator.com/product/bis-245-week-#-lab-visio-erd BIS 245 .&&E 4 %$B F &8 9I$58$(7age ! o4 5$. %ab N : BSB$ BIS245$-4$B. %ab 4$ o4 ?: 9atabase desig2 based o2 data reGuireme2ts a2d busi2ess ru0es 4ocusi2g o2 i2terpreti2g busi2ess ru0es to determi2e re0atio2ships.+. %ab ,verview FSce2ario/Summar1*+,)s-:!. 5ive2 a busi2ess situatio2 i2 which ma2agers reGuire i24ormatio2 4rom a database3 determi2e3 a2a01ze a2d c0assi41 that i24ormatio2 so that reports ca2 be desig2ed to meet the reGuireme2ts.2. 5ive2 a situatio2 co2tai2i2g e2tities3 busi2ess ru0es3 a2d data reGuireme2ts3 create the co2ceptua0 mode0 o4 the database usi2g a database mode0i2g too0.Sce2ario:Hou have bee2 asked to create a database mode0 usi2g (S =isio 9atabase (ode0 9iagram *emp0ate. *he purpose o4 this 0ab is to provide eCperie2ce desig2i2g3 with 0imited i2structio2s3 a simp0e database based o2 a 0ist o4 data reGuireme2ts a2d associated busi2ess ru0es.6po2 comp0eti2g this 0ab3 1ou wi00 be ab0e to!. create a 2ew =isio 4i0e 4or database desig2L a2d2. usi2g the data reGuireme2ts a2d the busi2ess ru0es provided3 deve0op a co2ceptua0 mode0 )&89-3 i2c0udi2g attribute data t1pes a2d reGuired 4ie0d 0e2gths.9. 9e0iverab0esSectio29e0iverab0e7oi2tsStep >Hour#ame%ab4$.vsd )=isio 9iagram-&. %ab Steps7reparatio2!. 6si2g +itriC 4or (S =isio a2d/or (S $ccessa. I4 1ou are usi2g the +itriC remote 0ab3 4o00ow the 0ogi2 i2structio2s 0ocated i2 the i%ab tab i2 +ourse Iome.2. Start =isioa. ,pe2 (icroso4t ,44ice 2B!B3 =isio app0icatio23 or7age 2 o4 5b. i4 1ou are usi2g +itriC3 c0ick o2 (icroso4t ,44ice 2B!B $pp0icatio2s 4o0der to start =isio.%ab:Step !: Ide2ti41 a2d create the e2titiesa. ,pe2 a 2ew b0a2k 9atabase (ode0 9iagram. I4 1ou 2eed assita2ce with this3 re4er to the .eek ! %ab I2structio2s. Be sure that a00 optio2s are set co2siste2t to those used i2 previous weeks so that 1ou ge2erate 1our mode0 i2 +rows "oot 2otatio2.b. Save the 4i0e as Hour#ameJ%ab4$.vsd.c. Based o2 the i24ormatio2 provided be0ow3 create the 2ecessar1 e2tities 4or the +ateri2g b1 +are2 database. I4 1ou 2eed assista2ce to create the e2tities3 re4er to %abs 4rom .eeks ! a2d 2.+ateri2g b1 +are2+ateri2g b1 +are2 is a2 upsca0e cateri2g compa21 4ocusi2g o2 4u003 4our-course gourmet di22ers 4or groups 4rom two to 4ort1. ,w2er/che4 Oames +are2 is wo2der4u0 i2 the kitche23 but has become overwhe0med with the busi2ess side o4 ru22i2g his rapid01 growi2g operatio2. Hou have bee2 hired as his busi2ess ma2ager3 a2d 1ouMve decided to computerize i24ormatio2 o2 the e2gageme2ts.+he4 +are2 is eCcited about this pro/ect a2d has provided 1ou with the 4o00owi2g i24ormatio2. Ie does2Mt k2ow databases 2ear01 as we00 as he k2ows haute cuisi2e3 so the data reGuireme2ts are 2ot we00-orga2ized3 2or is data i2 its sma00est parts. Ie has 2oted whether the me2u items are appetizers3 sa0ads3 mai2 courses3 or desserts. Ie has a0so provided a 0ist o4 the i24ormatio2 he keeps o2 each customer a2d each booki2g.B1 ta0ki2g with +he4 +are23 1ou 4ee0 1ou have e2ough i24ormatio2 o2 the compa21Ms busi2ess ru0es to u2dersta2d the re0atio2ships betwee2 the data. +he4 +are2 is particu0ar01 co2cer2ed that 1ou capture the eCact reGuireme2ts 4or the me2u 4or each e2gageme2t. "or i2sta2ce3 i4 2B peop0e are to be served3 he wa2ts to k2ow how ma21 wa2t the vegetaria2 mai2 course3 the Eosher mea0s3 a2d so 4orth.$t this poi2t3 1ou are goi2g to use the 4o00owi2g i24ormatio2 to put together a2 e2tit1 re0atio2ship diagram that 1ou wi00 the2 use with +he4 +are2 to veri41 that 1ou have accurate01 captured the reGuireme2ts.7age : o4 5+ustomers#ame7ho2e$ddress&-mai0 $ddress$pproved 4or credit or 2ot&2gageme2ts9ate*ime%ocatio2(e2u#umber o4 $tte2deesSpecia0 9iet 70ates$ssista2t +he4 $ssig2ed&mp0o1ees $ssig2ed7a1me2t (ethod )$m&C3 =isa3 (aster+ard3 +heck3 +ash3 Bi00-9eposit $mou2t9eposit 7aid 9ate*ota0 +hargesBa0a2ce 7aid 9ate(e2u ItemsItem #ame9escriptio2+0assi4icatio2 )$ppetizer3 Sa0ad3 (ai2 +ourse3 9essert-Specia0 9iet Item )Eosher3 =egetaria2-&mp0o1ees#ame7ositio2#,*&: Hou ma1 4i2d it he0p4u0 to co2sider the busi2ess ru0es i2 Step 4 i2 creati2g 1our e2tities.Step 2: Ide2ti41 a2d create attributes )4ie0ds-#,*&: Because 1ou are creati2g 1our diagram i2 =isio3 it wi00 be easier to create the attributes prior to the re0atio2ships.a. 8e4er to the data reGuireme2ts 4rom Step ! o4 this 0ab. I4 1ou have 2ot a0read17age 4 o4 5created the attributes )4ie0ds- i2 1our &893 add them at this time.b. Save 1our 4i0e a2d co2ti2ue to Step :.Step :: Ide2ti41 a2d desig2ate the ke1sa. 9etemi2e whether a2 attribute eCists i2 each tab0e that wi00 satis41 the reGuireme2ts o4 a primar1 ke1. I4 2o appropriate 4ie0d eCists3 create a 4ie0d 4or this purpose.b. +heck the 7rimar1 Ee1 propert1 4or the 4ie0d)s- i2 each tab0e usi2g the =isio co0um2 properties.Step 4: Ide2ti41 the re0atio2shipsa. 6si2g the i24ormatio2 be0ow o2 the busi2ess ru0es 4or +ateri2g b1 +are23 create the re0atio2ships betwee2 the e2tities created i2 Steps ! a2d 2.b. #otice that3 where (a21-to-(a21 re0atio2ships eCist3 1ou wi00 2eed to create associative e2tities. I4 1ou are 2ot sureo4 the process to create re0atio2ships i2 =isio3 re4er to the %abs 4or .eeks ! a2d 2. Hou created a2 associative e2tit1 i2 .eek 2.c. "or a21 associative e2tities created3 e2ter 2ecessar1 4ie0ds. Hou ma1 a0so 2eed to desig2ate or create a primar1 ke1. #,*&: I4 the re0atio2ship is ma2dator1 )must have at 0east o2eP- 1ou wi00 go to the re0atio2ship (isce00a2eous propert1 a2d cha2ge it 4rom Qero to (a21 to ,2e to (a21.B6SI#&SS 86%&SBusi2ess ru0es he0p determi2e the re0atio2ships betwee2 data that shou0d he0p 1ou desig2 the re0atio2ships betwee2 1our e2tities.!. &ach customer ca2 book ma21 e2gageme2ts over time3 but each e2gageme2t is p0aced b1 o201 o2e customer.2. ,2e assista2t che4 is assig2ed to each e2gageme2t. $2 assista2t che4 ma1 work ma21 e2gageme2ts over time3 but each e2gageme2t wi00 have o201 o2e assista2t che4 assig2ed.:. &ach e2gageme2t wi00 have ma21 me2u items. &ach me2u item ma1 be served at ma21 e2gageme2ts. .he2 a me2uitem is se0ected3 the 2umber o4 servi2gs reGuired 4or the eve2t must be recorded. )Ii2t: 8emember that a2 associativee2tit1 ma1 have attributesK-4. &ach e2gageme2t must have at 0east o2e assista2t che4 assig2ed. *here ma1 be ma21 other emp0o1ees assig2ed to the e2gageme2t. &ach emp0o1ee ma1 work ma21 e2gageme2ts. Iowever3 some emp0o1ees 2ever work e2gageme2ts.5. ,201 o2e e2gageme2t ma1 be schedu0ed 4or a21 particu0ar date a2d time.7age 5 o4 5Step 5: 9etermi2e a2d speci41 the data t1pesa. 6si2g the i24ormatio2 be0ow se0ect the data t1pe 4or each attribute )4ie0d- i2 1our diagram3 a2d set the t1pe i2 the attribute properties. )8e4er to the .eek 2 %ab i4 1ou are 2ot sure how to do this. .here a00owed3 estimate the 4ie0d 0e2gth 2eeded.-$s the data t1pes a2d 4ie0d 0e2gths are 2ot i2c0uded i2 the data reGuireme2ts3 1ou shou0d make a se0ectio2 based o2 1our k2ow0edge o4 the t1pe o4 data a2d approCimatio2 o4 0e2gth reGuired. *he =isio eGuiva0e2ts are show2 be0ow$ccess=isio#umberI2teger*eCt*eCt(emo%o2g*eCt9ate/*ime9ate*ime+urre2c1+urre2c1Hes/#oBi2ar1$uto#umber%o2gI1per0i2k#o eGuiva0e2tRuse *eCtStep >: (odi41 the =isio Setti2gs to show the 9ata t1pe a2d 4ie0d size i2 the diagram.a. +ha2ge 1our =isio setti2gs so that the data t1pe a2d 4ie0d size appear o2 the actua0 diagram. I4 1ou are u2sure o4 thesteps to do this3 re4er to the .eek : %ab.b. Be sure to save the 4i2a0 versio2 o4 1our 4i0e.http://www.homeworkmotivator.com/product/bis-245-week-4-lab-er-dia$ram BIS 245 .&&E 5 %$B F &8 9I$58$( $#9 &8 ($*8I'$. %ab N : BSB$ BIS245$-5$B. %ab 5$ o4 ? : 9atabase desig2 usi2g =isio3 a2d based o2 data reGuireme2ts a2d busi2ess ru0es 4ocusi2g o2 2orma0izi2g data to third 2orma0 4orm.+. %ab ,verviewFSce2ario/Summar1:*+,)s-:2. 5ive2 a situatio2 co2tai2i2g e2tities3 busi2ess ru0es3 a2d data reGuireme2ts3create the co2ceptua0 mode0 o4 the database usi2g a database mode0i2g too0.Sce2ario:Hou have bee2 asked to create a database mode0 usi2g the (S =isio 9atabase (ode0 9iagram *emp0ate. *he purpose o4 this 0ab is to provide eCperie2ce 2orma0izi2g the database to third 2orma0 4orm based o2 0imited i2structio2s3 data reGuireme2ts3 a2d associated busi2ess ru0es.6po2 comp0eti2g this 0ab3 1ou wi00 be ab0e to!. create a 2ew =isio 4i0e 4or database desig2L a2d2. usi2g the data reGuireme2ts a2d the busi2ess ru0es provided3 deve0op a co2ceptua0 mode0 )&89-3 i2c0udi2g attribute data t1pes a2d reGuired 4ie0d 0e2gths.9. 9e0iverab0es Sectio2 9e0iverab0e 7oi2tsStep ! Hour#ameJ%ab5$J&8(atriC.docCStep : Hour#ame%ab5$.vsd )=isio 9iagram-&. %ab Steps7reparatio2!. 5et the %ab5$J&8(atriC.docC docume2t 4rom 9oc Shari2g:a. 9ow20oad the %ab5$J&8(atriC docume2t 4i0e 4rom 1our course 9ocShari2g pa2e0 )%abs view-3 a2d Save the 4i0e to 1our 0oca0 drive.2. 6si2g +itriC 4or (S =isio a2d/or (S $ccessa. I4 1ou are usi2g the +itriC remote 0ab3 4o00ow the 0ogi2 i2structio2s 0ocated i2 the i%ab tab i2 +ourse Iome.:. Start (S =isioa. ,pe2 (icroso4t ,44ice3 =isio app0icatio23 orb. i4 1ou are usi2g +itriC3 c0ick o2 (icroso4t ,44ice $pp0icatio2s 4o0der to start =isio. 7age 2 o4 5 %abStep !: Ide2ti41 the e2tities a2d re0atio2ships.a. ,ver the past 4our weeks3 1ou have created &89s based o2 i24ormatio2 provided. *his week3 1ou wi00 comp0ete the &89 bei2g sure to 2orma0ize it to :#" )third 2orma0 4orm-. #orma0izatio2 is the s1stematic app0icatio2 o4 ru0es desig2ed to e0imi2ate redu2da2c1 4rom the database. 9ata i2 previous weeks was3 to some eCte2t3 2orma0ized 4or 1ou.*his week3 it is 2ot. $2 abbreviated 0ist o4 the data reGuireme2ts 4o00ows.+o00ege Schedu0i2g 9ata 8eGuireme2tsStude2t I9Stude2t "irst #ameStude2t %ast #ame+ourse +ode+ourse #ame+ourse 9escriptio2+ourse +redit Iours+ourse *ime+ourse 9a1sI2structor I9I2structor "irst #ameI2structor %ast #ame8oom #umber8oom +apacit1b. ,pe2 the .ord 4i0e i2 the .eek 5 %ab (ateria0s3 %ab5$J&8(atriC.docCc. Save the .ord 4i0e as Hour#ameJ%ab5$J&8(atriC.d. $2 &8 (atriC he0ps de4i2e both the e2tities a2d the re0atio2ships betwee2 the e2tities. 6si2g the partia001 comp0eted &8 (atriC be0ow as a guide3 comp0ete the matriC.Ii2t: Hou shou0d e2d up with 4our e2tities.!. %ist each e2tit1 both across a2d dow2.2. 9etermi2e whether a re0atio2ship eCists betwee2 e2tities a2d de4i2e that re0atio2ship with a verb phrase. )#,*&: *he e2tit1 with the greatest 2umber o4 re0ated e2tities is usua001 the ce2ter o4 the &8 diagram.-:. Ide2ti41 mi2imum ),ptio2a0 or (a2dator1- a2d maCimum )o201 o2e3 or o2e or more-.7age : o4 5 Stude2t +ourseStude2t 2o2e &2ro00s i2L (a2dator1 ,2e or more+ourse Is take2 b1: ,ptio2a0 ,2e or more 2o2ee. Save the comp0eted matriC to submit as part o4 1our 0ab.Step 2: +reate the i2itia0 &89 based o2 the matriC.a. ,pe2 a 2ew b0a2k 9atabase (ode0 9iagram i2 =isio. I4 1ou 2eed assita2ce with this3 re4er to the .eek ! %ab I2structio2s. Be sure that a00 optio2s are set co2siste2t to those used i2 previous weeks so that 1ou ge2erate 1our mode0 i2 +rowMs "oot 2otatio2.b. ,2e o4 the issues i2 de2orma0ized data is that it ca2 resu0t i2 ma21-to-ma21 re0atio2ships that are 2ot compatib0e with the re0atio2a0 database. =isio does 2ot a00ow creatio2 o4 a ma21-to-ma21 re0atio2ship because o4 this i2compatibi0it1. *here4ore3 4or a21 ma21-to-ma21 re0atio2ships i2 1our data3 1ou wi00 2eed to create two o2e-to-ma21 re0atio2ships. See the eCamp0e be0ow:7age 4 o4 5c. Based o2 the i24ormatio2 4rom Step !3 create the i2itia0 &89 4or the +o00ege Schedu0i2g database i2c0udi2g the ma21-to-ma21 re0atio2ships. I4 1ou 2eed assista2ce to create the e2tities3 re4er to 0abs 4rom .eeks ! a2d 2.d. $ssig2 the primar1 ke1s a2d attributes 4rom the data reGuireme2ts to the proper e2tities.e. Save the 4i0e as Hour#ameJ%ab5$.vsd.Step :: #orma0ize the databasea. .hi0e the i2itia0 &89 is accurate3 i4 1ou desig2 a database without deviati2g 4rom it3 1ou wi00 e2cou2ter prob0ems. "or eCamp0e3 a course is o44ered ma21 times. I4 1ou use the course code3 4or eCamp0e BIS2453 as the primar1 ke13 1ou wi00 o201 be ab0e to 0ist the course o2ce. *here are three possib0e so0utio2s.!. $ssig2 a2other primar1 ke13 such as a2 auto-2umber 4ie0d3 so that the course ca2 be 0isted mu0tip0e times. Iowever3this is 2otacceptab0e because it i2troduces redu2da2c1 rather tha2 reduci2g it.2. 6se a composite primar1 ke1 co2sisti2g o4 the +ourse +ode a2d the Sectio2 code. I4 1ou create a u2iGue sectio2 code )&'$(7%&: Hear*ermJSectio2 or 2B!BSpri2g$J$-3 the2 1ou ca2 0ist the course repeated01. $gai23 this i2troduces redu2da2c13 a2d is 2ot a2 acceptab0e so0utio2.:. Sp0it the tab0e to create two tab0es. *o sta1 co2siste2t with 9e=r1 termi2o0og13 create a seco2d Sectio2 tab0e. *o e2sure that a course is 2ot e2tered twice3 1ou might modi41 the Sectio2 code to i2c0ude the course: BIS245J2B!BSpri2g$J$. B1 co2siste2t01 usi2g this 4ormat3 1ou shou0d 2ot be ab0e to dup0icate the sectio23 a2d ca2 avoid a comp0icated composite ke1. Iowever3 as the Sectio2 tab0e wi00 serve as a2 associative e2tit13 it is acceptab0e to borrow the primar1 ke1s o4 the pare2t tab0es.b. ,pe2 the =isio 4i0e 4rom Step 23 a2d add a 2ew page. +ha2ge the page tab to read 8evised. 8evise the i2itia0 &89 based o2 the 4o00owi2g i24ormatio2.!. $ +ourse ma1 eCist without bei2g o44ered. It eCists i2 the cata0og.+ourses are schedu0ed 4or a term a2d give2 a sectio2. It is the schedu0e course )Sectio2- that stude2ts e2ro00 i23 that are schedu0edi2 rooms a2d assig2ed i2structors.2. $ Stude2t ca2 eCist without bei2g e2ro00ed i2 a course.:. $2 I2structor ca2 eCist without bei2g assig2ed to teach a course.4. $ 8oom ca2 eCist without bei2g schedu0ed 4or a course.c. Save the 4i0e with 1our revised &89.7age 5 o4 5%ab 5$ "i2a0 9e0iverab0esa. Hour#ameJ%ab5$J&8(atriC.docC ).ord 9ocume2t- 4rom %ab 5$ Step !b. Hour#ameJ%ab5$.vsd )=isio 9iagram- 4rom %ab 5$ Step :.Submit these 4i0es to the .eek 5 i%ab 9ropboC. ," %$Bhttp://www.homeworkmotivator.com/product/bis-245-week-5-lab-er-dia$ram-and-er-matrix BIS 245 .&&E > I%$B +8&$*I#5 8&7,8*SBIS 245 9atabase &sse2tia0s 4or Busi2ess with %abA. Lab # BSBA BIS245A-6B. Lab 6 of 7 : Creain! "e#orsC. Lab $%er%ie& ' Scenario ( Su))ar*:*+,)s-: ?. 5ive2 a database app0icatio2 with a comp0eted re0atio2a0 schema3 popu0ated tab0es3 a2d busi2ess reporti2g reGuireme2ts3 create the 2ecessar1 reports a2d make a busi2ess decisio2.Scenario: *he purpose o4 this 0ab is to create $ccess 8eports. $4ter a report is created3 the stude2t wi00 sort the 4ie0ds i2 di44ere2t wa1s. $0so the Stude2t ca2 a0so de0ete 4ie0ds i2 0a1out view a2d modi41 the appeara2ce o4 the report b1 app01i2g *hemes. I2 additio2 to the report ge2erated b1 $ccess3 the 0ab a0so uses 8eport 9esig2 to a00ow users to desig2 their ow2 reports. 6po2 comp0eti2g this 0ab3 1ou shou0d be ab0e to:S +reate a report a2d app01 a theme 4or pro4essio2a0 appeara2ce o4 the report.S 6se 8eport 9esig2 to ge2erate 1our ow2 report.D. Deli%erables: 6p0oad the modi4ied %ab>JStart.accdb 4i0e that 1ou saved as Hour#ameJ%ab>.accdb to the .eek > i%ab 9ropboC.+ar A Se# ,: Creae a Si)#le "e#or ' Lab6-"e#or,+ar A Se# 2: Creae a re#or usin! "e#or Desi!n ' Lab6-"e#or2+ar A Se# .: Creain! /uli-able "e#ors ' Lab6-"e#or.+ar A Se# 4: A00in! a Subre#or ' Lab6-"e#or4+ar A Se# 5: Creae /ailin! Labels ' Lab6-"e#or5+ar B Se# ,: Creae a "e#or ' Lab6-"e#or6+ar B Se# 2: Creae a /uli-able "e#or ' Lab6-"e#or71#:((&&&.1o)e&ork)oi%aor.co)(#ro0uc(bis-245-&eek-6-ilab-creain!-re#ors BIS 245 .&&E ? I%$B1#:((&&&.1o)e&ork)oi%aor.co)(#ro0uc(bis-245-&eek-7-ilab BIS245 .&&E 2 %$B - SEI%%S 9&=&%,7(* I# =ISI,A. Lab # : BSBA BIS245A-2B. Lab 2 of 7 : Ski00s 9eve0opme2t i2 =isioL +reatio2 o4 (S $ccess 9atabaseC. Lab $%er%ie&'Scenario ( Su))ar*:*+,s:!. 5ive2 a busi2ess situatio2 i2 which ma2agers reGuire i24ormatio2 4rom a database3 determi2e3 a2a01ze3 a2d c0assi41that i24ormatio2 so that reports ca2 be desig2ed to meet the reGuireme2ts.2. 5ive2 a situatio2 co2tai2i2g e2tities3 busi2ess ru0es3 a2d data reGuireme2ts3 create the co2ceptua0 mode0 o4 the database usi2g a database mode0i2g too0.:. 5ive2 a2 eCisti2g re0atio2a0 database schema3 eva0uate a2d a0ter the database desig2 4or e44icie2c1.4. 5ive2 a2 eCisti2g database structure demo2strati2g e44icie2c1 a2d i2tegrit13 desig2 the ph1sica0 tab0es.Sce2ario:Hou have bee2 asked to create a co2ceptua0 database mode0 usi2g (S =isio 9atabase (ode0 9iagram *emp0ate. *he purpose o4 this 0ab is to have 1ou gai2 eCperie2ce with the various mode0i2g too0s 2eeded to create a co2ceptua0 mode0)e2tit1 re0atio2ship diagram- o4 a database. Hou wi00 the2 modi41 the mode0 4or imp0eme2tatio2 as a (S $ccess database. Hou wi00 create a2d modi41 o2e co2ceptua0 mode0.Hou wi00 the2 create a (S $ccess database based o2 the mode0 deve0oped i2 =isio3 creati2g the 2ecessar1 tab0es a2d re0atio2ships.6po2 comp0eti2g this 0ab3 1ou wi00 be ab0e to!. re01i2g o2 detai0ed i2structio2s3 add two e2tities to the eCisti2g co2ceptua0 mode0 )&89-3 i2c0udi2g attribute data t1pes a2d reGuired 4ie0d 0e2gthsL2. create a 2ew (S $ccess database 4i0eL:. usi2g the mode0 4rom 7arts $ a2d B o4 the 0ab3 a2d re01i2g o2 detai0ed i2structio2sL create the 4irst two tab0es i2 the databaseL4. use the eCperie2ce gai2ed i2 creati2g the 4irst two tab0es to add the remai2i2g tab0esL5. usi2g the mode0 4rom 7arts $ a2d B o4 the 0ab3 a2d re01i2g o2 detai0ed i2structio2sL create the re0atio2ship betwee2 the 4irst two tab0es i2 the databaseL a2d>. use the eCperie2ce gai2ed i2 creati2g the 4irst re0atio2ship to create the remai2i2g re0atio2ships betwee2 the tab0es.http://www.homeworkmotivator.com/product/bis245-week-2-lab--skills-development-in-visio %omewrok&otivator.com