Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

mple 10. Determine d dx S 0 t dt.

Answered: 1 week ago