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

Database

 
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 
AnswerRe: Need help on table design Pin
Colin Angus Mackay25-Jun-07 6:48
Colin Angus Mackay25-Jun-07 6:48 
astv wrote:
Below is the current ERD:


That isn't an ERD. It is a bunch of text. I can only assume (because you haven't said) that the first bit of text represents a table name and everything in the brackets represents the columns. Perhaps the bolded text are primary keys (but who, other than you, can really know). Also a completely wilde guess suggests that the underlined columns might be foreign keys).

If you are going to describe the table structure don't assume people will understand your structure unless you tell them what it means.


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


No where in your structure is "Created By:" or "Assign To:". What does this mean?


astv wrote:
Comments and design suggestions are welcome.


I can't. I don't understand what you have, so I can't offer suggestions on how to get where you are going.


Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Ready to Give up - Your help will be much appreciated.


My website

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

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.