Hi im doing a project and i need to draw up a ER diagram for a SNS with a search engine that returns results about movie reviews.

I was just thinking about the the entities involved and i thought ok..so the 3 main attributes should be User, Search, and Movie as the user enters a search and the result is a movie.

I'm just wondering are these 3 attributes form a ternary relationship? Or is it a binary between user and search and another binary between search and movie?

Thanks for the help

It depends!
Why you need to save user searches or you don't intend to?
please tell me more about your scenarios what you need to keep track on and so on; to guide you to good design.

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.