|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Is this table in correct form ?
Hi,
I am coding and I found out that there is an error somewhere. Soo I need to redo the function but I have problems to manage that table, it is hard to work with. Soo I would like to know if it has been implemented correctly ? Just look like it's wrong cause a lot of the time you will have cell that will be empty. But my supervisor, is telling me that's it's right and there is no problem with it. May be, but couldn't it be better ? (foreign key) NoEmpl (int) (foreign key) NoRel (int) Releveremisa (boolean) DateRemisA (Date-Time) ReleveRelevePar (boolean) DateRelevePar (Date-Time) CADcommandePar (boolean) DateCommand (Date-Time) CADrecuPar (boolean) DateCADrecu (Date-Time) an exemple of what's it's look now noempl noreleve releveremisa dateremisa relevepar daterelevepar ----------- ----------- ------------ ------------------------------------------------------ --------- ------------------------------------------------------ 68 345 1 2003-06-17 00:00:00.000 1 2003-06-18 00:00:00.000 68 346 1 2003-06-17 00:00:00.000 1 2003-06-18 00:00:00.000 68 347 1 2003-06-13 00:00:00.000 1 2003-06-13 00:00:00.000 68 348 1 2003-06-13 00:00:00.000 1 2003-06-13 00:00:00.000 64 349 1 2003-06-17 00:00:00.000 1 2003-06-17 00:00:00.000 64 350 0 NULL 1 2003-06-25 00:00:00.000 65 351 1 2003-07-04 00:00:00.000 1 2003-07-07 00:00:00.000 64 352 0 NULL 1 2003-06-26 00:00:00.000 65 353 0 NULL 1 2003-07-04 00:00:00.000 65 354 1 2003-07-04 00:00:00.000 1 2003-07-07 00:00:00.000 64 355 0 NULL 1 2003-06-26 00:00:00.000 64 356 0 NULL 1 2003-06-26 00:00:00.000 61 357 0 NULL 1 2003-07-01 00:00:00.000 64 358 0 NULL 1 2003-06-11 00:00:00.000 61 359 0 NULL 1 2003-06-28 00:00:00.000 61 360 0 NULL 1 2003-06-26 00:00:00.000 71 361 1 2003-09-10 00:00:00.000 0 NULL 68 361 0 NULL 1 2003-06-25 00:00:00.000 61 362 0 NULL 1 2003-06-25 00:00:00.000 61 363 0 NULL 1 2003-06-25 00:00:00.000 61 364 0 NULL 1 2003-06-26 00:00:00.000 69 365 0 NULL 1 2003-06-25 00:00:00.000 69 366 1 2003-07-01 00:00:00.000 1 2003-07-02 00:00:00.000 61 367 0 NULL 1 2003-06-26 00:00:00.000 61 368 0 NULL 1 2003-06-26 00:00:00.000 64 369 0 NULL 1 2003-07-04 00:00:00.000 61 370 0 NULL 1 2003-07-01 00:00:00.000 69 374 0 NULL 1 2003-06-25 00:00:00.000 61 375 0 NULL 1 2003-06-25 00:00:00.000 61 376 0 NULL 1 2003-06-26 00:00:00.000 68 377 0 NULL 1 2003-07-30 00:00:00.000 64 378 1 2003-06-18 00:00:00.000 1 2003-06-19 00:00:00.000 64 379 1 2003-06-18 00:00:00.000 1 2003-06-19 00:00:00.000 64 380 1 2003-06-18 00:00:00.000 1 2003-06-19 00:00:00.000 64 381 1 2003-06-18 00:00:00.000 1 2003-06-19 00:00:00.000 64 382 0 NULL 1 2003-06-25 00:00:00.000 64 384 1 2003-06-18 00:00:00.000 1 2003-06-20 00:00:00.000 Is it ok in all the form ? cause it's hard to made an algo work 100% with it in .Net without letting errors pass by it.
__________________
|
|
#2
|
||||
|
||||
|
|
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Is this table in correct form ? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|