Answered step by step
Verified Expert Solution
Link Copied!

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

 

Use these business rules to draw a nice neat ERD. Remember that if you encounter any Manyto-Many relationships in the busines



 

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Financial and Managerial Accounting

Authors: Rich, Jeff Jones, Dan Heitger, Maryanne Mowen, Don Hansen

2nd edition

978-0538473484, 538473487, 978-1111879044

More Books

Students also viewed these Computer Engineering questions