Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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