Purchase Solution

PHP and MySQL Benefits of relational databases

Not what you're looking for?

Ask Custom Question

What are the benefits of using relational databases in the development of interactive web applications? What is redundant data and why should it be avoided in a relational database?

Purchase this Solution
Solution Summary

This solution helps explain the benefits of using relational databases in the development of interactive web applications. It discusses redundant data and why it should be avoided in relational database.

Solution Preview

PHP and MySQL Benefits of relational databases
What are the benefits of using relational databases in the development of interactive web applications? What is redundant data and why should it be avoided in a relational database?

SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. The SQL used is "ANSI", or standard SQL.

SQL is designed for a specific, limited purpose — querying data contained in a relational database. As such, it is a set-based, declarative computer language rather than an imperative language such as C or BASIC which, being programming languages, are designed to solve a much broader set of problems. Language extensions such as PL/SQL are designed to address this by turning SQL into a full-fledged programming language while maintaining the advantages of SQL. Another approach is to allow programming language code to be embedded in and interact with the database. For example, Oracle and others include Java in the database, while PostgreSQL allows functions to be written in a wide variety of languages, including Perl, Tcl, and C.
sQL has keywords is the Data Definition Language (DDL). ...

Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • PHP and ASP are both well suited for web development

    MySQL, Oracle, PostgreSQL and in some cases you can also connect to Microsoft SQL Server, whereas, ASP.Net was developed by Microsoft to work with Microsoft Access, and Microsoft SQL server databases.

  • How to connect to a database with php

    Best Regards, It is becoming more and more common for internet applications to use a database in their operation. This solution demonstrates how to connect to a MySql database in a php script.

  • Database Models

    Hierarchical, Network, Relational, and Object-Oriented Of the four types of databases listed above which designs are used for the following websites?

  • SQL and Differences in Implementation

    SQL was created to test a database system based on Edgar Codd's paper on Relational databases "A Relational Model of Data for Large Shared Data Banks" [1]. Its creators Donald D. Chamberlin and Raymond F.

  • Relational Database Components

    Relational databases include databases like SQL Server, Oracle Database, Sybase, Informix, MySQL. We call the Relational Database Management Systems.

  • Server-side Scripting Language and Database

    Not only is MySQL the world's most popular open source database, it's also become the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.)

  • A MYSQL and PHP Project

    This specific project uses MySQL and php.

  • PHP Code: Databases

    You also must have created a user (with a password), and you must know the name of the database to which you want to connect. The mysql_connect() function is the first function you must call when utilizing a PHP script to connect to MySQL.

  • Retail company to convert data in Microsoft Excel spreadsheets

    Out of all the benefits, one of the major usefulness and benefit to converting data into a relational database is the ability to track data.

View More Related Solutions