Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | May 2017 |
Last Sign in: | 248 Weeks Ago, 6 Days Ago |
Questions Answered: | 19234 |
Tutorials Posted: | 19224 |
MBA (IT), PHD
Kaplan University
Apr-2009 - Mar-2014
Professor
University of Santo Tomas
Aug-2006 - Present
A.Lab #:BSBA BIS245A-5A
B.Lab 5A of7:Databasedesign usingVisio,andbased ondatarequirements andbusinessrules focusingonnormalizingdatatothirdnormalform.
C.Lab Overview—Scenario/Summary:
TCO(s):
2.Givenasituationcontaining entities,business rules,anddatarequirements, createtheconceptualmodel ofthedatabaseusinga databasemodelingtool.
Scenario:
You havebeenaskedtocreatea databasemodelusing the MSVisioDatabase ModelDiagram Template. Thepurpose ofthis iLabis toprovideexperience normalizing thedatabasetothirdnormalformbasedonlimitedinstructions,data requirements,andassociatedbusinessrules.
Uponcompleting this iLab,youwillbeableto
1.create a new Visio file fordatabasedesign;and
2.usingthedatarequirementsandthebusinessrulesprovided,developa conceptualmodel(ERD), includingattribute datatypesandrequiredfield lengths.
D.Deliverables
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.-----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- Â -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll