Question: Would this be correct for an EERD diagram? For a long tour, the manager needs to record the status information at each stop over

Would this be correct for an EERD diagram?

For a long tour, the manager needs to record the status information at each stop over point. The status information includes entry time, exit time and the day.

Also, for a many-to-many relationship, who inherits the foreign key? I don't need an associative entity as I have no data to store between them. Just need the many to many, but am confused as to which one inherits the foreign, or if they both inherit each others.

Manager ManagerlD ManagerExp ManagerQualf Statusinfo Entry Time -OExit Time Day B Long Tour LongDuration H StopPoint StopPointlD StopPointName StopPointAddress

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Manager and StatusInfo Relationship Its not clear how the Manager entity and the StatusInfo entity a... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

What is "orthographic memory"? O a. Memory of written and spoken sentence structure O b. Memory of word meanings and how words are related O c. Memory of speech sounds and pronunciation "rules" O d....

Fanelli Corporation, a merchandising company, reported the following results for July. Number of units sold Selling price per unit Unit cost of goods sold Variable selling expense per unit Total...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Provide a summary technical report with your own words about Pipelined Execution which is also named as Instruction Level Parallelism, addressing mainly the following areas: 1. What is Pipelined...

Save and Submit 1. QUESTION 1 Which of the following items must be included in a Project Charter? A. Names of all of the team members who will work on the project. B. The impact of business cycles on...

Chapter 2 - Planning Project Communication IN THIS CHAPTER Struggling with Proper Project Communication Planning Preventing Common Communication Problems Creating a Project Communication Plan...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Let r and s be solutions to the quadratic equation x 2 b x + c = 0. For n N, define d0 = 0 d1 = r s dn = b dn1 c dn2 (n 2) Prove that dn = r n s n for all n N. [4 marks] (b) Recall that a commutative...

CALCULATE THE ACID TEST RATIO USING THE INFORMATION $000 Sales revenue 20,000 Cost of sales (17,000) Distribution costs (600) Administrative expenses (400) Net interest (300) Taxation (1,000)...

Exercise 123 The following information is taken from French Corporation s financial statements: Cash Accounts receivable Allowance for doubtful accounts Inventory Prepaid expenses Land Buildings...

As it relates to accounting fraud, which of the following best describes perceived pressure? Question 9 options: A ) Intentional misrepresentation of financial statements B ) A need to obtain cash or...

A 0.20-kg glass cup at is filled with 0.40 kg of hot water at 90 oC. Neglecting any heat losses to the environment, what is the equilibrium temperature of the water?

A 0.20-kg billiard ball traveling at a speed of strikes the side rail of a pool table at an angle of (Fig. 6.31). If the ball rebounds at the same speed and angle, what is the change in its momentum?...

A 0.150-kg baseball traveling with a horizontal speed of 4.50 m/s is hit by a bat and then moves with a speed of 34.7 m/s in the opposite direction. What is the change in the balls momentum?

A 0.030-kg lead bullet hits a steel plate, both initially at 20oC. The bullet melts and splatters on impact. (This action has been photographed.) Assuming that of the bullets kinetic energy goes into...

35Cl and 37Cl are two isotopes of chlorine. What are the numbers of protons, neutrons, and electrons in each if (a) The atom is electrically neutral, (b) The ion has a 2 charge, and (c) The ion has a...

Express the following endpoint sum in sigma notation, but do not evaluate.i=125()

Carolyn Murphy, a welfare recipient with very limited education and with four minor children, responded to an advertisement that offered the opportunity to purchase televisions without a deposit or...

You receive a telephone call from a company you never do business with requesting a reference on one of your employees, Mary Sunshine. You believe that Mary is generally incompetent and would be...

Discuss contractual liability, warranty liability, and liability for conversion.

Nicole and Camille are synchronized swimmers for their college swim team. They often work long hours to ensure the movements in their routine are perfectly timed. What part of their brains must...

Roberto has had difficulty sleeping for the past 6 months and his body seemingly no longer differentiates between night and day. His doctor believes the problem lies with Robertos endocrine system....

Bailey is a subject in a study on memory and problem solving. The researcher is applying magnetic pulses to her brain through copper wire coils positioned directly above her scalp. Baileys study...