Database+and+Applications


 * __ Database and Applications: __**

Underpinning any e-business there is always a database. In this case it holds details of customers, products and orders. As with any other database, it is best managed with a DBMS, which provides applications with an interface to the underlying data. A DBMS will also prevent unintentional data corruption. MySQL is a widely used DBMS that can be accessed by many programming languages such as PHP. Many shopping cart services and other web-based applications are written in PHP interfacing with MySQL.


 * __MySQL - DBMS__**

MySQL (SQL= Structured Query Language) is a widely used DBMS for database web applications. It is used on some of the most visited sites on the internet including YouTube, Facebook, Google, Wikipedia and Flickr. MySQL is a central component of the 'LAMP web application software stack' (LAMP = Linux, Apache, MySQL, PHP). LAMP softwares are used together to support web applications. More about LAMP here - []

MySQL is primarily a Relational DBMS and does not ship with any GUI tools to administer the database. You can use the command-line interface. However GUI fronteds are available from various third parties which allow for easy database design, development and administration. Examples of the command line interface and a common GUI tool called MySQL workbench are shown below.

[]