storing in db with same id

Question

0.00/5 (No votes)

See more:

hello , i am working on online exam project, In that i have a query i.e. suppose we have same question for different subject ,then how to save them in database
Eg who is the HOD , IT can b asked in any subject, whether it is cs, or electronics.
so how i store these type of question in database.

Posted 13-Jan-16 18:27pm

Member 11360268

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Accepted Answer · 2016-01-13T18:43:00

If I understand your question correctly, you have a many-to-may situation. In that case you should use a structure like:
- Subject table, contains different subjects such as cs, electronics, and so on
- Question table contains individual questions
- SubjectQuestion table contains questions linked to subject.

This way one subject can have multiple questions and one question can be usied for multiple subjects. The principle is called junction table, for more information, see Junction table - Wikipedia, the free encyclopedia[^]

*dan!sh* · Accepted Answer · 2016-01-13T18:38:00

Solution 1

Without knowing your current database structure it will be a little difficult to tell you a better way. However this how it should probably look soemthing like this:

QuestionTable
    QuestionId
    QuestionText
    DepartmentId
    CourseId

Posted 13-Jan-16 18:38pm

dan!sh

storing in db with same id

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

storing in db with same id

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us