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: | 393 Weeks Ago, 3 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-----------