answersLogoWhite

0

What is a database record?

Updated: 10/3/2023
User Avatar

Wiki User

14y ago

Best Answer

A database record is a row of data in a database table consisting of a single value from each column of data in the table. The data in the columns in a table are all of the same type of data, whereas the rows represent a given instance. Example Table: ========================================================== Column Names: ID FirstName LastName BirthDate ========================================================== 1 George Gray 1/6/1960 2 Thomas Green 2/29/2000 3 Cynthia Black 5/30/1976 ========================================================== For the given table above, an example of a column of data would be FirstName. All the values in that column are first names. An example record (or row) would be the record with ID = 2 which represents the record for Thomas Green and contains each field from that row. Properly designed relational databases use "primary keys" to uniquely identify records in a database. The value (or values) that compose the key must uniquely identify the entire row and only that entire row in that table. That primary key can then appear in another table to represent a relationship between that table and another table. In the example above, the ID column would serve as the primary key for the table.

User Avatar

Wiki User

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

Wiki User

8y ago

a record database is all the information about one particullar thing xx xx

A database record is all the info dealing with one particular subject A database record is a row of data in a database table consisting of a single value from each column of data in the table. The data in the columns in a table are all of the same type of data, whereas the rows represent a given instance. Example Table: ============================================================================================================== For the given table above, an example of a column of data would be FirstName. All the values in that column are first names. An example record (or row) would be the record with ID = 2 which represents the record for Thomas Green and contains each field from that row. Properly designed relational databases use "primary keys" to uniquely identify records in a database. The value (or values) that compose the key must uniquely identify the entire row and only that entire row in that table. That primary key can then appear in another table to represent a relationship between that table and another table. In the example above, the ID column would serve as the primary key for the table. Read more: What is a database record

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is a database record?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

In a database a record is a?

A record database is all the information dealing with one particular subject.


What is am entry of a database?

An entry in a database is referred to as a "record."


What is a databse record?

Database is a collection of interrelated data. One entry in a database is referred as one record.


What does the term record mean in database?

A record is equivalent to a row in a database, a collection of fields that are associated.


Which type of database model is similar to a hierarchical database but allows each child record to have more than one parent record?

Network Database


What is a file on a database?

More than one record in a Database


What is a row in a database called?

A database is said to be a collection of records and the data is stored in the table. A table consist of number of rows and columns. Row in the database table is known as a record .


How a developer of a relational database refers to a record?

A developer of a relational database refers to a single row of data as a "record." This record contains all the information related to a specific entity or object in the database.


What sequence represents the hierarchy of terms from smallest to largest from field record database and table?

field, record, table, database


What is a record in ict?

Each row in a database is called a record.


A row of data in a database is called?

In database the data is stored in the form of a table. A table can be seen as some number of rows and columns. And the row of the database table is called a record .


What is used to unique identify each record in a database?

A primary key is used to uniquely identify each record in a database. It is a special type of field that serves as a unique identifier for each row in a table.