Bis 245 Week 4 Lab – Er Diagram

Front 1

BIS 245 Week 4 Lab – ER Diagram

Back 1

Page 1 of 5

A. Lab # : BSBA BIS245A-4A

B. Lab 4A of 7: Database design based on data requirements and business rules focusing on interpreting business rules to determine relationships.

C. Lab Overview –Scenario/Summary

TCO(s):

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.

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.

Upon completing this lab, you will be able to

1. create a new Visio file for database design; and

2. using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths.

D. Deliverables

Section

Deliverable

Points

Step 6

YourNameLab4A.vsd (Visio Diagram)

E. Lab Steps

Preparation

Front 2

Get more answer for your homework and exam at www.homeworkstudent.com

Back 2

http://www.homeworkstudent.com/products/bis-245?pagesize=12

Front 3

Get more answer for your homework and exam at www.homeworkstudent.com

Back 3

http://www.homeworkstudent.com/products/bis-245?pagesize=12