Have you ever wondered what databases are for? Well, a database is merely a collection of information that is organized so that it can be easily accessed, updated, and managed.
Why a Database?
Databases are most useful when it comes to storing information that fits into logical categories. A database consists of organized collection of data for one or more uses. With a database you can group different parts of your business into separate tables to help organize the information logically. For example, it could store detailed data about all of the employees in a company. Example tables might be salaries, benefits, skills and data about those employees. Each table would then contain columns specific to these areas
Two flavors of a Database – Flat or Relational?
There are two types of databases. A flat database and a relational database. A flat database is just stored on a hard drive. It usually contains one record per line. Within a record, the single field can be separated by delimiters, such as a comma. An example of a flat file is a name-and-address list with the fields Name, Address, and Phone number and accessed sequentially such as a Microsoft Excel flat file. There are no applications formatted applied to the data and comma’s denotes the end of one field. Each record is written on a line in the file. A flat file is a collection of data stored and accessed sequentially.
A relational database (a collection of data organized which can be accessed or reassembled in many different ways without having to reorganize the tables) such as MySQL is much more oriented and is much often preferred over a flat database. In a relational structured database, there are tables that store data. The columns define which kinds of information is stored there such as date of birth, social insurance numbers, telephone numbers etc. The rows contains the actual values for these specified columns. Each row has 1 value for every column. Each table (which is sometimes called a relation) contains one or more data categories in columns. Each row contains a unique instance of data for the categories defined by the columns.
MySQL or Microsoft Access?
MySQL and SQL. MySQL is currently the most popular open source database server and is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications. SQL – Structured Query Language is a very powerful language used to create and query databases and is also used to manipulate the database. Some functions of SQL are modifying, dropping and inputting data from databases. SQL has become popular among web developers due to its flexibility and simplicity. With knowledge of HTML, PHP and database program knowledge a developer can create complex web sites and applications. , while relying on online web services to provide SQL back end in which the users data is stored.
Microsoft Access is a database-management application that allows you to create databases and manage and view data in a variety of ways, with reports, forms and queries. One feature that Access provides with its reports and forms is the ability for users to add controls (i.e. check boxes, text boxes and command buttons), and a programming language, Visual Basic, to make those controls perform user-defined tasks. Extending Access by using such controls lets you delete queries quickly and generally tailor Access to your specific needs.
A Microsoft Access database can only be deployed in Microsoft Windows while MySQL is a cross platform. Access is a single-user application while MySQL is multi-user. When you start to think of whether to use Microsoft Access or MySQL, the first thing to consider is what your end-user will need.
Database Development is generally the usability of the web site which is the job of the Web Developer. The Web Developer creates database for such things like login systems, blogging web sites, post articles, e-commerce, shopping web sites and much more. With all the help of the databases, all this information can be were everything is stored.