Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A local company hires students from various universities to internship positions with the possibility of future employment. They have maintained a spreadsheet of current and
A local company hires students from various universities to internship positions with the possibility of future employment. They have maintained a spreadsheet of current and past internships but want to facilitate this process. Therefore, they have reached out to you for help, and the following is what you discovered from interviews with the company. Answer the following questions based on the diagram below. Then create the relational model of the of the diagram. Be sure to include the domain constraints and referential integrity constraints. Explain assumptions you made if any
Do all employees belong to a department?
Can an employee manage more than one department?
Does an internship exist without a student?
Are there internships for every position?
What is the degree of relationship that created the application associative entity?
What are the cardinalities of the relationship between position and internship?
What type of attribute is payrate?
What changes, if any, would you make to correct the current model?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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