i wanted to create a table name booking that have 3 composite key where 2
of the composite key is referring to each another table named customer and room.
however when i wanted to create the table, it give me error. can someone tell me
how can i fix this.
isn’t that primary key that referring to another primary key in another table is called as ‘composite key’?
i’m not not really aggree when you said that i’m actually wanted to declare is a foreign key. or, am i wrong in understanding this ‘composite key’ term? if so, someone please explain to me…
i’m sorry, i’m not expert in database i just started to learn it and stil learn about it.
however, here’s the relationship below and i really thinks what i’m trying to achieve is not foreign key but composite key…