answersLogoWhite

0

* Alternate key - An alternate key is any candidate key which is not selected to be the primary key

* Candidate key - A candidate key is a field or combination of fields that can act as a primary key field for that table to uniquely identify each record in that table.

* Compound key - compound key (also called a composite key or concatenated key) is a key that consists of 2 or more attributes.

* Primary key - a primary key is a value that can be used to identify a unique row in a table. Attributes are associated with it. Examples of primary keys are Social Security numbers (associated to a specific person) or ISBNs (associated to a specific book).

In the relational model of data, a primary key is a candidate key chosen as the main method of uniquely identifying a tuple in a relation.

* Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. Equivalently a superkey can also be defined as a set of attributes of a relvar upon which all attributes of the relvar are functionally dependent.

* Foreign key - a foreign key (FK) is a field or group of fields in a database record that points to a key field or group of fields forming a key of another database record in some (usually different) table. Usually a foreign key in one table refers to the primary key (PK) of another table. This way references can be made to link information together and it is an essential part of database normalization

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Engineering

What object must be created first before any other types of objects are created since it is the basic unit of a database?

The first object that must be created in a database is the database itself. It serves as the foundational structure that holds all other objects, such as tables, views, and indexes. Without the database, there would be no environment to store and manage these additional objects.


What is the data schema in a database?

Logical Structure of database is know as database schema. All database entities are defined and relation between then is represented in structured way. It includes all constraints to be apply on each identity.


What is the net driver to access the database?

Question doesnt make sense. There are tens of database types availible. Each using one or two drivers.


What database types is useful for storing java applets as well as processing large numbers of transactions?

OODBMS, object oriented database management systems


Is 'A database uses characteristics such as field size and data type to define each field' false?

No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.

Related Questions

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.


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 .


What are secondary keys?

Secondary keys are the database keys that hold the physical location of a portion of a record in a database or file. They provide a secondary way of accessing the information.


What type of information is kept on a database?

All types of information may be kept in a database.


How does a database store data about its tables?

A database is used to store data in its tables by a specified number of rows and columns. Each database also uses specific cells, foreign keys, and unique keys.


What are the basic components of a database?

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


What is data set in c sharp?

An in-memory database. The database contains tables and constraints, and data.


How many Auto Keys macros can be created in a database?

4


Types of databases in sql server 2005?

Types of Database in sql server 2005:- 1.Master Database 2.Tempdb Database 3.Model Database 4.MSDB Database 5.Resource Database


When you initially create a database you define its that is you assign names and types to all the fields?

Structure


What method can you use to add a new table to your database?

To add a new table to your database, you can use the SQL CREATE TABLE statement. This command allows you to define the table's name, specify its columns and data types, and set any constraints like primary keys or foreign keys. For example: CREATE TABLE table_name (column1 datatype, column2 datatype);. After executing this statement in your database management system, the new table will be created.


What is the meaning for primary key in database?

With reference to Databases, what are Primary keys?