answersLogoWhite

0

How much types of keys are available in dbms?

Updated: 8/18/2019
User Avatar

Wiki User

9y ago

Best Answer

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 .

User Avatar

Wiki User

9y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

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.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

There are five types of keys in database management system.

These five keys are surrogate, primary, candidate, alternate, foreign keys .

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How much types of keys are available in dbms?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What types of locking office file storage are available?

There are many types of locking file storage out there. There are cabinets with keys or padlocks. You should know how much you want to spend before you go. A depot or office store would have what you are looking for in home office supplies.


How lives are saved when much needed types of blood are readily available?

ever


How are lives saved when much needed blood types are readily available?

ever


What types of products are available to purchase from GO Home Ltd?

The types of products available from GO Home Ltd are: home furnishings, giftware and accessories. This includes: seating, mirrors, lighting and much more.


How lives are saved when the much needed types of blood are made available?

brgrjhloulylop km;ppk;pi


Do The DBMS reveal much of the databases internal complexity to the application programs and users?

From Database Systems: Design, Implementation, and Management 10th Ed - Coronel / Morris / Rob - 1.3.1 Role and Advantages of the DBMS: The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS. Figure 1.2 emphasizes the point that the DBMS presents the end user (or application program) with a single, integrated view of the data in the database. The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the database's internal complexity from the application programs and users. The application program might be written by a programmer using a programming language such as Visual Basic.NET, Java, or C#, or it might be created through a DBMS utility program.


How much keys are in a piano?

88


How much does Brent Keys weigh?

MLB player Brent Keys weighs 210 pounds.


How much does walmart charge for cutting keys?

Walmart does not charge for cutting keys.


How much keys did forte piano have?

88


How much keys in normal keyboard?

105


How much does Coco keys cost?

20$