Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
You've been enlisted to build an efficient data model for a company that provides conference management services to various organizations. You've identified the following entities: Organization, Conference, Delegate, Event, Caterer, Entertainer. No others. Below are the statements you were previously given. Use them to infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entities don't necessarily directly connect, unless the information collected specifies that they are connected. "We organize and manage conferences for various organizations." "Some organizations have a conference once off. Others might have more than one conference over time." • "A conference involves delegates, which may come from all walks of life: industry. academia and government. At the end of the day, a delegate is a delegate, though. We just keep track of their details and their affiliations." • "Each conference has a number of events. An event could be one of many things: a plenary session, a panel discussion, a break-away session, a function (either welcoming or goodbye), or anything else that the organization requires." • "Each event may or may not require catering by one caterer. An event may or may not also require entertainment by one or more entertainers."

You've been enlisted to build an efficient data model for a company that provides conference management services to various organizations. You've identified the following entities: Organization, Conference, Delegate, Event, Caterer, Entertainer. No others. Below are the statements you were previously given. Use them to infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entities don't necessarily directly connect, unless the information collected specifies that they are connected. "We organize and manage conferences for various organizations." "Some organizations have a conference once off. Others might have more than one conference over time." • "A conference involves delegates, which may come from all walks of life: industry. academia and government. At the end of the day, a delegate is a delegate, though. We just keep track of their details and their affiliations." • "Each conference has a number of events. An event could be one of many things: a plenary session, a panel discussion, a break-away session, a function (either welcoming or goodbye), or anything else that the organization requires." • "Each event may or may not require catering by one caterer. An event may or may not also require entertainment by one or more entertainers."

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
You've been enlisted to build an efficient data model for a company that provides conference management services to various organizations. You've identified the following entities: Organization, Conference, Delegate, Event, Caterer, Entertainer. No others. Below are the statements you were previously given. Use them to infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entities don't necessarily directly connect, unless the information collected specifies that they are connected. ● "We organize and manage conferences for various organizations." "Some organizations have a conference once off. Others might have more than one conference over time." "A conference involves delegates, which may come from all walks of life: industry, academia and government. At the end of day, a delegate is delegate, though. just keep track of their details and their affiliations. "Each conference has a number of events. An event could be one of many things: a plenary session, a panel discussion, a break-away session, a function (either welcoming or goodbye), or anything else that the organization requires. "Each event may or may not require catering by one caterer. An event may or may not also require entertainment by one or more entertainers."
Transcribed Image Text:You've been enlisted to build an efficient data model for a company that provides conference management services to various organizations. You've identified the following entities: Organization, Conference, Delegate, Event, Caterer, Entertainer. No others. Below are the statements you were previously given. Use them to infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entities don't necessarily directly connect, unless the information collected specifies that they are connected. ● "We organize and manage conferences for various organizations." "Some organizations have a conference once off. Others might have more than one conference over time." "A conference involves delegates, which may come from all walks of life: industry, academia and government. At the end of day, a delegate is delegate, though. just keep track of their details and their affiliations. "Each conference has a number of events. An event could be one of many things: a plenary session, a panel discussion, a break-away session, a function (either welcoming or goodbye), or anything else that the organization requires. "Each event may or may not require catering by one caterer. An event may or may not also require entertainment by one or more entertainers."
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

did not resolve the relationships between th entities (conference, delegation,event, caterer,organization,entertainment)

eg Conference and events

1 conference has Many events

1 Events has many conferences

therefore the relationship is Many-to-Many

Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question

did not answer the question, relationship between the entities(did not show the relationship) and the contraints

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS