Find Jobs
Hire Freelancers

Database Design For an IT Helpdesk

€8-30 EUR

Closed
Posted over 3 years ago

€8-30 EUR

Paid on delivery
I would like a Database designed and normalised, it doesn't have to be converted to SQL insert tables. I jsut want the Entity Relationship Diagrams and Entity relational Schema and an explination of approach to normalise the DB. May I request: If you respond to the advertisment, the reason for seeking someone is to discuss database design approaches. It will only take some time Sunday the 27th, a couple of hours, in order for me understand the approach you used to me please. I have my own solution for this problem, someone who would even skype call me and analyse my own solution would be a great alternative. Help desk Scenario A company with a large IT function is setting up an IT Helpdesk to handle hardware and software problems concerning the IT systems. Whenever anyone within the company has a problem they can contact the helpdesk. One of the hardware and software problems concerning the IT systems. Whenever anyone within the company has a problem they can contact the helpdesk. One of thehelpdesk operators will attempt to deal with the enquiry, but if an immediate answer cannot be given the problem is passed to one of several specialists. An Information System is needed to log and track the helpdesk queries. This will enable analysts to see how the equipment is performing overall, whether the helpdesk specialists are sufficiently resourced to solve problems in an acceptable time, and whether there are subject areas where training should be given to employees. Proposed System Operation When a new call comes into the helpdesk the names of the caller and helpdesk operator are logged along with the time of the call, the serial number of the computer and, if relevant, the operating system and software being used. The caller’s name will be checked against a register of all personnel to retrieve the callers' ID number, job title and department. The equipment will also be checked against a register of equipment to find the equipment type and make. The software will be checked to see if it is under a valid license. Every call is logged and each problem is given a problem number and this is supplied to the caller so it can be quoted on any subsequent calls about the same problem. The helpdesk operator will also record notes and descriptions of the problem. A reason for each call is always recorded even if it is, in the case of a follow-up call, just a note to say how desperate the caller is getting. When a problem is first reported the helpdesk operator will also allocate a problem type, selecting it from a list of problem types. It is the skill of the operator to know what problem type is most relevant and how specific the problem is. Some problem types are refinements of more general problem types and so it is possible that the problem type allocation may be altered at a later time if more information becomes available. When the problem area is identified the helpdesk operator can lookup previous problems of the same type to see if the problem has occurred before and if so how it was resolved. It is also possible to lookup previous problems with thesame equipment or from the same caller to see if there were other related problems. If the problem can't be solved immediately the helpdesk operator will use the system to look up which specialist to refer the problem. Each specialist will be an expert in one or more problem types. If there is no specialist listed for a more specific problem type then a specialist from the more general problem type will be used. The system will also list how many problems the specialist is currently working on so that if there is more than one specialist for a problem type, the specialist who is currently the least loaded can be allocated. When a problem is eventually resolved, the helpdesk operator or the specialist will log the date and time it is resolved and record some indication of how the problem is resolved and the time taken to resolve the problem.
Project ID: 27525000

About the project

5 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average €72 EUR for this job
User Avatar
Hi, I'm an expert in database development. I can easily do this project for you. We can have a chat about it. Thanks.
€120 EUR in 5 days
4.9 (5 reviews)
3.7
3.7
User Avatar
Hi Greetings From MDS! I have several years of expertise in defining architecting and designing applications from scratch , Worked on desining sql and nosql applications. I can provide normalized schema for your requirement mentioned. Do you have any preference of the tool to be used? What database is the system planned to be implemented Kindly respond to start on this. Thanks MDS
€50 EUR in 3 days
5.0 (2 reviews)
3.2
3.2
User Avatar
I have experience in database development and design. I'm interested in your project . Kindly come to chat for further discussion on your project
€8 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HI, I have 8 years of experience in datawarehousing domain . I have worked on database like Oracle, SQL server, Teradata and Netezza
€30 EUR in 7 days
0.0 (0 reviews)
1.5
1.5
User Avatar
Hello Client, I have a 15 years of experience in developing database applications on Oracle Database. Please, contact me to discuss more information about your job. Regards.
€150 EUR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MALTA
Malta
0.0
0
Payment method verified
Member since Aug 1, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.