BIS245, BIS 245 Week 5, BIS 245 iLab 5, BIS 245 Lab 5 - ER Diagram and ER Matrix
    BIS245, BIS 245 Week 5, BIS 245 iLab 5, BIS 245 Lab 5 - ER Diagram and ER Matrix BIS245, BIS 245 Week 5, BIS 245 iLab 5, BIS 245 Lab 5 - ER Diagram and ER Matrix BIS245, BIS 245 Week 5, BIS 245 iLab 5, BIS 245 Lab 5 - ER Diagram and ER Matrix

BIS245, BIS 245 Week 5, BIS 245 iLab 5, BIS 245 Lab 5 - ER Diagram and ER Matrix

$18.99

A. Lab # : BSBA BIS245A-5A
B. Lab 5A of 7 : Database design using Visio, and based on data requirements
and business rules focusing on normalizing data to third normal form.
C. Lab Overview–Scenario/Summary:
TCO(s):
2. Given a situation containing entities, business rules, and data requirements,
create the conceptual model of the database using a database modeling tool.
Scenario:
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
1. create a new Visio file for database design; and
2. using the data requirements and the business rules provided, develop a
conceptual model (ERD), including attribute data types and required field
lengths.
D. Deliverables
Section Deliverable Points
Step 1 YourName_Lab5A_ERMatrix.docx
Step 3 YourNameLab5A.vsd (Visio Diagram)

A.
Lab # : BSBA BIS245A-5B
B.
Lab 5B of 7: Completing Forms
C.
Lab Overview–Scenario/Summary
TCO(s):
5.
Given a physical database containing tables and relationships, create
forms
which demonstrate effective user-interface design and allow for
efficient
entry and retrieval of data.
Scenario/Summary
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.
D.
Deliverables
Submit
the MS Access Database file that contains the forms created in this
lab.