is this database diagram is correct?

siamandm · Post by **siamandm** » 28 Mar 2024, 06:04

Hello All,
I have this table and want to create database for it, i have created this diagram for it, could you please help me to enhance it

Screenshot 2024-03-28 090401.png

Post by **HansV** » 28 Mar 2024, 09:20

Are Standard Test Methods specific to a Test Name, or could one Standard Test Method be used for several different Test Names?

siamandm · Post by **siamandm** » 28 Mar 2024, 10:15

It happens one Standard Test Method be used for several different Test Names, but rarely

Post by **HansV** » 28 Mar 2024, 11:10

And could one test method be used for different tests?

siamandm · Post by **siamandm** » 28 Mar 2024, 11:24

the only possible is many method for one test name not the other way

Post by **HansV** » 28 Mar 2024, 12:15

I'd do it like this, since the test method uniquely defines the test name:

S2530.png

The part to the right of the QualityTestReport table remains the same.

PS The above is just a picture, it's not from Access.

siamandm · Post by **siamandm** » 28 Mar 2024, 12:21

thank you very much for the help,
so it will become like below? :

Screenshot 2024-03-28 152034.png

Post by **HansV** » 28 Mar 2024, 12:31

Yes, indeed.
Check the spelling of the table name PerfromredBy - you probably meant PerformedBy

siamandm · Post by **siamandm** » 28 Mar 2024, 12:40

I will fix the spelling
thank you a lot for all the supports,

Eileen's Lounge