Click here to Skip to main content
15,885,278 members
Home / Discussions / Database
   

Database

 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus25-Jun-07 10:29
Ryan Andrus25-Jun-07 10:29 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Arun.Immanuel25-Jun-07 21:05
Arun.Immanuel25-Jun-07 21:05 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus26-Jun-07 3:46
Ryan Andrus26-Jun-07 3:46 
GeneralRe: Is it possible to access a row in a datatable in constant time? Pin
Ryan Andrus26-Jun-07 5:08
Ryan Andrus26-Jun-07 5:08 
QuestionHow to upload a picture in the database & how to make the search Case sentive Pin
Bahaa Hany25-Jun-07 6:40
Bahaa Hany25-Jun-07 6:40 
AnswerRe: How to upload a picture in the database & how to make the search Case sentive Pin
Colin Angus Mackay25-Jun-07 6:53
Colin Angus Mackay25-Jun-07 6:53 
AnswerRe: How to upload a picture in the database & how to make the search Case sentive Pin
Dave Kreskowiak25-Jun-07 7:14
mveDave Kreskowiak25-Jun-07 7:14 
QuestionNeed help on table design Pin
astv25-Jun-07 6:20
astv25-Jun-07 6:20 
I am building an application similar to a help desk application. This application allows the management to assign and track all assigned tasks. The users will be a create a trouble ticket and track and update assigned tasks.

Below is the current ERD:
DEPT(DEPT_SID, DEPT_NAME)
TASK(TASK_SID, TASK_DESC)
PRIORITY(PRIRITY_SID, PRIORITY_LEVEL)
USERS(USERS_SID, USERNAME, LAST_NAME, FIRST_NAME)
STAFF(STAFF_SID, STAFF_USERNAME)
ASSIGNMENT(A_SID, STAFF_SID, PRIORITY_SID, TASK_SID, DEPT_SID, USERS_SID, A_TITLE, A_DESC, A_DATE)
ASSIGN_LOG(A_LOG_SID, STATUS_SID, A_SID, A_LOG_DATE, A_LOG_NOTES, RESOLVE_DATE)
STATUS(STATUS_SID, STATUS_DESC)

Question:
1) How do I change the design to I only use one table for "Create By:" and "Assign To:"?

Comments and design suggestions are welcome.

Thanks,

Steve C.
kstv@netzero.net

AnswerRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 6:48
Colin Angus Mackay25-Jun-07 6:48 
GeneralRe: Need help on table design Pin
astv25-Jun-07 8:58
astv25-Jun-07 8:58 
GeneralRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 9:34
Colin Angus Mackay25-Jun-07 9:34 
AnswerRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 9:45
Colin Angus Mackay25-Jun-07 9:45 
AnswerRe: Need help on table design Pin
astv25-Jun-07 10:25
astv25-Jun-07 10:25 
GeneralRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 11:18
Colin Angus Mackay25-Jun-07 11:18 
GeneralRe: Need help on table design Pin
astv25-Jun-07 11:34
astv25-Jun-07 11:34 
GeneralRe: Need help on table design Pin
Colin Angus Mackay26-Jun-07 0:04
Colin Angus Mackay26-Jun-07 0:04 
QuestionUsing the LIKE keyword in a query Pin
reegan4125-Jun-07 5:19
reegan4125-Jun-07 5:19 
AnswerRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 8:47
Kschuler25-Jun-07 8:47 
GeneralRe: Using the LIKE keyword in a query Pin
reegan4125-Jun-07 8:51
reegan4125-Jun-07 8:51 
GeneralRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 9:01
Kschuler25-Jun-07 9:01 
QuestionSQL XML 3 BulkLoad Error Pin
Panchal Hardik25-Jun-07 2:28
Panchal Hardik25-Jun-07 2:28 
AnswerRe: SQL XML 3 BulkLoad Error Pin
Dave Kreskowiak25-Jun-07 4:05
mveDave Kreskowiak25-Jun-07 4:05 
QuestionSQL CE Query Performance Pin
Ferudun Atakan24-Jun-07 22:44
Ferudun Atakan24-Jun-07 22:44 
AnswerRe: SQL CE Query Performance Pin
andyharman24-Jun-07 23:12
professionalandyharman24-Jun-07 23:12 
QuestionSelect unique column??? Pin
Doan Quynh24-Jun-07 22:26
Doan Quynh24-Jun-07 22:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.