BIS 245 Week 2 ilab

Share on facebook
Share on whatsapp
Share on twitter
Share on pinterest
Share on linkedin
Share on reddit
Share on skype
Share on email

A. Lab # : BSBA BIS245A-2

B. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database

C. Lab Overview–Scenario / Summary:


1. Given a business situation in which managers require information from a database, determine, analyze, and classify that information so that reports can be designed to meet the requirements.

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.


You have been asked to create a conceptual database model using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain experience with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will then modify the model for implementation as a MS Access database. You will create and modify one conceptual model.

You will then create a 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. relying on detailed instructions, add two entities to the existing conceptual model (ERD), including attribute data types and required field lengths;

2. create a new MS Access database file;

3. using the model from Parts A and B of the lab, and relying on detailed instructions; create the first two tables in the database;

4. use the experience gained in creating the first two tables to add the remaining tables;

5. using the model from Parts A and B of the lab, and relying on detailed instructions; create the relationship between the first two tables in the database; and

6. use the experience gained in creating the first relationship to create the remaining relationships between the tables.


do you want to boost your grades? yes?

stop thinking we are eager to help you out

Payment Methods


  • +1 (781) 656-7669
  • Blog
  • Reviews
  • Library
  • Contact
  • About Us
  • How It Works
  • DMCA Policy
  • Refund Policy
  • Cookie Policy
  • Privacy Policy
  • Terms of Services
  • Take My Online Class
  • Do My Homework
  • MyMathLab Answers
  • MyStatLab Answers
  • MyAccountingLab Answers
  • CPM Homework Help
  • Math Homework Help
  • Online Homework Helper
  • Pay To Take Online Class
  • Finance Assignment Help
  • Online Final Exams Help
  • Take WIC Online Class
  • Coursework Writing Service
  • Buy Research Paper
  • Thesis Writing Service
  • Dissertation Writing Service
  • Course Project Help
  • Case Study Help
  • College Paper Writing Service
  • Do My Statistics Homework
  • Essay Writing Service
  • Economics Homework Help
  • Programming Homework Help
  • English Homework Help
  • Online Test Takers
  • Take My Online Quiz
  • Paid Service Online Class Help
  • Help With My Online Class
  • Online Business Class Help
  • Take My Online Lab
  • Algebra Homework Help
  • College Homework Help
  • MBA Assignment Help
  • Disclaimer: The services provided are meant to assist the buyer by providing a guideline and the product provided is intended to be used for research or study purposes.
Scroll to Top