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
icon
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 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
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Types of Database Architectures
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
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education