about this problem, I would like to know why there are only 6 entities and not 7 (GreenChampion must be an entity) if yes or no why? and how include it in the diagram. (I've asked this question before but I'm being answered sideways or incorrectly answers I don't know why like the diragram here). Can you please help me with real answers ? Thank you very much CompanyCompany - vlocationContact1has1CEOnainC-IDNamePhoneEmail1.1CouristshasDepartment1* Dept-IDDept_namelocation1 *has1EmployeeE-ID1 NaumePhone No.EmailSurnameaccountedfor1work onCarbonTranscationTrans-IDdateValueProductProd-IDQuantityDecoration171 GreenchampiohassionEmp-1●Dept_cramehame

This is a different and CORRECT solution by me from the previous one posted by someone. You should…

Answered: Can you please help me with real…

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

Concept explainers

Question

about this problem, I would like to know why there are only 6 entities and not 7 (GreenChampion must be an entity) if yes or no why? and how include it in the diagram. (I've asked this question before but I'm being answered sideways or incorrectly answers I don't know why like the diragram here). Can you please help me with real answers ? Thank you very much

Company
Company - v
location
Contact
1
has
1
CEO
nain
C-ID
Name
Phone
Email
1.
1
Courists
has
Department
1* Dept-ID
Dept_name
location
1 *
has
1
Employee
E-ID
1 Naume
Phone No.
Email
Surname
accounted
for
1
work on
Carbon
Transcation
Trans-ID
date
Value
Product
Prod-ID
Quantity
Decoration
171 Green
champio
has
sion
Emp-1
●Dept_crame
hame

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Hello, if I add a relation between GreenChampion and Employee , is this still true? because I find it weird not to link green champion to employee or department especially since the primary key is employee id

Solution

by Bartleby Expert

SEE SOLUTION

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