Following on your job to build an efficient data model for a company that provides conference...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Following on your job to build an efficient data model for a company that provides conference management services to various organizations; you've now obtained business rules, some of which are listed below. • One Organization has Many Conferences, and possibly none. • One Conference belongs to One Organization, and not none. • One Conference has Many Delegates, and possibly none, and a maximum of 400. • One Delegate attends Many Conferences, and not none. You have also been given a small sample of their records, in case this may prove useful. It is below. ORG_NUM 152 152 ORG_NAME Johns Inc Johns Inc ORG_TEL 021598715 021598715 178 Petes Inc. 031568798 CONF_NUM 101 102 109 CONF_DATE 12-03-17 14-04-19 16-06-18 CONF_NAME PRASA17 PRASA19 COPA18 DELG_ID 12 15 19 11 15 22 DELG_NAME F. Freds J. Jacks P. Petes T. Tims J. Jacks K. Korths ATT_PACKAGE 2 5 5 5 7 N Use these business rules to draw a nice neat ERD. Remember that if you encounter any Many- to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case. Following on your job to build an efficient data model for a company that provides conference management services to various organizations; you've now obtained business rules, some of which are listed below. • One Organization has Many Conferences, and possibly none. • One Conference belongs to One Organization, and not none. • One Conference has Many Delegates, and possibly none, and a maximum of 400. • One Delegate attends Many Conferences, and not none. You have also been given a small sample of their records, in case this may prove useful. It is below. ORG_NUM 152 152 ORG_NAME Johns Inc Johns Inc ORG_TEL 021598715 021598715 178 Petes Inc. 031568798 CONF_NUM 101 102 109 CONF_DATE 12-03-17 14-04-19 16-06-18 CONF_NAME PRASA17 PRASA19 COPA18 DELG_ID 12 15 19 11 15 22 DELG_NAME F. Freds J. Jacks P. Petes T. Tims J. Jacks K. Korths ATT_PACKAGE 2 5 5 5 7 N Use these business rules to draw a nice neat ERD. Remember that if you encounter any Many- to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case.
Expert Answer:
Answer rating: 100% (QA)
Answer ERD for given business rule ORG NO ORGname Organization CO... View the full answer
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-1111879044
2nd edition
Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen
Posted Date:
Students also viewed these computer engineering questions
-
Mino Inc. manufactures chocolate syrup in three departments: Cooking, Mixing, and Bottling. Mino uses the weighted average method. The following are cost and production data for the cooking...
-
Mino Inc. manufactures chocolate syrup in three departments: Cooking, Mixing, and Bottling. Mino uses the weighted average method. The following are cost and production data for the cooking...
-
Decisions for Tomorrow In 2019, 360,000 electric vehicles (EVS) were sold in the United States. Instructions: Round your responses to one decimal place. a. Suppose the average price of these cars was...
-
In Problems 530, a. Classify the sequences as arithmetic, geometric, Fibonacci, or none of these. b. If arithmetic, give d; if geometric, give r; if Fibonacci, give the first two terms; and if none...
-
What remedies does an insurer have if the insured misrepresented material facts when applying for insurance coverage?
-
Reiter Corp. (a U.S.-based company) sold parts to an Israeli customer on December 1, Year 1, with payment of 100,000 Israeli shekels to be received on March 31, Year 2. The following exchange rates...
-
Zeds Manufacturing incurred the following costs in acquiring land, making land improvements, and constructing and furnishing a new building. Zeds Manufacturing depreciates buildings over 50 years,...
-
Beta Company uses a standard cost accounting system. In 2014, 45,000 units were produced. Each unit took several pounds of direct materials and 2 standard hours of direct labor at a standard hourly...
-
3. Ally bases her price to act in a movie on the success of her last two movies. Movies may be a blockbuster (B), average (A) or a dud (D). Below is her rate table: Last Two Movies Both Blockbusters...
-
a. Find the shortest path from A to all other vertices for the graph in Figure 9.82. b. Find the shortest unweighted path from B to all other vertices for the graph in Figure 9.82. 3 D 3. 2.
-
Three beans are selected from a large jar containing equal amounts of white beans and red beans. An outcome is represented by a string of the sort RWW (meaning the first bean is red, the second is...
-
What steps can be taken during negotiation to assist in a constructive outcome for all parties involved?
-
What is the key difference between a fixed price contract and a cost-reimbursable contract?
-
When would a time and materials (T\&M) contract be used?
-
What considerations should be taken into account when contracting in a Scrum (Agile) project?
-
What are some benefits of outsourcing? When is outsourcing likely to be used in a project context?
-
A bank makes a 6-year loan of $50,000 at an annual interest rate of %14. What is the yearly payment and the balance at the end of year 2?
-
A 6-lb shell moving with a velocity ?? v0k explodes at point D into three fragments which hit the vertical wall at the points indicated. Fragments A, B, and C hit the wall 0.010 s, 0.018 s, and 0.012...
-
Espanola Company produces a single product. The projected income statement for the coming year is as follows: Sales (50,000 units @ $45) ........ $2,250,000 Total variable cost ............ 1,305,000...
-
Refer to the information for East Mullett Manufacturing above. East Mullett Manufacturing earned operating income last year as shown in the following income statement: Sales ..................... $...
-
On December 31, 2011, The Rock Restaurant borrowed $254,500 by issuing three-year, 7 percent bonds with a face amount of $250,000. Interest is payable annually on December 31. Required: Prepare an...
-
The duties of a nozzle and a diffuser are (a) Opposite to each other (b) Identical to each other (c) Not comparable at all (d) None of these.
-
Nozzles and diffusers are widely used in (a) Heat exchangers (b) Refrigeration systems (c) Rockets and other space vehicles (d) None of these.
-
1 ton of refrigeration is equivalent to (a) \(3.517 \mathrm{~kW}\) (b) \(4.202 \mathrm{~kW}\) (c) \(250 \mathrm{kcal} / \mathrm{min}\) (d) \(50000 \mathrm{kcal} / \mathrm{min}\).
Study smarter with the SolutionInn App