Database Systems - Intro to Tables, Columns, and Rows

Relational database data is structured into:
- table - a collection of data placed in columns and rows, similarly to an Excel table. Tables must have at least one column and row, otherwise it is called an empty table
- column - a set of values that are the same type. Each column has a unique name
row - a set of values across all columns, one value for each column.
cell - one data value, or a single column of a single row.

Each column also has a data type that defines that type of data that can be stored in each row within the column. Ex: Integers, text or floating-point numbers.

In addition to a name, each column has a data type, which defines the format of the values it can store. When the table is created using SQL, that is when you specify the columns name and data types. The DBA is capable of changing a tables column name or data type, but this is rare. However, database users have the ability to add, delete, and update the data in rows.

Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!

[learnabouttechwithme]

Sir aaj hmare computer ke exam me ek mcq aya tha.. Usme sir mujhe confusion hai.. Please bta do..

Que. : A collection of related rows within a database is known as:
A) Table
B) Database
C) Field
D) None of these

Sir right answer kya hoga..??