Question: Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances. The Metro Hockey Association is made up

Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances.

The Metro Hockey Association is made up of several leagues. A league has a unique name and a level. A hockey league will each contain at least four hockey teams. Each hockey team has a unique name and a location and is composed of six to twelve players, and one player captains the team.

Players have a team number within their team and a position. Players can only be registered on one team. Hockey teams play games against each other on specified dates. Teams may meet more than once a season. Each game has a score and a result. Teams have at least one coach and sometimes several coaches. Each coach has a unique id and a level of accreditation and a number of years of experience, and can coach multiple teams. A coach will have a role title for each team they coach. On any one team a coach may supervise other coaches. Coaches and players have names and addresses. Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Entities 1 League League Name PK Level 2 Hockey Team Team Name PK Location Captain FK referencing P... 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 General Management Questions!

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...

Prosci's change management methodology is developed based on research with over 3,400 participants over the last twenty years. What is unique about the methodology is that it comes from real project...

Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...

Prudence Corporation manufactures two products: X and Y. The company has 4,000 hours of machine time available and can sell no more than 800 units of product X. Other pertinent data follow. Which of...

What is a demand forecast? Why is it relevant in budgeting?

A project has the following forecasted cash flows: Cash Flows, $ Thousands C 0 C 1 C 2 C 3 100 40 60 50 The estimated project beta is 1.5. The market return r m is 16%, and the risk-free rate r f is...

How might you make use of the brains ability to continue thinking about a problem nonconsciously?

There are five horseracing tracks in Kentucky. The Kentucky legislature allows only one track to be open at a time. How does this restriction affect the price the track can charge for its product?

MBA 503-19392- Financial Reporting & Analysis catrine Nyanrangwe & 9/227197:51 PM Homework: 1-2 My AccountingLab: Module One Homework PART Save Score: 0 of 34 pts 1 of 3 (0 complete) HW Score: 0%, 0...

You are an Examiner for the Refund Integrity Program in the GST/HST Audit Division of the Canada Revenue Agency (CRA). Using sophisticated analytical tools, you are able to identify GST/HST returns...

Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total...

Solve the following problems using Mohr's circle. Given: P = 10.5 ksi + P Normal stresses: Ox'= Oy= 8 ksi Draw Mohr's circle and use it to determine the normal and shearing stresses after the element...

2. (6 points) Calculate the charge of a 4.0 g sample of Zinc (atomic number 30, atomic mass 65.37 g/mole, density 7.133g/cm) from which one electron out of every 101 electrons has been removed

Which two of the following statements are true about acquisition intelligence during the acquisition life cycle? A. Manages thresholds/objectives requirements to meet or exceed expected threat...

During the release of an important product, a vice president for a different product line brought a valid concern to the project team, which had to be completed before the release. The vice president...

Lars acquired a new network system on June 5, 2022 (five-year class property), for $55,000. She expects taxable income from the business will always be about $145,000 without regard to the 179...

Gold Star Printing made its required tax deposits. However, it filed its third-quarter Form 941 on December 10, after receiving notice from the missing form's IRS. What is the failure to file penalty...

A certain Christmas tree ornament is a silver sphere having a diameter of 8.50 cm. Determine an object location for which the size of the reflected image is three-fourths the size of the object. Use...

For each of the following explain the concept of the rational, two real world examples, three advantages and disadvantages based on Pages 71-86 of Oxford Canada perspectives on ideology textbook...

1. Does federal immigration policy, as expressed in the IRCA, preclude the Board from awarding back pay to an undocumented alien who has never been legally authorized to work in the United States? 2....

De Trae Enterprises was employed as a masonry subcontractor at the Smithhaven Mall construction site in Lake Grove, New York. OSHRC found De Trae guilty of three separate violations of OSHA standards...

1. What was defendant DeLurys role in the dispute? 2. What action did the lower court take against the defendant and the union for violating the preliminary injunction? 3. In Professor Taylors view,...

Which of the following has a more elastic supply in the short run? a. Hospitals or mobile clinics? b. Purebred dogs or pet rabbits? c. On-campus courses or online courses?

Suppose that the price of peanut butter rises from $2 to $3 per jar. a. The quantity of jelly purchased falls from 20 million jars to 15 million jars. What is the crossprice elasticity of demand...

Draw the price effect and the quantity effect for a price change from $60 to $50. Which effect is larger? Does total revenue increase or decrease? No calculation is necessary.