Create database model using MS Visio Database Model

$14.50

Create database model using MS Visio Database Model
Part A: You have been asked to create a database model using MS Visio Database Model Diagram…

SKU: Create database model using MS Visio Database Model Categories: , Tags: , , ,

Description

Create database model using MS Visio Database Model

Create database model using MS Visio Database Model

BIS 245 iLab Week 4 

Scenario/Summary

Part A: You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this iLab is to provide experience designing, with limited instructions, a simple database based on a list of data requirements and associated business rules.

Upon completing this iLab, 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 iLab begins with a simple example of query development using Access; then, evolves to more complex queries which the student should perform after completing the first exercise. Create a query using the wizard with query-design view or with SQL statements. The Northwind (NWind) database will be used again in this iLab.

Upon completing this lab, you should be able to

  • create a query by following lab instruction;
  • create a query by using either Query Designer or Query Wizard;
  • create a query by using SQL statements; and
  • interpret the results of queries.

Part A: YourNameLab4A.vsdx (Visio Diagram)

Part B: YourName_Lab4B_Finital.accdb (Access Database)