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

Bridge entity erd

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

Student Name:__________________ Date:_________

ECET450 Practice Exercise #2
Creating an Entity Relationship Diagram

In Lab 1, you worked with a simple Entity Relationship Model diagram that only depicted one side of the database relationship. Although this is a very important tool for database development, it only shows part of the picture. In this exercise (and in Lab 2) you will explore the process of creating an Entity Relationship Diagram (ERD). The ERD shows everything the E-R Model diagram does and more. In this new diagram, you will be able to show not only the relationship but also the cardinality (number to times the relationship exists), of the relationship. Finally, we learn whether the relationship is mandatory (no null values allowed for the foreign key) or optional (nulls are allowed in the foreign key).

In Lab 1, you had to set a parameter in Visio to get the tool to draw the correct diagram. For this exercise, you will be doing the same thing, only there are more things to select and change when you want to use Crow’s foot notation for the diagram. To begin, select the Database/Options/Document from the top menu bar once you are in Visio.

image1.png

Now we are going to take a different approach than we did in Lab 1. Once again, you should be looking at the Database Document Options box. The selection you make this time will create a different look to your diagram, depending on which way the buttons are set. If you select the IDEFIX button then the primary key column or columns will show at the top, but you will not see a PK designation for them. If you set the relationship button, you will see the PK next to the column. For the purposes of this exercise, we will leave the button as is.

image2.png

Next, you want to select the Table tab from the options box. In this window, you are going to unselect the radio button under the “IDEFIX optionality ‘(O)’” section. This will only clean up the document a little, but will not change the functionality of the diagram.

image3.png

There is one final change to make. Select the “Relationship” tab and you will see the last form that we will modify. For this diagram, you are going to want to use the Crow’s foot notation, so you want to make sure that this button is set. You also want to make sure that the relationship has a name in both directions. To set this, check the “Show verb phrase” radio button (the rest of the buttons should be fine). Compare your screen to the one shown below.

image4.png

If they look the same, select OK and move on to the diagram. The examples will use the same tables as before (INSTRUCTOR and CLASS). Once again, after you have your tables created then select the connection tool from the menu bar. Go through the same process of placing the cursor in the middle of the table with the primary key and dragging it to the table with the foreign key (remember not to release the mouse until the second table border turns red). You should now see a line that depicts the Crow’s foot notation (as displayed in the diagram below).

image5.png

Again, you will be repeating this process as you successfully complete this exercise and Lab 2 for this week.

Bridge Tables

In Lab 1, you used a bridge table in the final solution of #3. The concept of a bridge entity (table) or composite entity is first introduced on page 101 in the database design text. A detailed explanation of this type of entity is presented on pages 147-150. Bridge entities are very powerful tools that resolve many relationships within a database. In this exercise and in Lab 2, you will have several scenarios that will require the use of a bridge entity.

The structure of a bridge entity is centered on the primary key. Bridge entities can be identified by composite primary keys. The primary key is composed of foreign keys referencing the two tables that the bridge entity is trying to connect. To clarify this concept, we will look at the following example.

Let’s take a typical scenario of a student taking many courses and a course with many

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:

Accounting & Finance Mentor
Homework Tutor
Finance Master
Engineering Mentor
Engineering Exam Guru
Phd Writer
Writer Writer Name Offer Chat
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$102 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

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

$93 Chat With Writer
Finance Master

ONLINE

Finance Master

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

$71 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

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

$89 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

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

$62 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$84 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

Film essay - Alliteration in jasper jones - Richard cunningham serial killer - Psychiatric Journal - 15 second commercial monologues - Cisco self care portal - Aqa physics formula booklet - Phantom profit - Head heart lydia davis poem analysis - Determine the centroid x y of the shaded area - Where is koretrak watch made - St martin guide to writing edition pdf - Http www phschool com science biology_place labbench lab5 intro html - Rochester midland corporation uk - Iso 17025 document control procedure - Glassware accuracy lab report - Cause and effect sentence strips - Data table 1 chromatogram data - Zipcar ford transit 150 cargo van - Performance appraisal comments analytical skills - Apply for l2 licence tasmania - Explain corporate motives for forecasting exchange rates - Foundation In Special Education - How gas bill is calculated - 180.4 lbs to kg - HIST discussion - B737 air conditioning system - Assignment - Morgans funeral home princeton ky - The politics of public budgeting 8th edition pdf - Geography bearings worksheet with answers - Derek farnsworth uf - Interview questions for forensic auditor - Quadrilateral abcd is a parallelogram - Tertiary industry of chocolate - As nzs 3500.2 free download - Form 3115 depreciation example - Khan lewis phonological processes chart - Sir gustav nossal medallion - Chromium 52 protons neutrons electrons - Case Study - Diploma in security and risk management - Racv renew roadside assistance - Civil and infrastructure engineering rmit - Case study: Mr C - Applied Machine Learning - Write a one page letter to your 16-year old self - Eharmony 19.95 for 3 months - Discussion-1 - Hacker techniques tools and incident handling 2nd edition pdf - Uber and the sharing economy case study solution - Acids bases and salts lab report - Discussion - Qut 24 hour library - Show that the formula mass of nacl is - Carlos plans to build a grain bin - Discussion 10.1 - Lord of the flies movies - Drill press safety sheet - End xldown offset 1 0 - 194r hm4e n2 l - Naming blaming and claiming - Box hill tafe electrical - Volume charge density to linear charge density - Why we crave horror movies essay - High street primary winsford - A pharmaceutical company receives large shipments of aspirin tablets - Mountain dew selecting new creative case analysis - Flying star number meaning - Issues facing woolworths - Day of the dead nicaragua - Amp lost policy declaration form - Fat twins alice in wonderland - The signal short story summary - Define the term cliché penn foster - 10 awg in mm - Action research vs traditional research - Nuestra familia 14 bonds - Why might you use a perception check - In the snack bar - Assignment 4 - Which of the following statements about price is true - Australian qualifications framework at certificate iv - Advanced Health Assessment and Diagnostic Reasoning - Abb cm-ufd.m33 solar protection relay - 16 700 in scientific notation - What magic trick does mr utterbunk perform every evening - Warr company is considering a project - Psychology - The musician accredited with inspiring the rise of swing: - Box hill pre apprenticeship - My place house of decor answers - Bromination of acetanilide and aniline lab report - Influential factors of country's accounting system development - Poem journal and glossary - Melbourne transport zones map - John maxwell five levels of leadership - The practice of statistics 5th edition chapter 7 - When was the blind side set - Military time worksheet pdf