BIS 245 Week 1 Lab Assignment

BIS 245 Week 1 Lab Assignment | Devry University

BIS 245 Week 1 Lab

Week 1: Lab Overview

TABLE OF CONTENTS

Lab Overview

Scenario/Summary

You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will create two conceptual models.

You will then open an existing Access database to explore database objects, and to experiment with simple data manipulation using filters and sorts, and to begin elementary work with relationships.

Upon completing this lab, you will be able to do the following.

·         Relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio.

·         Use experience gained in creating the first model to construct a similar conceptual model without the instructions.

·         Download an existing Microsoft Access database file. Open the database, find and identify different database objects in this database.