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...
-
Allied Construction Company has signed a three-year contract to construct an apartment complex for $64 million. The expected costs for each year follow (in millions): 2011. $ 7.2 2012. 20.1 2013....
-
Key figures for Apple and Google follow. Required 1. Compute the debt-to-equity ratios for Apple and Google for both the current year and the prior year. 2. Use the ratios you computed in part 1 to...
-
Which of the following is not an intensive property? (a) Temperature (b) Pressure (c) Density (d) Enthalpy.
-
Certain production equipment used by Dayton Mechanical has become obsolete relative to current technology. The company is considering whether it should keep or replace its existing equipment. To aid...
-
Chipman Sofware recently reported the following amounts in its unadjusted trial balance at its year-end: Accounts Receivable Allowance for Doubtful Accounts Sales (assume all on credit) Debits $...
-
a. Draw a UML class diagram that describes the Tablet Store's purchases and payments process. b. Using Microsoft Access, implement a relational database from your UML class diagram. Identify at least...
-
1. You have an unpaid credit card debt of $461. The interest rate you carry is 17.55%. Make a table showing Payment Number, Monthly Payment, Balance Less Payment, Plus Interest, and Remaining...
-
James and Angela have been involved in a romantic, but violent, relationship for the past five years. Angela has very serious anger management issues and has kept James living in a constant state of...
-
After receiving a promotion to logistics manager, Shantil's husband, Ashton, purchased a 2017 BMW SUV for $68,000; however, he financed $48,000 through First Florida Banc. The bank took a security...
-
Attorney Lillian Liberty wants to expand the firm's sports law practice, and is very pleased to have a new client, Dwayne Simpson, a waterpolo player. Liberty wants you to assist with Simpson's...
-
The Plaintiff Alisha is suing the Defendant Benadine in a civil action claiming damages in a court of competent jurisdiction in Pacifica arising out of a collision at an intersection on 6 th August...
-
In 2006 Jack Kelly Partners LLC alleged that Zegelstein (defendants) advertised that the premises was suitable for commercial use. Plaintiff was not aware that the use as represented by defendants...
-
Select all that apply Investments in debt securities may be classified as Multiple select question. available-for-sale securities. current liabilities. equity securities. held-to-maturity securities....
-
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...
-
For methanol synthesis reaction \[ \mathrm{CO}(\mathrm{g})+2 \mathrm{H}_{2}(\mathrm{~g}) ightleftharpoons \mathrm{CH}_{3} \mathrm{OH}(\mathrm{g}) \] Using a feed mixture of carbon monoxide and...
-
The L2 steel blade of the band saw wraps around the pulley having a radius of \(12 \mathrm{in}\). Determine the maximum normal stress in the blade. The blade has a width of 0.75 in. and a thickness...
-
An L2 steel strap having a thickness of 0.125 in. and a width of \(2 \mathrm{in}\). is bent into a circular arc of radius \(600 \mathrm{in}\). Determine the maximum bending stress in the strap.
Study smarter with the SolutionInn App