How to plan to create a table in the database?

 A table is used to hold your records or rows related to some entity.

An entity is something about which we manage some data e.g. Books in a library, Customer of an e-commerce website, User having an Instagram account, Student in a college.

We need to indentify the columns or the fields to be stored while managing records of such entities e.g.

Book can have columns or fields like Book Number, Title, Author and Price

Book Number

Title

Author

Price

101

Data Analytics for Beginners

Rohit Kumar

400

102

Data Analytics for Professional

Sanjay Sharma

500

103

Business Analytics for All

Neeraj Verma

500

104

SQL Programming

Dr B P Sharma

700

105

Python Programming

Dr B P Sharma

900

 

Student can have columns or fields like Roll Number, Name, Email, Mobile and Fees

Roll Number

Name

Email

Mobile

Fees

1234

Harish Kumar

harish@gmail.com

9899999999

89000

1235

Kapil Sharma

kapil@yahoo.co.in

9888888888

45000

1236

Nitin Verma

nitin@hotmail.com

9877777777

90000

1237

Ritesh Khanna

ritesh@gmail.com

9866666666

32000

1238

Tarun Kumar

tarun@outlook.com

9855555555

56000

 

If we try to issue a book to some student, we can also manage that data using a relational table having data about a Book as well as Student.

IssueBooks table can have columns of fields like Book Number, Roll Number, and Issue Date

Book Number

Roll Number

Issue Date

101

1234

2023-11-12

102

1235

2023-11-16

103

1236

2023-11-16

Comments

Post a Comment

Popular posts from this blog

What SQL can do?

SQL can  perform various database operations like ·          Create and remove of database ·          Create, alter and remove the tables ·          Insert, update, delete and retrieve the records ·          Controlling the user access ·          Managing transactions during insertion, updation and deletion of records
Read more

What are different data types to manage data in the columns or fields?

Every column or field related to some entity has to manage a kind of data known as data type. In general, data can be of three types ·          Numeric type Data ·          String type Data ·          Date type Data Different RDBMS software provides different keywords to define the data type e.g. MySQL provides data types such as ·          INT for integer data numeric data e.g. Book Number ·          FLOAT for floating type numeric data e.g. Price ·          VARCHAR for variable length strings e.g. Name, Email ·          CHAR for fixed length strings e.g. Pin Code, Mobile Number ·          DATE for managing dates e.g. Date of Birth Remember that, ...
Read more

What is SQL?

Image
Structured Query Language (SQL) is the standard language for storing, manipulating and retrieving data in databases using special software known as Relational Database Management Systems (RDBMS). There are many RDBMS softwares available to store and manage the structured data. Some of the RDBMS softwares are MySQL, MariaDB, Oracle Database, Microsoft SQL Server, PostgreSQL, SQLite etc. SQL is case insensitive language. SQL became a standard of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987
Read more