Database is used to store information like your customer’s information – first name, last names, email address, address, and etc… Database is very useful on a dynamic website (type of website that needs frequent change of content like news, e-commerce, blog, and etc…), because you can easily retrieve, save, update, and delete data.
Database is composed of tables. A Table is composed of rows of data just like what you see in your excel file. (See Image below)
The text in blue at the top of each column is called “field name“, in excel it is called column title. Field names are very important because these serves as the labels of your data, you cannot either create a table without “field names“.
Suppose, we will store basic information of our client:
- First Name
- Last Name
- Middle Name
- Email Address
The first thing that we need to do is to create a database name “user” and a table name “user” having a field names of first_name, middle_name, last_name, and email. Our database structure would be the same as the image below.
I’ll teach you on how to create a database and table, on my next topic.