I am newbie in this field.
I need to design database. Abstract: there is a counter in every apartment, which is monitoring utility bills. Payments for gas and electricity. There are many houses in a city, but there is only one counter in one apartment. I need to create proper database.
I suppose that it looks like 'one-to-many' connection, so:
First table: id_counter (primary key), address
Second table: id_counter, cubicmetre_amounts
Third table: id_counter, consumed_Vt
Do I understand it correct, is it really 'one-to-many' and if so, what should be the primary key in a second and third tables?
Thanks in advance!