‘Problem 2: Data Modeling The recrultment agency TEMPO proposes intemship. 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 salisfy these: specifications: - The enterprises (id, name, address and phone number) define the posts for which they nead one or many employees. A post is defined with a label, a daily remuneration, the start date, the end cate and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. - Anintemship employee s described by a ssn, first name, last name, an address, a phone number, histher diplomas (we store for each diploma the year when it is obtained) and his/her skills. - An empioyee 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. Problem 2: Data ModelingThe recruitment agency TEMPO proposes internshipemployees for enterprises for a period of time. Aninternship employee is a temporary employee that will berecruited for a period of time. You must develop adatabase application in order to satisfy thesespecifications:- The enterprises (id, name, address and phonenumber) define the posts for which they need one ormany employees. A post is defined with a label, adaily remuneration, the start date, the end date andthe number of employees for this post. A post needseventually diploma(s) and a list of many skills.- An internship employee is described by a ssn, firstname, last name, an address, a phone number,his/her diplomas (we store for each diploma the yearwhen 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 isvalidated by a chief (ssn, first name, last name,address) designated by the enterprise. This chief isunique to an enterprise.Propose an entity/relationship model using (min,max)notation for the TEMPO recruitment agency.

Answered: Problem 2: Data Modeling The…

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

Related questions

Question

‘Problem 2: Data Modeling The recrultment agency TEMPO proposes intemship. 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 salisfy these: specifications: - The enterprises (id, name, address and phone number) define the posts for which they nead one or many employees. A post is defined with a label, a daily remuneration, the start date, the end cate and the number of employees for this post. A post needs eventually diploma(s) and a list of many skills. - Anintemship employee s described by a ssn, first name, last name, an address, a phone number, histher diplomas (we store for each diploma the year when it is obtained) and his/her skills. - An empioyee 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.

Problem 2: Data Modeling
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, 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

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions