Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007
    Posts
    2

    Incident Management Database design

    hi techies

    I am creating a database for a big telecommunications and networking company as a project free of cost. It is an incident management system.

    Any feedback will be appreciated. I have made a simple ERD of the database that i wish to create.

    Have i missed anything?
    Attached Thumbnails Attached Thumbnails ERD.jpg  

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Future_is_bright
    I am creating a database for a big telecommunications and networking company as a project free of cost. It is an incident management system.
    i give you full marks for a very inventive attempt at disguising your homework assignment

    Quote Originally Posted by Future_is_bright
    Have i missed anything?
    yup

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Quote Originally Posted by Future_is_bright
    Have i missed anything?
    Without reading the assignment or talking with your teacher, I can't see how we might know if you've missed anything.

    -PatP

  4. #4
    Join Date
    Dec 2007
    Posts
    2
    Thanks for your feedback. Here are some requirements of the system:

    1. keep track of whats being done for a raised incident
    2. Measure staff performance on handling the incident
    3. Reports for the incidents that are nearing thier due time (for which they should be resolved)
    4. compliant with ITIL framework for incident management
    5. On demand report
    6. Bill needs to be created if applicable to that incident

    Scenario:

    The telecommunications company that i am making this for, is given name company TelX.

    Scenario:
    company Telx recevies a request for putting new fibre optic cabling in 24 manchester street, from its client. The company assigns a technician to the task, and they want to monitor what progress is being made.

    Now, what have i missed in the ERD?
    Last edited by Future_is_bright; 12-06-07 at 18:31.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •