answersLogoWhite

0

What else can I help you with?

Related Questions

How much types of keys are available in dbms?

There are five types of keys in database management system . The name of the five keys are as follows .:1) surrogate key -which is the system generated primary key .2) Primary key - same function as surrogate key but user defined.3) candidate key -combination of two more keys.4) alternate keys - alternative for candidate keys.5) foreign key - primary key of another table.There are five types of keys in database management system.These five keys are surrogate, primary, candidate, alternate, foreign keys .


Types of keys?

There are many keys in database each having particular use. Types of keys in database are : Primary key, candidate key, alternate key, foreign key, surrogate key.


When was Foreign Keys created?

Foreign Keys was created in 1985.


Types of keys in database management system?

super key foreign key candidate key surrogate key unique key alternate key composite key compound key


Candidate key and primary key differnece?

All Primary keys are definitely Candidate Keys. A Candidate key is one which can be used as a Primary key that is not null and unique. That is one of the candidate keys can be chosen as a primary key.A Candidate key is a Unique Key and it can be used to find out any particular Tuple (row) in a table. The following are the differences between A Candidate key and a Primary Key: 1) A Unique key can be null but not a Primary key 2) On a table we can have only 1 primary key but 'N' number of unique keys.


Have foreign keys null values?

Yes Foreign key can have null value.


Who was the first African American Republican presidential candidate?

ALAN KEYS


What are the basic components of a database?

Tables, Entities, Attributes, Primary Keys, and Foreign Keys


What does the term keys mean in database?

There are six keys in database that we use . Each key serves specific functions like primary is used to identify a tuple uniquely. Keys in database are Primary, surrogate, foreign, alternate , candidate, super.


How many foreign keys can you have in one table?

one


Which word in the sentence does the prepositional phrase on the counter relate to?

"on the counter" relates to the word "keys" in the sentence "The keys are on the counter."


How do you relate tables?

You can relate the data present in multiple tables by using the concept of Foreign Keys. for example if we have an employee database that contains various details of an employee scattered in multiple tables, one column in each table can be used to logically group the data in all these tables. For example, the employee number column in each of these tables can be used to relate the data present in these tables.