Week 5 iLab for evagat

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