Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  which apprach is better to to introduce an ID field or combine other fields
Previous Previous
 
Next Next
New Post 7/10/2011 3:00 PM
User is offline John_DB
1 posts
No Ranking


which apprach is better to to introduce an ID field or combine other fields  

I have the following problems when i am designing my database for an online exam system:-
1. I have a question table and answer table; where each question contains many answers and each answer have one question.
Now i have two approaches for designing the answer table, either by having:-

Answer_Id (PK),
Answer_Description,
Is_right.
Question_ID (FK)

Or

Answer_description
Is_right.
Question_ID (FK)
Having PK (Question_ID & Answer_description).

2. Same issue applies for this scenario; I have an article table and a comment table, where each article can have many comments and each comment can belong to an article.

Now i have two approaches for designing comment table, either by having:-
Comment_ID (PK)
article_ID (FK)
Comment_Desc
Created_BY
Created_time

Or

article_ID (FK)
Comment_Desc
Created_BY
Created_time

Having PK(Created_BY & Created_Date), since it s not possible to be able provide two comment at the same time!by the same user!!

So is it better to introduce the ID field for both (comment & answers) tables or having my PK by combining the available columns
Thanks in advance for any help.

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  which apprach is better to to introduce an ID field or combine other fields

Community Blog - Latest Posts

As Business Analysts in Agile teams, we often hear about Definition of Ready (DOR) and Definition of Done (DOD). But beyond the buzzwords, these two concepts are powerful tools to drive clarity, consistency, and quality in our work. Definition of Ready ensures a user story is truly ready for development. It answers: Is this story clear, feasible...
In today's fast-paced digital world, successful projects aren't just built on great code—they're built on clarity. And that clarity often comes from one key player: the Business Analyst. At the heart of every great product or system is a need—a business goal, a customer pain point, or a regulatory requirement. But busines...
I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC