Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Step by Step Solution
★★★★★
3.42 Rating (165 Votes )
There are 3 Steps involved in it
Step: 1
Answer ERD for given business rule ORG NO ORGname Organization CO...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started