ABC is a Company which is having branches spread across the World. The company is having a
strength of 1000+ employees. Each employee works in a Branch. At the time of joining, the
person needs to provide personal and professional information such as Name, Address, Passport
Number, Mobile Number, E-mail address, etc. After this information is furnished, a unique ID is
generated for each employee. Then the employee is assigned to a Branch in which S/he will
work. Every branch is having a Name. However, one or more branches may have the same name.
However, every branch is having a unique ID.
Now, with reference to the above, answer the following:
(1) List the Entities
(2) For each Entity, list Attributes
(3) Define relationships between the Entities
(4) Finally, draw the Entity Relationship Diagram
Comments
Leave a comment