• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/3

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

3 Cards in this Set

  • Front
  • Back
A+BIS 245 Week 4 Lab – ER Diagram

A+BIS 245 Week 4 Lab – ER Diagram

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


1. Using Citrix for MS Visio and/or MS Access


a. If you are using the Citrix remote lab, follow the login instructions located in the iLab tab in Course Home.


2. Start Visio


a. Open Microsoft Office 2010, Visio application, or


Page 2 of 5


b. if you are using Citrix, click on Microsoft Office 2010 Applications folder to start Visio.


Lab:


Step 1: Identify and create the entities


a. Open a new blank Database Model Diagram. If you need assitance with this, refer to the Week 1 Lab Instructions. Be sure that all options are set consistent to those used in previous weeks so that you generate your model in Crows Foot notation.

full answers :

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

homeworkstudent.com is a commerical website helps the students in assignment solutions. High Quality, Fresh Online Study and more

homeworkstudent.com is a commerical website helps the students in assignment solutions. High Quality, Fresh Online Study and more