What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

0 votes
Hi!!

Can someone tell me what do  ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?
Nov 12, 2018 in Database by DataKing99
• 8,100 points
24 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

You can refer to the following definitions to understand these terms.

  • Record: Record is a collection of values or fields of a specific entity. Eg. An employee, Salary account, etc.
  • Field: A field refers to an area within a record which is reserved for a specific piece of data. Eg. Employee ID.
  • Table: Table is the collection of records of specific types. E.g. Employee table is a collection of record related to all the employees.
answered Nov 12, 2018 by darklord
• 6,140 points

Related Questions In Database

0 votes
1 answer

What is a Join in terms of database?

JOINS are used to combine rows from ...READ MORE

answered Nov 13, 2018 in Database by DataKing99
• 8,100 points
24 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,100 points
63 views
0 votes
1 answer

Do I need to add primary key in each and every table?

Hi Shraddha, You have a doubt to add ...READ MORE

answered May 29 in Database by Sampriti
• 620 points
17 views
0 votes
2 answers

Types of relationships in Database

There are 3 types of relationships in ...READ MORE

answered Aug 16, 2018 in Database by zombie
• 3,690 points
22 views
0 votes
1 answer

Django 1.7: Makemigration: non-nullable field

As the order field is unique, you'll ...READ MORE

answered May 9 in Python by SDeb
• 10,700 points
9 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,220 points
1,086 views
0 votes
1 answer

Is it possible to access Couchbase by terminal?

What you want to accomplish isn't possible ...READ MORE

answered Apr 29, 2018 in DevOps & Agile by DareDev
• 6,670 points
32 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,600 points
98 views
0 votes
1 answer

What are the ways to get the count of records in a table

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,140 points
39 views
0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by darklord
• 6,140 points
42 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.