Full screen

Share

A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key. Each table can only have one primary key.
WHAT IS A PRIMARY KEY?
Contact
Team
What makes us unique
Actual state
Activity
Executive summary
Want to create interactive content? It’s easy in Genially!

Transcript

A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key. Each table can only have one primary key.

WHAT IS A PRIMARY KEY?

Contact

Team

What makes us unique

Actual state

Activity

Executive summary

A foreign key is a field (or fields) in one table that references the primary key in another table.

WHAT IS A FOREIGN KEY?

Contact

Team

What makes us unique

Actual state

Activity

Executive summary

Introduction here

WRITE A TITLE

NullThe Null value indicates that the Variant contains no valid data. Null is not the same as Empty, which indicates that a variable has not yet been initialized.

TableTables are essential objects in a database because they hold all the information or data.

Informationfacts provided or learned about something or someone.

data information that has been translated into a form that is efficient for movement or processing.

VOCABULARY

Contact

Team

What makes us unique

Actual state

Activity

Executive summary

FieldContains data about one aspect of the table subject, such as first name or e-mail address.

RecordContains specific data, like information about a particular employee or a product.

Filecan control access to data in specified tables and columns, or to tables and columns for which access is not granted explicitly.

Contact

Team

What makes us unique

Actual state

Activity

Executive summary

Show interactive elements