The enterprise is organized into sites. Each site has a unique number, a name, and a specific employee who manages it. The enterprise makes its income by selling items to agents. Each agent has a name and a unique number to identify it. The enterprise has several employees] Each employee has a name, birthday, sex, salary and a unique number. Ap employee can work for one site at a time, and one of the employees that work there will manage cach site. We will also want to keep track of when the current manager started as manager. An employee can act as a leade
The enterprise is organized into sites. Each site has a unique number, a name, and a specific employee who manages it. The enterprise makes its income by selling items to agents. Each agent has a name and a unique number to identify it. The enterprise has several employees] Each employee has a name, birthday, sex, salary and a unique number. Ap employee can work for one site at a time, and one of the employees that work there will manage cach site. We will also want to keep track of when the current manager started as manager. An employee can act as a leader for other employees at the site; an employee may also act as the leader for employees at other sites. An employee can have at most one leader. A site may handle a number of agents, with each agent having a name and a unique number to identify it. A single agent may only be handled by one site at a time. Employees can work with agents controlled by their site to sell them items. If necessary, multiple employees can work with the same agent. We will want to keep track of the amount in birr of the item each employee sells to each agent they work with. a)Design a possible conceptual design using ERD (Entity Relationship Diagram). Clearly showing all the objects, attributes, constraints and the cardinality from the above data
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
