In a company called BCCD engineers are charged of developing different types of applications. Each engineer is identified by an Employee ID, First Name, Last Name, address, phone and E- mail (Please note that the company is only keeping data for one phone, and one e-mail - Thus, you do not have to worry about multivalued attribute). Each application is identified by an application ID, Name and type. Each engineer must work on one or many applications. Applications must be developed by one or more engineers. The company wants to keep track of the date each of the engineers started working on the assigned application.
In a company called BCCD engineers are charged of developing different types of applications. Each engineer is identified by an Employee ID, First Name, Last Name, address, phone and E- mail (Please note that the company is only keeping data for one phone, and one e-mail - Thus, you do not have to worry about multivalued attribute). Each application is identified by an application ID, Name and type. Each engineer must work on one or many applications. Applications must be developed by one or more engineers. The company wants to keep track of the date each of the engineers started working on the assigned application.
Related questions
Question
100%
Regarding this previous post, are they identifying relationships. Which ones?

Transcribed Image Text:8:35
←
and Model.
1- Some engineers were promoted to a
supervisory position. Those promoted
engineers supervise one or many other
engineers. Each Subordinate engineer must be
supervised by one and only one senior
engineer.
2- The company contracted with a number of
software learning institutions for their
engineers to take professional development
Courses. The company wants to record in the
database the course that each of its engineers
took, where (which institution) and when
(Completion date). "Ternary relationship might
be needed"
3- Each institution is identified by Inst_ID,
Name, Location, Phone.
Each Course is identified by a Course_ID,
Name, Type.
Expert Answer.
Step1
a)
Given,
@
vx
DO

Transcribed Image Text:8:35
ANSWERED
Tuesday, Sep 26, 2023
ENGINEERING COMPUTER-SCIENCE
10
Please help asap. Hand draw the EER diagram.
Thank you in advance. Write whether it is a one
to one, one to many, or many to many. Also
include if it's mandatory or optional on both
sides. Since I'm a beginner, please show the
arrows and boxes clearly.
In a company called BCCD engineers are
charged of developing different types of
applications.
Each engineer is identified by an Employee ID,
First Name, Last Name, address, phone and E-
mail (Please note that the company is only
keeping data for one phone, and one e-mail -
Thus, you do not have to worry about
multivalued attribute).
Each application is identified by an application
ID, Name and type.
Each engineer must work on one or many
applications. Applications must be developed
by one or more engineers. The company wants
to keep track of the date each of the engineers
started working on the assigned application.
Fach engineer is allocated one personal
√x
DO
8
Expert Solution

Step 1: Explaination
In this ERD diagram , it shows the entities involved and their reationship.
Step by step
Solved in 3 steps with 1 images
