Read the scenario and design an entity relationship diagram with the following components: A local university is
Question:
Read the scenario and design an entity relationship diagram with the following components:
A local university is starting an internship program for its seniors to gain real world experience in local businesses to gain real-world experiences from the business world. The following information needs to be tracked, student, intern opportunity, company, degree program, application. The details related to the student is name, degree program, contact information. For the company need to track company name, address, contact information, Please identify any additional information that would be necessary to support the database design.
• Identify the entities that need to be modeled
• Identify the attributes that each entity will include
• Identify the relationships as required.
• Identify the primary keys (identifier attributes)
• Identify any business rules or assumptions that are associated with your data model
Essentials of Business Statistics Communicating With Numbers
ISBN: 978-0078020544
1st edition
Authors: Sanjiv Jaggia, Alison Kelly