Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ABC wants a database to keep track of internal company information. Â  Given the following information create an ERD. The ABC Company has several departments and several employees. A division operates many departments but each department is operated by only one division. Most employees reside in a single department however, the company has “rovers” that aren’t assigned any department. Employees are assigned to projects along with other employees. If a project doesn’t have any employees assigned it is cancelled. Each division has a single manager and each department has a single manager. Employees cannot manage more than one division or department. After you complete the ERD on 10/9/18 the teacher will send me a link that i’ll forward to you so you can make corrections on or before 10/10/18.  Don’t bid on this assignment unless you understand this assignment.  Thank you

An Entity-Relationship Diagram (ERD) is a visual representation of the relationships between entities in a database. In this scenario, the ABC Company wants a database to keep track of internal company information. The following information will be used to create the ERD:

1. ABC Company has several departments and several employees.
2. A division operates many departments, but each department is operated by only one division.
3. Most employees reside in a single department, while some employees are “rovers” not assigned to any department.
4. Employees are assigned to projects along with other employees.
5. If a project doesn’t have any employees assigned, it is canceled.
6. Each division has a single manager, and each department also has a single manager.
7. Employees cannot manage more than one division or department.

Based on this information, we can identify the following entities:

1. Division: Represents the divisions in the company. Each division has a unique identifier and is associated with many departments. It also has a manager.
2. Department: Represents the departments in the company. Each department has a unique identifier and is associated with one division. It also has a manager.
3. Employee: Represents the employees in the company. Each employee has a unique identifier and is associated with one department (or is a rover). It can also be assigned to multiple projects.
4. Project: Represents the projects in the company. Each project has a unique identifier and can be assigned to multiple employees.

Now, let’s create the ERD:

1. Draw a rectangle for each entity: Division, Department, Employee, and Project.
2. Connect the Division entity to the Department entity with a line to represent the one-to-many relationship (one division operates many departments).
3. Connect the Department entity to the Employee entity with a line to represent the one-to-many relationship (one department has many employees).
4. Connect the Project entity to the Employee entity with a line to represent the many-to-many relationship (multiple employees can be assigned to multiple projects).
5. Add a diamond shape on the line connecting the Project entity to the Employee entity to represent the “assign” relationship.
6. Connect the Division entity to the Manager entity with a line to represent the one-to-one relationship (one division has one manager).
7. Connect the Department entity to the Manager entity with a line to represent the one-to-one relationship (one department has one manager).
8. Add a rectangle for the Manager entity and connect it to Division and Department with a line.

By following these steps, the ERD will accurately represent the relationships between the entities in the ABC Company’s database.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer