key
This query is : Resolved
01 April 2010
what is a candidate key,alternative key and foreign key.....
20 July 2010
A Candidate Key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called Alternate Keys.
So, An Alternate Key is any candidate key that is not the primary key. Alternate keys are sometimes referred to as secondary keys.
A Foreign Key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables.
So, An Alternate Key is any candidate key that is not the primary key. Alternate keys are sometimes referred to as secondary keys.
A Foreign Key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Difference between Date of Payment and Date of Deduction?
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Unregistered suppliers utility
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- ITR 4 and Bank transactions
- Bank details not Visible on Traces Portal
- Taxability of Partnership firm for FY 2025-26
- Need Professional Opinion - AY 2012-13 Old Demand & AY 2026-27 Refund Adjustment
- Cash balance limit and property purchases limit
- EXPORT COMMERCIAL INVOICE HSN CODE
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
