Viewing 5 posts - 1 through 5 (of 5 total)
"Why don't you want to make supplier and machine column accept null?"
Because I think it would be incorrect.
One of the transaction is that Supplier gives fuel to operator so supplier...
August 16, 2022 at 5:15 am
You got everything correctly over here
"How do you intend to track "transactions"? I seem to be that the operator gets a "batch" of fuel and then the operator give that...
August 15, 2022 at 4:40 am
Yes, I was thinking about that too. But I don't know what should be in the 3rd main table.
Should it be
MainTable(id, DieselReceived_ID, DieselTaken_ID) ?
August 15, 2022 at 2:09 am
I intend to learn database design. I watched 1NF, 2NF, 3NF and BCNF on youtube. But still I am not able to understand it properly and cannot use them correctly....
August 14, 2022 at 7:06 pm
Like this?
DieselReceived(id, supplier, operator, taken_time)
DieselTaken(id, operator, machine, given_time)
Is this okay?
August 14, 2022 at 6:51 pm
Viewing 5 posts - 1 through 5 (of 5 total)