IT TRICK and TIPS

Head Ads

Our Services

  • SEO on Page service
  • Keywords Planning
  • Off Page SEO Complete
  • YouTube SEO Services
  • Social Media Marketing
  • Learn IT Tricks and Tips
  • Learn Programming
  • Website Development
  • Quality Content Writing
  • Website Analysis
  • Website Speed Optimization

Ads2

Related Posts

Showing posts with label create database on localhost. Show all posts
Showing posts with label create database on localhost. Show all posts

Friday, August 16, 2019

What is a Relational Database | what is relational database with example

What is a Relational Database | what is relational database with example

What is a Relational Database  what is relational database with example
What is a Relational Database  what is a relational database with example

Introduction:

It was 1970 when E. F. Codd purposed a new term relational database. In a relational database, data is accessed in tables. It based on SQL (Standard Query Language). It was 1970 when E. F. Codd in IBM introduced an organizing relational database management system (RDBMS) in columns and rows. And this organizing table consists of relation, attributes, row, tuple, foreign key, and primary key, etc. 
This database is classified into other types. This article will explain all the above information. This article focused on the relational Database management system instead of Database management System. 
RDBMS Rational Database Management System:

Just as a database management system, relational database have own management system, We can define it as “Software, online server or the website used for the management of database is called relational database management system”. It is shown in tabular form.

Structure of RDBMS:

According to the definition, it consists of columns and rows. For example, you have an order-taking company you should be creating a relational Database. You will create four basic columns, Name of customer, Order of customer, the number of products and Address or phone number. Then in rows, you will put information.

Let’s discuss some terminologies:

  1. Database store in the table that is called “relation”.
  2. Columns are “Field”. Information stores in rows called “record”.
  3. The primary key is an identifier key which identify the record,
  4. Foreign key act as a bridge and create a link between to tables.

“Domain” is an area of information on the computer. It is used for commercial purposes.

Some most important examples of rational database management systems are given below:

  1. MySQL
  2. Oracle
  3. Microsoft Access
  4. MS SQL server
  5. IBM DB2

These software and websites provide us the opportunity to store rational database
Do you know there is a difference between DBMS and RDBMS?
DBMS and RDBMS are not the same terms but we consider these terms are the same and mix both in exams. 
     So the difference between both DBMS and RDBMS is given below:

DBMS
RDBMS
      ·         It store information in files.                            
·         It store information in tables.

Components of the relational database management system:
Each database consists of several components in which it works accurately, easily, and we can manage it. RDBMS also consists of three components:
  1. Data structure
  2. Data integrity
  3. Data Manipulation

Data Structure:

It is the first component of the relational database, and we can define it as “Structure that is designed to store and organize data is called Data Structure”. It includes:
  1. Table: It consists of rows and columns; it is the structure of the database.
  2. Record: it store information, these are rows of the table.
  3. File: it is used in data processing, and used to store all records.
  4. Array: It is used to store data; SSDs and HHDs are used to store and describe data.
  5. Algorithms: it deals with SQL, to solve problems.

Data Integrity:

It is the second component of RDBMS; it deals with the accuracy and security of data. It includes:
  1. Data Encryption
  2. Access Control
  3. Data Backup
  4. Data Validation
  5. Input Validation

Data Manipulating:

It is the third component of data, it deals with programing, Or SQL language, it includes:
  1. Inserting-Information
  2. Deleting-Data
  3. Modifying Or Updating data etc.

Advantages of RDB:

  1. It stores data in the table.
  2. It gives Accuracy feature.
  3. It is flexible and can deal with Complex SQL.

Conclusion:

After seeing Structure of RDBMS, Some features of RDBMS, Component of RDBMS and advantages of rational database we can say that it is more easy, flexible and efficient than a simple database. Rational database management system is used in many pharmaceutical and business relating companies. The most important feature of this system is the tabular form, it is easy to use and store accurate data.


Tuesday, June 11, 2019

How to create a database | MySQL create database

How to create a database | MySQL create the database

how to create a database
how to create a database

Follow instructions to create a database in MySQL on localhost.

  1. Make sure your XAMPP or WAMPP server setting is started.
  2. Open the browser and put localhost/phpmyadmin URL into it.
  3. Press enter key on your keyboard.
  4. A new window will appear.
  5. Click on new to create a new database.
  6. after click you will see a new option Create database here you will have to put database name and click on create button.
  7.  after the click, your database is created.
  8. Now you need to create a table for your database. 
  9. Give a name to the table and give the number of columns in your table. 
  10. Click on the Go button.
  11. Give a name to data and put the type of data you want to enter in the database.
  12. Decide the length of data you want length in your database 
  13. Click on the Save button to save your table information. 
  14. Your Database and table are created.

Check the video on how to create a database MySQL create database and table




if you have any further query I am here to solve your query ask me in the comment I will solve your problem.