oftware Engineering The recruitment agency TEMPO proposes internship employees for enterprises for a period of time. An internship employee is a temporary employee that will be recruited for a period of time. You must develop a database application in order to satisfy these specifications: The enterprises (id, name, address and phone number) define the posts for which they need one or many employees. A post is defined with a label, a daily remuneration, the start date, the end date and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. An internship employee is described by a ssn, first name, last name, an address, a phone number, his/her diplomas (we store for each diploma the year when it is obtained) and his/her skills. An employee could be recruited for one or many posts. This recruitment of an employee for a given post is validated by a chief (ssn, first name, las
oftware Engineering The recruitment agency TEMPO proposes internship employees for enterprises for a period of time. An internship employee is a temporary employee that will be recruited for a period of time. You must develop a database application in order to satisfy these specifications: The enterprises (id, name, address and phone number) define the posts for which they need one or many employees. A post is defined with a label, a daily remuneration, the start date, the end date and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. An internship employee is described by a ssn, first name, last name, an address, a phone number, his/her diplomas (we store for each diploma the year when it is obtained) and his/her skills. An employee could be recruited for one or many posts. This recruitment of an employee for a given post is validated by a chief (ssn, first name, las
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 11RQ
Related questions
Question
Software Engineering
The recruitment agency TEMPO proposes internship employees for enterprises for a period
of time. An internship employee is a temporary employee that will be recruited for a period
of time. You must develop a
- The enterprises (id, name, address and phone number) define the posts for which they
need one or many employees. A post is defined with a label, a daily remuneration, the
start date, the end date and the number of employees for this post. A post needs
eventually diploma(s) and a list of many skills. - An internship employee is described by a ssn, first name, last name, an address, a
phone number, his/her diplomas (we store for each diploma the year when it is
obtained) and his/her skills. - An employee could be recruited for one or many posts. This recruitment of an
employee for a given post is validated by a chief (ssn, first name, last name, address)
designated by the enterprise. This chief is unique to an enterprise.
Propose an entity/relationship model using (min,max) notation for the TEMPO recruitment agency.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning