The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,High School,College,University
| Teaching Since: | Apr 2017 |
| Last Sign in: | 360 Weeks Ago, 5 Days Ago |
| Questions Answered: | 6064 |
| Tutorials Posted: | 6070 |
Doctor of Education in Educational Leadership with a Specialization in Educational Technology
Phoniex University
Oct-1999 - Nov-2005
HR Executive
a21, Inc.
Nov-1998 - Dec-2005
Microsoft Office: Word 2013, Visio 2013, and Access 2013
A.Lab # :BSBA BIS245A-3
Â
B.Lab 3 of7:Database DesignUsingVisio andBasedonDataRequirements andBusiness Rules
Â
C.Lab Overview—Scenario/Summary
Â
TCOs:
2.Givena situationcontainingentities,business rules,anddatarequirements,create the conceptualmodelof thedatabase usinga database modelingtool.
3.Givenanexisting relational database schema,evaluate andalter the database designforefficiency.
4.Givenanexistingdatabase structuredemonstratingefficiencyandintegrity,designthephysicaltables.
Scenario
You have beenasked to create a database model usingMSVisio DatabaseModel
DiagramTemplate. The purpose of this iLabis to provide experiencedesigning, withlimitedinstructions,a simple database basedona list ofdata requirements andassociated business rules.
Â
Youwillthencomplete an MSAccess database basedonthe modeldevelopedin
Visio,creatingthe necessary tables and relationships.
Â
Uponcompleting this lab,youwillbe able to
1.create a new Visio file for database design;
2.usingthedatarequirementsandthebusinessrulesprovided,developa conceptualmodel(ERD),includingattributedatatypesandrequiredfield
lengths;and
3.create a new MS Access database basedon the ERD.
Â
Â
D.Deliverables
Â
Â
Â
|
Section |
Deliverable |
Points |
|
Part A |
YourNameLab3.vsdx (Visio Diagram) |
 |
|
Part B |
YourNameLab3.accdb(Access Database) |
Sol-----------uti-----------ons----------- fi-----------le ----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I-----------