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.

icon
Related questions
Question
100%
Regarding this previous post, are they identifying relationships. Which ones?
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 ← 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
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
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
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer