Recursive Relationship I have an application, which contains two Models Question and Option


Each Question has many Options
Each Option may have many Questions (and this Question may have many sub Options) so on and so forth.


Please help in how to achieve this relationship in database.
Thank You.
I would handle it like a normal many-to-many relationship, creating a table that holds question_id and option_id. Then, since you can have sub options, i would add another field containing the primary key of this table:

CREATE TABLE [question_option_rel] (
    [id] int IDENTITY (0,1) PRIMARY KEY,
    [id_question] INT FOREIGN KEY REFERENCES [question]([id]),
    [id_option] INT FOREIGN KEY REFERENCES [option]([id]),
    [parent_option] INT FOREIGN KEY REFERENCES [question_option_rel]([id])
)