Jump to content

Recommended Posts

Posted

Can anyone provide help with drawing an ERD for this scenario 

ITHelpDesk is an online system used by the IT Department at MYCompany to manage and track user’s issues and complaints regarding their usage of computing resources in MYCompany. You are to develop ITHelpDesk System to help them improve the performance of the current situation and overcome the problems that arise nowadays. The system uses a ticket system to manage the user’s IT issues and complaints. Each ticket will contain a title, body, system specification, priority and the employee to send it to.  The employee will be added to the ticket and sends a response to the ticket. The user will receive the response of the employee. The system will contain the ability to search in a knowledge base of common issues (built by IT Department) so they can solve issues on their own if possible. An admin can generate reports from the system to track the performance of their employees and their section. 

Posted
1 hour ago, Tablet004 said:

Can anyone provide help with drawing an ERD for this scenario

I’ll give an initial hint: have you been able to list the entities that are to be included? Having the entities may help find their relations. 
 

Posted

A ticket an employee and a user and a system but I don't know how to link between them and I'm not sure if that's all of them 

Posted
3 hours ago, Tablet004 said:

I'm not sure if that's all of them 

Hint no 2:

Since this is homework and not a real situation we can start by assuming that the given text is all there is*. Then by reading the text from beginning to the end we can build a list of all mentioned "things".  

THelpDesk
IT Department
MYCompany
user
issue
complaint
computing resource
ticket: (title, body, system specification, priority, employee)
employee
response to the ticket.
knowledge base (of common issues)
admin
report
performance
employe
section

From that list you could start by checking if there are duplicates, missing stuff or some "things" that are irrelevant. 

Hint no 3: Analyse how the text states relationships**. Example: " An admin can generate reports from the system to track the performance of their employees and their section". I would interpret this as one administrator for each section and one section for each administrator. I would assume a flat structure and not a hierarchy of sections and administrators due to the statement "the IT Department"; one department.

 

*) unless the task, as in a real situation, requires the student to analyse the text and add missing entities that are needed for the system to function in a reasonable way. 
**) Note that I'm addressing this task without any clue how complex the analysis needs to be to pass. I might be biased from working with sorting out unclear and ambiguous requirements within IT. 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.