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 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 
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 
My apologies. What I have posted are the tables and fields. I followed how my book on how to describe the tables and fields. I tried to paste an image of my ERD but I could not figure it out.

[Table Name]([PK], [FK], [Other Fields])

The fields "Created By" and "Assigned To" are a part of the ASSIGNMENT table. Again I apologize, I missed this two fields. Since, "Assigned To" can have multiple values, this may have to be normalized. This is the piece that is unclear to me.

Another is, if a task is reassigned to a different user, I may want to know who reassigned this specific task.

Thanks for your response.



Steve C.
kstv@netzero.net

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 
AnswerRe: Select unique column??? Pin
Colin Angus Mackay24-Jun-07 22:31
Colin Angus Mackay24-Jun-07 22:31 
GeneralRe: Select unique column??? Pin
Doan Quynh24-Jun-07 22:49
Doan Quynh24-Jun-07 22:49 

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.