Re: Is this a cross tab/pivot table, or what?
Could you describe the columns under discussion in terms of dependence/independence? My references do not include that language. The xx_id's are rather transparently keys to other tables and they are most certainly 1:1, 1:m or m:n because of the one field rental_id.
The graphic that comes with representing MySQL Workbench's analysis of Sakila show inventory_id and rental_id as being m:1 even though the sample records provided are 1:1 as near as I can tell.
Without details on the fields and tables involved, the examples at artfulsoftware are not very useful.
The illustration at http:\\www.stardata.it/sakila/sakila.html does not show rental_id at all.
Please, if anyone else has anything to add, feel free.
Subject
Written By
Posted
Re: Is this a cross tab/pivot table, or what?
April 04, 2006 11:10PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.