Question: Question1: Drawing Entity Relational Diagram (4 marks) Taking in consideration provided business rules and design requirements, draw a complete ERD for an organization's helpdesk system:

 Question1: Drawing Entity Relational Diagram (4 marks) Taking in consideration provided

Question1: Drawing Entity Relational Diagram (4 marks) Taking in consideration provided business rules and design requirements, draw a complete ERD for an organization's helpdesk system: Business rules: . An employee could raise many tickets. However, a single ticket is only associated with one employee . Each helpdesk agent is responsible for processing as much tickets as possible, however, each ticket is only processed by one agent. Each ticket is assigned to an appropriate IT employee to be resolved. And each IT employee is expected to resolve one or more tickets during their course of employment. Each IT employee may need to offer one or more remote assistance sessions to resolve tickets; however, every created session should be linked to one and only one ticket. An employee may review all raised tickets, and each review is associated with only one ticket. A ticket can be classified as a service request, a change request, or an incident. Each employee belongs to a department, and one department includes many employees. Note: Helpdesk staff are contractors and not regular employees. However, an IT employee or any employce from other departments are considered regular employees. ERD requirements: Show relationship strength. Show relationship participation. Add all relevant primary and foreign keys. Add appropriate cardinality. Add at least two attributes in every entity (besides necessary keys)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!