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
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
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
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education