Must draw and ERD steps are below
Step 1: Find all possible entities [lookfor nouns]
Step 2: Draw entities with , identify primary keys (underlined) and foreign keys (initalic or otherwise highlighted)
Step 3: Find & show relationships [find verbs] one by one between entities
Step 4: Find & show cardinality one by one between entities
Step 5: Find& show modality one by one between entities
Step 6: Revisit Steps 1 to 5 to ensure your ERD is complete
BASED ON THIS SCENARIO
The business rules for a company information system are: An employee (defined by: EmployeeID, FirstName, LastName, Address) works in exactly one department. A department (defined by: DepartmentID, Location) has at least one employee. A department works on at least one project(defined by: ProjectID, DueDate).Each project is carried out by only one department.§A manager (defined by: ManagerID, Position) manages exactly one department. Each department has exactly one manager.-- Note: EmployeeID, DepartmentID, ProjectID, andManagerID are unique identifiers.