BIS 245 Week 2 Lab – Skills Development in Visio

BIS 245 Week 2 Lab – Skills Development in Visio

  1. Lab # : BSBA BIS245A-2
  2. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database
  3. 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.


BIS 245 All 7 Weeks Discussions

Week 1 DQ 1 – Databases and Gathering Requirements
Week 1 DQ 2 – Choosing a Database
Week 2 DQ 1 – Entity Relationship (ER) Modeling
Week 2 DQ 2 – Database Table Design
Week 3 DQ 1 – Conceptual Database Design
Week 3 DQ 2 – Requirements Analysis
Week 4 DQ 1 – Creating Queries from woodcraft Database
Week4 DQ 2 – Creating Queries from NorthWeekind Database
Week 5 DQ 1 – Data Normalization
Week 5 DQ 2 – Data Validation
Week 6 DQ 1 – Data Reporting
Week 6 DQ 2 – Presenting Data Effectively
Week 7 DQ 1 – Database Navigation
Week 7 DQ 2 – Database Security
BIS 245 Week 1 Lab


Follow this link to get a similar paper written from scratch
Place an order for this assignment or any other paper with us. We guarantee that the paper will be delivered within the specified deadline. We also have a personalized customer support and you will be able to communicate with your writer throughout the order preparation process. Thank you for choosing us.


Have troubles with paper writing? You’ve found the right paper writing company! We are the leading essay writing services that provides quality papers for a reasonable price. On our website, you can order various assignments. Our work is 100% original. We write your essay from scratch, according to the exact specifications of your assignment. We guarantee it will pass any plagiarism check

Get Your Papers Completed by Expert Writers

Order essays, term papers, research papers, reaction paper, research proposal, capstone project, discussion, projects, case study, speech/presentation, article, article critique, coursework, book report/review, movie review, annotated bibliography, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch


Related Posts

© All Right Reserved