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

Celia a slave full book - Creedy v for vendetta - Enterprise Architecture - Metal or nonmetal worksheet - 13 hybanthus road riverton - Avaya ip office music on hold wav file - A best cost provider strategy - Nam le love and honour analysis - 6 regions of south carolina - 5 Tips Seeping With a virgin - Problem posing education vs banking education - The menstrual cycle depends on events within the female ovary - WRITE TOPIC - Toast to absent friends wedding - Hoods play script pdf - It security assessment report template - Accounting - Essay - Stewart watson buckie property - Customer relationship management strategy a teaching case study - Which One Is The Best California College With Football Team? - Grand strategy matrix for coca cola - Groups of three quiz - Electrophilic aromatic substitution nitration of methyl benzoate lab report - Questions on International Trade - Global Healthcare Comparison Matrix and Narrative Statement - Symes v mahon case summary - Half wave rectifier circuit lab report - How do you calculate plant utilization in capsim - Loan advice - 2 coments each one 150 words (CITATION AND REFERENCE) - Artifact that embodies ethical values - Byron bay cookie factory tour - Eco table - Hpe 3par best practices - Maureen question - Types of international capital market - Conquered the incan empire with force deceit and diplomacy - Alisha incorporated manufactures medical stents - Government communications plan template - A civil action movie quotes - Informative Research Paper - Auburn south primary school - Apple inc compensation for employees - Qdx f px - Models for writers 13th edition - Pros and cons of indian gaming - Annotated BIB - Organ Leader - Analyze Current Security Products and Services - The yellow dog poem book - Fisher 2004 ib psychology - Stephen hillenburg movies and tv shows - Uq risk assessment database - Disscussion - Esol entry 3 writing exam past papers with answers - Weather lesson plan esl - What is the relationship between thinking and language - Pelican stores case study answers - Case study starting a business project schedules and curves edgenuity - Teaching myths and legends - Rank of 3x4 matrix - One word from god can change your finances pdf - Public policy meeting - Bnp paribas prime brokerage inc - Why did aunt clara give lennie a rubber mouse - Sherman kent and the profession of intelligence analysis - Social Work- Safety and Agency Responsibility - Art Analysis - Organ Leader - Written assignment - Iphone repair burbank and whitsett - Capsim mission statement examples - Low if receiver architecture - Assignment - What must be general dynamics earnings per share - Hard drawn steel wire specification - Exchange message tracking eventid - Barriers & Help Seeking - 4 bit shift register timing diagram - Electromagnetic induction physics lab report - Wiley intermediate accounting chapter 3 solutions - 150 divided by 30 - Barbarian at the gate stock meaning - Oedipus rex short version - INTERNSHIP - Tone of me talk pretty one day - Proposal 2 electroshock therapy - Finding your worldview thinking christianly about the world - Compare and Contrast Delirium vs Dementia - New perspectives on html and css tutorial 3 case problem 1 - Arrt code of ethics - Hyllus maris spiritual song of the aborigine - Understanding the healthcare system at the local level - Elements of design colour - Snhu core values - Common traits of serial killers - Self management employability skills - Http www pbs org wgbh nova lostempires roman day html - A cost that should be ignored when evaluating a project - Bankstown girls high school ranking