576 views
0 votes
0 votes
•A company has a number of employees. The attributes of EMPLOYEE include Employee ID (identifier), Name, Address, and Birthdate. The company also has several projects. Attributes of PROJECT include Project ID (identifier), Project Name, and Start Date. Each employee may be assigned to one or more projects, or may not be assigned to a project. A project must have at least one employee assigned and may have any number of employees assigned. An employee’s billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing Rate) for each employee when assigned to a particular project.
 

Create an ER diagram for each of the following descriptions:

a)Students enrolled in courses.
b)Customers have many accounts.
c)An employee manages many projects.
d)A lecturer teaches many courses.
e)A department managed by a Head of Department.

Please log in or register to answer this question.

Related questions

1 votes
1 votes
0 answers
1
Balaji Jegan asked Jan 22, 2018
287 views
Plz tell whether this formula is correct?Number of tables for an ER Diagram = [Number of Entities+Number of Multivalued Attributes + Number of M:N Cardinality Ratios(with...
0 votes
0 votes
0 answers
2
Shrenik Pradhan asked Nov 16, 2023
179 views
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct.Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagra...
0 votes
0 votes
0 answers
3
practicalmetal asked Oct 26, 2023
359 views
Can someone please provide me with the correct explanation for this question