Submitted by: Submitted by lawrencee138
Views: 10
Words: 282
Pages: 2
Category: Other Topics
Date Submitted: 07/14/2015 02:41 AM
DeVry BIS 245Week 3 ILAB Database Design Using Visio and Based on Data Requirementsand Business Rules
IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download
http://www.hwspeed.com/DeVry-BIS-245-Week-3-ILAB-Database-Design-7474938498.htm?categoryId=-1
If You Face Any Problem E- Mail Us At JOHNMATE1122@Gmail.Com
A.Lab # : BSBA BIS245A-3
B.Lab 3 of 7:Database Design Using Visio and Based on Data Requirementsand Business Rules
C.Lab Overview--Scenario/Summary
TCOs:
2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.
3. Given an existing relational database schema, evaluate and alter the database design for efficiency.
4. Given an existing database structure demonstrating efficiency and integrity, design the physical tables.
Scenario
You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this lab is to provide experience designing, with limited instructions, a simple database based on a list of data requirements and associated business rules.
You will then complete an MS Access database based on the model developed in Visio, creating the necessary tables and relationships.
Upon completing this lab, you will be able to
1. create a new Visio file for database design;
2. using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and
3. create a new MS Access database based on the ERD.
D. Deliverables
Section Deliverable Points
Part A Step YourNameLab3.vsd (Visio Diagram)
7
Part B Step YourNameLab3.accdb (Access Database)
3
E. Lab Steps
Page1 of 6