Question I got in the dev exam

[alec1982]

Hi guys,

Giving the attached image what is the relationship between Accounts and customers? and please give me some explanation.

Thxs

[Anonymous]

Hi Alec,

Are Three tables in screenshot are existing or AccountCustomer is link table.

please can you clarify.

if three tables are actual tables:

Account id column in Account table and Customer id  column in Customer table are primary keys.

Account id and  Customer id columns in AccountCustomer table are foreign keys

Hope this helps.

Regards

Nitha

[Anonymous · Accepted solution]

That means many-to-many relation.
Account may have multiple Customers, and Customer may be associated with multiple Accounts.  AccountCustomer table contains all associations

[alec1982]

Hi,

Well. This is a question I got in the cert exam. so not sure if the table is actual tables or two actual and a linkage table. I only remember that next to the IDs there were a yellow circle which I assume it means they are keys. and no idea what data could be in the tables to test but obviously the relationship between the accountcustomer table to the other two tables is one to many.

Hope that will give an idea to get the right answer.

Thxs for your help.

[alec1982]

Hi,

Thank you for the answer. but that wont give me the right explanation on why it is many to many? I tried to build a sample and got the relation to be one to one.. It seems to me that this is a tricky question..

Thxs,

Alec