Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Double sided arrow visio

29/03/2021 Client: saad24vbs Deadline: 2 Day

Once you have learned how to create a Visio Crow’s Foot ERD, you will be suffi ciently

familiar with the basic Visio Professional software features to experiment on your own with

other modeling and diagramming options. You will also learn how to insert text into the Visio

diagram to document features you consider especially important or to simply provide an

explanation of some segment of the ERD.

Note: The screens and instructions in this tutorial are for Microsoft Visio Professional 2010.

If you are using an earlier version of Visio, your screen will vary slightly.

Designing Databases with Visio Professional: A Tutorial

Microsoft Visio Professional is a powerful database design and modeling tool. The Visio software has so many features that it is impossible to demonstrate all of them in this short tutorial. However, you will learn how to:

■ Start Visio Professional.

■ Select the Crow’s Foot entity relationship diagram (ERD) option.

■ Create the entities and defi ne their components.

■ Create the relationships between the entities and defi ne the nature of those relationships.

■ Edit the Crow’s Foot ERDs.

■ Insert text into the design grid and format the text.

A-2 A P P E N D I X A

A.1 Starting Visio Professional

The typical Visio Professional software installation lets you select Visio through the Start, (All) Programs, Microsoft Visio sequence. After the Visio software has been activated, click the Software and Database option to match the screen shown in Figure A.1. (Previously created Visio fi les show up in the Recent Documents header on the right side of the screen.)

FIGURE A.1

The Visio Professional opening screen

SOURCE: Course Technology/Cengage Learning

With the Software and Database selection shown in Figure A.1, select the Database Model Diagram object. Note that your selection results in a highlight around the object. As shown in Figure A.2, you will see the Database Modeling Template description in the right side of your screen.

D E S I G N I N G D A T A B A S E S W I T H V I S I O P R O F E S S I O N A L : A T U T O R I A L A-3

Click the Create button on the right side of the screen as shown in Figure A.2 to begin a new diagram, producing the screen shown in Figure A.3. Because the preference here is for a larger grid than the one shown in Figure A.3, start by selecting the View ribbon at the top of the screen. Click the Zoom option to generate the list of size options. Figure A.4 shows that the 100% option has been selected. When you click the 100% selection and click OK, the grid expands to fi ll the screen.

FIGURE A.2

The database model object selection

SOURCE: Course Technology/Cengage Learning

A-4 A P P E N D I X A

FIGURE A.3

The drawing board

SOURCE: Course Technology/Cengage Learning

D E S I G N I N G D A T A B A S E S W I T H V I S I O P R O F E S S I O N A L : A T U T O R I A L A-5

By selecting the Visio Professional database option and its drawing board, you have completed the preliminary work required to create ERDs. You are now ready to draw the ERDs on the drawing board. You will use the Crow’s Foot option, the same one used to create all of the ERDs in this text.

A.2 Setting The Stage For Creating a Crow’s Foot ERD

To select the Crow’s Foot option, select the Database ribbon, and then click Display Options to display the Database Document Options window shown in Figure A.5. The default selection is the General tab. Note that the default selections in the General tab are Relational and Physical names. Ensure that you have these default options selected.

FIGURE A.4

The drawing board size option

SOURCE: Course Technology/Cengage Learning

A-6 A P P E N D I X A

Select the Relationship tab and click to select the Crow’s feet option as shown in Figure A.6. As you examine the tab, keep in mind that we have not created and named any relationships yet. Therefore, we have not determined how the names will be displayed. You will return to this dialog box later to see the effect of name display options and to demonstrate that you can edit the displays when you are working on the relationships.

FIGURE A.5

The Database Document Options window

SOURCE: Course Technology/Cengage Learning

D E S I G N I N G D A T A B A S E S W I T H V I S I O P R O F E S S I O N A L : A T U T O R I A L A-7

Next, select the Table tab in the Database Document Options dialog box, as shown in Figure A.7. Make sure that the check boxes are marked as shown here, and then click the OK button to begin creating Crow’s Foot ERDs.

FIGURE A.6

The Database Document Options, Relationship tab

SOURCE: Course Technology/Cengage Learning

FIGURE A.7

The Database Document Options, Table tab

SOURCE: Course Technology/Cengage Learning

A-8 A P P E N D I X A

A.2.1 The Business Rules

To illustrate the development of the Visio Professional’s Crow’s ERD, you will create a simple design based on the following business rules:

1. A course can generate many classes.

2. Each class is generated by a course.

3. A course may or may not generate a class.

Note that a class has been defi ned as a section of a course. That defi nition refl ects the real world’s use of the labels class and course. Students have a class schedule rather than a section schedule. The catalog that lists all of the courses offered by a department is called a course catalog. Some courses are not taught each semester, so they may not gener- ate a class during any given semester.

A.3 Creating an Entity

Now that you have some idea of the proposed design components, let’s create the fi rst entity for the design. Click the Entity object shown in Figure A.8. (It is circled in the fi gure.) Drag the Entity object to the grid and then drop it. That action will produce the Table1 object shown in the grid in Figure A.8. (The 1 in the Table1 label indicates that this is the fi rst entity object to be placed on the grid.) Note that the entity object is shown as a table.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Maths Master
Quick Mentor
Pro Writer
Best Coursework Help
Custom Coursework Service
Essay Writing Help
Writer Writer Name Offer Chat
Maths Master

ONLINE

Maths Master

I have read and understood all your initial requirements, and I am very professional in this task.

$31 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

Give me a chance, i will do this with my best efforts

$37 Chat With Writer
Pro Writer

ONLINE

Pro Writer

Give me a chance, i will do this with my best efforts

$42 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$18 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

I have read and understood all your initial requirements, and I am very professional in this task.

$48 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$56 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

200 joules to volts - Video literacy narrative - Cover page of a portfolio - Websphere 9.0 end of support - Triangle shirtwaist fire essay outline - Business - Find all integer solutions to the linear diophantine equation - Kwais meaning in english - Final Retrospective Research Proposal - Essentials of software engineering 4th edition by tsui - Reading summary phi - Ashley purchased a dining room set for - Health policy Final Project Milestone Two: Factual Overview - Types of microscope ppt - The great gatsby chapter 1 4 questions and answers - Josquin des prez music style - Luther starts the reformation - WEEK 3 Discussion Prompt 2 PHARMACOLOGY - 682 228 5439 - Mgb steering rack lubrication - D2l pdx - Queensland department of education director general - How old is betty parris in the crucible - Burke litwin model strengths and weaknesses - Philippa foot killing and letting die summary - Chapter 4 ethical and social issues in information systems - Movies directed by john hughes - Recitational questioning - Challenger sales training certification - What is sub saharan africa's largest lake - Homework help - Smiley face sponge shark tank - Network Design - The farm inside angola prison update - Bertocchi peking pork how to cook - 1452 dollars in pounds - The two best signs of good strategy execution are - Apollo shoes case solution free download - Ain t nobody peeking but the stars above - Petra college senior bulawayo - How to prepare budgeted balance sheet in excel - Bussmann medium voltage fuses - Cambridge law test sample answers - Bfi film festival submissions - Madelaine collignon new baby - Isopachous map bulk volume determination - A ____ resembles a circle of computers that communicate with each other. - Is there a difference between academic and professional writing - HIT System Components - Give the major substitution product of the following reaction - Sign convention for radius of curvature of lens - Review Questions - Southwood school case study analysis - Danny devito my cousin vinny - MG315 Discussion Post Unit 1 - International business final exam quizlet - Bpw transpec parts catalog - Https aws amazon com education awseducate - Week 2 - Assignment: Evaluate Decision-Making Processes and Knowledge Needs for Successful Decision-Making - John deere autotrac problems - Glencoe com virtual labs - The passing of grandison short story - Wdo self service portal - HR - 2-3 page paper that that examines Britain as an example of a democratic society. You will evaluate key characteristics in terms of how they have shaped their political and social institutions. - Assignment - How to cite shakespeare plays in an essay - Spiritual needs assessment and reflection - European language levels self assessment grid - St john's church walton - "Behavioral Finance" and "Body of Knowledge" essay - HCA/370Organizational Behavior - Discussion - El doctor salinas caer radiografías - Farewell to manzanar ending - Applying Constructivist Strategies for Teaching Mathematics - Oedipus rex quotes with page numbers - Cyber Security - Domestic violence informative speech outline - Exodus in a nutshell - Juvenile Delinquency - In what ways has dispossession continued to affect aboriginal spiritualities - Sewer diagram sydney water - A perpetual inventory system measures cost of goods sold by - Motor garage business plan - Dupont stone and tile floor cleaner - Chocolate rain lyrics meaning - Flow measurement lab report discussion - 360 words - Mb kb which is bigger - Which is not a correct association - MKT-345 D.1 - Fluid mechanics lab report example - Baby bunting hoppers crossing car seat fitting - Sailboat for sale toby keith chords - Assignment - How much of noah's social security is taxable - Visual basic questions and answers pdf - Values of America - The global strategy that emphasizes a "think-global, act-global" strategic theme focuses on