Tables, Columns and Rows

Share this topic

Tables, Columns and Rows

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Table, Column and Rows are one of the most basics of Data World but it’s worth explaining.

Table

Description automatically generatedLet’s try to understand with an example, let’s say family is a table, how? Consider, you have 6 members in your family i.e., Grandfather = 1, Grandmother = 1, Father = 1, Mother = 1, Son = 1, Daughter = 1

A screenshot of a computer

Description automatically generated

Above is a standard average traditional family for most of us. Now, each of above members will have Name, Relationship and Date of Birth, right? These details or information are called properties and attributes of each family member and are called Columns or Fields in a table.

Table

Description automatically generatedNow, when we say Name of the eldest person in family is John, his relationship in family is Grandfather, and his Date of Birth is 1st January 1950. These details or information about one person in a family is called a Row.

Same way, when we have details or information about all the family members, we can say, we have multiple rows.

Having all rows and columns in called Table.

Table

Description automatically generatedTable Name: Family

A database consists of many tables with difference kind of dataset e.g., salary, employee, department etc.

Express your reaction

Your Take on This Insight?

Share how this content resonates with you.

Comment
Useful0
Insightful0
Actionable0
Thought-provoking0
Inspiring0

0 reactionsSign in to react or comment

Comments (0)

No comments yet.

    Free account

    You can read every topic without one. A free account lets you react to this topic, comment under it and search the Knowledge Hub. Reacting and commenting need a confirmed e-mail address.