I see that there are junction tables in DBMS (http://en.wikipedia.org/wiki/Junction_table) but i need to know if generaly the relationships between tables can be shown as tables themselves. If this is true how can i distinguish between the entity tables and the relationship tables.
spyros.lois
0
Newbie Poster
AleMonteiro
238
Can I pick my title?
As far as I know, Junction Table is only a concept. It's the functionality of the table, it's the purpose of the table.
But it's a normal table, with fields, relationships and primary keys if needed.
I don't know any DB Manager that display Junction Tables as any thing different than a table.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.