Question
Why are duplicate tuples not allowed in a relation?
✓
Answer
Tuple refers to a row in a table that represents a set or collection of related data values. It corresponds to the relationship which represents entity type as a set of tuples, where each tuple is an ordered list of values corresponding to attributes of relation. As each tuple represents a distinct data record entity, so no two tuples in a relation (i.e. a table) can have the same combination of values for all their data items. Moreover, if a new tuple is added in the relation, then it should not reflect the existing data-values, otherwise, it will violate the uniqueness constraint and the relation as a whole will not have a minimal super-key.
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
From the following information, prepare Profit and Loss Account for the year ended $31^{st}$ March, $2019$:
→Distinguish between Sales Book and Sales Account. Difference between Sales Book and Sales Account Basis Sales Book.
Discuss the need of preparing a balance sheet.
Calculate Closing Stock from the following details:
The Trial Balance of M/s. Gupta & Sons shows a difference of $₹\ 52,200$. To prepare the Final Account on $31^{st}$ March, $2019,$ this difference is placed in a Suspense Account. Afterwards the following errors were disclosed. Pass the necessary entries to rectify them and show the Suspense Account.
→- Purchases Book total had been undercasted by $₹\ 20,000.$
- A cheque received from Vasudev for $₹\ 7,800$ had been debited in the Cash Book but not posted in Vasudev’s Personal Account.
- Returns Outward Book had been overcasted by $₹\ 10,000.$
- Goods returned by Yash Pal worth $₹\ 15,000$ have been entered in Returns Outward Book. However, Yash Pal’s Account is correctly posted.
Prepare Profit and Loss Account for the year ended 31st March, 2017 from the following particulars:-
Distinguish between Current Assets and Fixed Assets.
Determine the missing information in the following books of Drawer and Drawee:
Prepare the bad debts account, provision for account, profit and loss account and balance sheet from the following information as on March 31, 2017
Adjustments :
Bad debts ₹ 500 Provision on debtors @ 3%.
|
|
₹
|
|
Debtors
|
80,000
|
|
Bad debts
|
2,000
|
|
Provision for doubtful debts
|
5,000
|
Bad debts ₹ 500 Provision on debtors @ 3%.
On 1st January, 2019, A draws a bill on B for ₹ 1,000 payable after 3 months. Immediately after its acceptance, A sends the bill to his bank for collection. On the due date, the bill was dishonoured. Record the transactions in the Journals of A and B.