• 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 3 Lab – Visio ERD

A+BIS 245 Week 3 Lab – Visio ERD

Part A: Create a Visio ERD from Data Requirements and Business Rules


Step 1: Open Visio


a. Open Microsoft Office, Visio application or


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


Step 2: Identify and create the entities


a. Open a new blank Database Model Diagram.


b. Save the file as YourName_Lab3.vsd.


c. Based on the information provided below, create the necessary entities for the Pages in Time database. If you need assistance to create the entities, refer to labs from Weeks 1 and 2.


Pages in Time


Pages in Time is a small bookstore carrying a variety of books. The owners have decided to computerize the books available through the store so that they can determine more easily what books are on hand and which books need to be special ordered to meet customer needs. Because customers do not always remember the name of a desired book, the owners want to be able to look for books by author or by type (genre). They also want to be able to find the publisher�s information using the system so that they can order books more easily.


After visiting with the owners, you have gathered the following information on data requirements and business rules to develop a


conceptual design (ERD), prepare it for conversion to an Access database, and then create the actual database.


DATA REQUIREMENTS


You have determined that you will need at least the following entities to resolve the relationships that exist in the data.


CUSTOMERS


ID


Name (store data in its smallest parts)


Phone


Address (store data in its smallest parts)


Phone Number


E-mail Address


Preferred Contact Method


ORDERS


Number


Date


Received Date


Customer Contacted (Yes or No)


BOOKS

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