Define candidate key, alternate key, composite key?
Answer Posted / piyush kathayat
primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.
Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.
Composite key:- A primary key that consistsof two or more
attributes is known as composite key
candidate key:- is a column in a table which has the
ability to become a primary key.
Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
Is This Answer Correct ? | 587 Yes | 62 No |
Post New Answer View All Answers
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Explain what a database is?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Write the fastest query to find out how many rows exist in a table?
Who are end users in dbms?
How would you design a database for an online site, which would average a million hits a day?
Explain about post-relational databases?
How to use online Backups?
Explain about relational database management systems?
Explain about normal forms?
What are the three types of database design?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is dbms and its application?