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 5: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

Business Impact Analysis(BIA): Assessing the Potential Impact of a Cybersecurity Incident on Business Operations
In today’s highly interconnected society, businesses depend on technology even more than before. While offering opportunities for innovation and creativity, businesses are exposed to various cybersecurity threats that can disrupt operations, damage reputation, and result in substantial financial losses. It is crucial to carry out a comprehens...
In today's ever-evolving market, businesses must adapt swiftly to remain competitive and meet the needs of a fast-paced digital economy. Among the various business strategies available, digital transformation, customer-centricity, and sustainability have emerged as top priorities. Let’s explore why these strategies are critical for busine...
The Cisco Certified Network Associate (CCNA) certification is a pivotal credential for networking professionals, validating your skills in networking fundamentals, security, automation, and programmability. Preparing for the CCNA exam can be challenging, but with the right strategy, resources, and mindset, you can successfully achieve this certific...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC