Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider an employee management system that stores information regarding the employee ID , name, address, contact numbers, date of birth and age. Each employee can
Consider an employee management system that stores information regarding the employee ID name, address, contact numbers, date of birth and age. Each employee can have more than one contact number. Also, the age is calculated from the date of birth provided. The address consists of city, road and house number respectively. Each employee is assigned to a specific team. The system also stores information regarding each team ie the team code, team name and number of members in each team. Each employee can work under only one team. Draw the ER diagram for the above scenario.
Consider an employee management system that stores information regarding the
employee ID name, address, contact numbers, date of birth and age. Each
employee can have more than one contact number. Also, the age is calculated from
the date of birth provided. The address consists of city, road and house number
respectively. Each employee is assigned to a specific team. The system also stores
information regarding each team ie the team code, team name and number of
members in each team. Each employee can work under only one team.
Draw the ER diagram for the above scenario.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started