The option Relation View is probably one of the best features available in phpMyadmin. Sometimes you are required to set foreign keys for database tables, but you do not see this Relation View option in phpMyadmin. When you don’t have this option enabled in phpPMyadmin, the first thing you should verify is, your table’s storage engine is set to use InnoDB. here i want to discuss how we can solve title error message to we can enable relation view option.

For solving problem i uninstalled xampp and i run as administrator setup in directory only C  not others ,now this error is fixed.

ERmodelRelationFig1:ER model in phpmyadmin

for more info see this link.

Keys

Keys are one way to categorize attributes. ER diagrams help users to model their databases by using various tables that ensure that the database is organized, efficient, and fast. Keys are used to link various tables in a database to each other in the most efficient way possible.

Primary Keys

Primary keys are an attribute or combination of attributes that uniquely identifies one and only one instance of an entity.

Foreign Keys

Foreign keys are created any time an attribute relates to another entity in a one-to-one or one-to-many relationship.

Foreign Key Example

Tags , , , ,


Leave a Reply

Want to see your ugly mug by your comment? Get a free custom avatar at Gravatar.