Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Apr 2017 |
Last Sign in: | 3 Weeks Ago, 6 Days Ago |
Questions Answered: | 7559 |
Tutorials Posted: | 7341 |
BS,MBA, PHD
Adelphi University/Devry
Apr-2000 - Mar-2005
HOD ,Professor
Adelphi University
Sep-2007 - Apr-2017
iLab 5a:Â Database Design using Visio, and Based on Data Requirements and Business Rules Focusing on Normalizing Data to Third Normal Form
*See Attached for all necessary files to successfully complete this assignment.Â
Â
iLab 5b: Completing Forms
Â
Part A:Â You have been asked to create a database model using the MS Visio Database Model Diagram Template. The purpose of this lab is to provide experience normalizing the database to third normal form based on limited instructions, data requirements, and associated business rules.
Upon completing this lab, you will be able to:
create a new Visio file for database design; and
using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths.
Â
Part B:Â The lab begins with creating a form in Access using the Form Wizard. After the form is created, the user can use Themes to change the appearance of the form. The second part of the lab uses Form Design to create a form. Finally, the form will be customized.
Upon completing this lab, you should be able to:
create a form using the Form Tool;
create a form using Form Design; and
create a form using the Form Wizard.
Â
Deliverables
Part A:Â Step 1: YourName_Lab5A_ERMatrix.docx
Part A:Â Step 3: YourName_Lab5A.vsd (Visio Diagram)
Â
Part B:Â Step 7: YourName_Lab5B_Final.accdb (Access Database)
BIS----------- 34-----------5 L-----------AB -----------5 a-----------ssi-----------gnm-----------ent----------- BI-----------S 3-----------45 -----------LAB----------- 5 -----------ass-----------ign-----------men-----------t B-----------IS -----------345----------- LA-----------B 5----------- as-----------sig-----------nme-----------nt -----------BIS----------- 34-----------5 L-----------AB -----------5 a-----------ssi-----------gnm-----------ent----------- BI-----------S 3-----------45 -----------LAB----------- 5 -----------ass-----------ign-----------men-----------t B-----------IS -----------345----------- LA-----------B 5----------- as-----------sig-----------nme-----------nt -----------BIS-----------