topic Re: Question I got in the dev exam in QlikView

Question I got in the dev exam

alec1982 — Sun, 15 Jun 2014 03:03:47 GMT

Hi guys,

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

Thxs

Re: Question I got in the dev exam

Anonymous — Sun, 15 Jun 2014 12:54:47 GMT

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

Re: Question I got in the dev exam

Anonymous — Sun, 15 Jun 2014 14:01:38 GMT

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

Re: Question I got in the dev exam

alec1982 — Sun, 15 Jun 2014 15:55:09 GMT

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.

Re: Question I got in the dev exam

alec1982 — Sun, 15 Jun 2014 15:57:22 GMT

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