If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Incident Management Database design

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-05-07, 18:42
Future_is_bright Future_is_bright is offline
Registered User
 
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
Incident Management Database design-erd.jpg  
Reply With Quote
  #2 (permalink)  
Old 12-05-07, 20:47
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
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

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 12-05-07, 22:51
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
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
Reply With Quote
  #4 (permalink)  
Old 12-06-07, 17:26
Future_is_bright Future_is_bright is offline
Registered User
 
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 17:31.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On