Computer Science Engineering (CSE) Exam  >  Computer Science Engineering (CSE) Questions  >  Entity set TRANSACTION has the attributes tra... Start Learning for Free
Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.
Q. Which is the primary key of the weak entity?
  • a)
    Account number
  • b)
    {Account number, transaction number}
  • c)
    {Account number, date}
  • d)
    {Transaction number, date}
Correct answer is option 'B'. Can you explain this answer?
Verified Answer
Entity set TRANSACTION has the attributes transaction number, date, am...
In order to identify each transaction of any account the key of strong entity with the addition of the discriminator of weak entity can be taken. Here [Account number, transaction number] act as the primary key of weak entity. This is because weak entity has no existence without strong entity.
View all questions of this test
Most Upvoted Answer
Entity set TRANSACTION has the attributes transaction number, date, am...
Primary Key of Weak Entity

• A weak entity is an entity that cannot be uniquely identified by its own attributes but is uniquely identified by the combination of its attributes and the attributes of the strong entity it is related to.
• In this case, the weak entity set is TRANSACTION, which is related to the strong entity set ACCOUNT.
• The primary key of the strong entity set ACCOUNT is account number.
• The primary key of the weak entity set TRANSACTION is a combination of its own attribute transaction number and the attribute account number of the related strong entity set ACCOUNT.
• Therefore, the correct answer is option 'B' {Account number, transaction number}.
Explore Courses for Computer Science Engineering (CSE) exam

Similar Computer Science Engineering (CSE) Doubts

Top Courses for Computer Science Engineering (CSE)

Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer?
Question Description
Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer?.
Solutions for Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.
Here you can find the meaning of Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer?, a detailed solution for Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer? has been provided alongside types of Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Entity set TRANSACTION has the attributes transaction number, date, amount. Entity set ACCOUNT has the attributes account number, customer name, balance.Q.Which is the primary key of the weak entity?a)Account numberb){Account number, transaction number}c){Account number, date}d){Transaction number, date}Correct answer is option 'B'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.
Explore Courses for Computer Science Engineering (CSE) exam

Top Courses for Computer Science Engineering (CSE)

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev