define the term database , table , primary key, candidate key, alternate key
Answers
Answered by
2
Database is a collection of information related to a particular subject
Answered by
9
a structured set of data held in a computer, especially one that is accessible in various ways is called database.
In relational databases, and flat file databases, table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect. A table has a specified number of columns, but can have any number of rows.
A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records.
A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.
A non-primary key that can be used to identify only one row in a table. Alternate keys may be used like a primary key in a single-table select. Foreign. A unique key that has migrated to another entity. At the most basic definition, "a key is a unique identifier", so unique key is a pleonasm.
hope it helps
mark as brainliest
In relational databases, and flat file databases, table is a set of data elements (values) using a model of vertical columns (identifiable by name) and horizontal rows, the cell being the unit where a row and column intersect. A table has a specified number of columns, but can have any number of rows.
A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records.
A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.
A non-primary key that can be used to identify only one row in a table. Alternate keys may be used like a primary key in a single-table select. Foreign. A unique key that has migrated to another entity. At the most basic definition, "a key is a unique identifier", so unique key is a pleonasm.
hope it helps
mark as brainliest
Similar questions