Tablet004 Posted May 1, 2020 Posted May 1, 2020 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.
Ghideon Posted May 1, 2020 Posted May 1, 2020 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.
Tablet004 Posted May 1, 2020 Author Posted May 1, 2020 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
Ghideon Posted May 1, 2020 Posted May 1, 2020 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now