Nichelle K. Norris IS 373: World Wide Web Standards

Nichelle K. Norris IS 373: World Wide Web Standards

City # City Name 1 Boston 2 London 3 New York 4 Los Angeles Everyone uses databases for many different reasons, and each database has many different sources of information.

A Database is simply a set of related information. Example: Phonebook Relational Databases were developed in the 1970s by Edgar F. Codd (IBM) Relational Databases are multiple sets of tables that hold specific information for one record. This was developed in order to properly organize the data into a system that was easier to gather the information for one instance.

A query is a request for specific information from a database.

Codd’s definition of the relational model, he proposed a language called DSL/Alpha for manipulating the data in relational tables. IBM commissioned a group to build a prototype language based on Codd’s ideas. Originally called SQUARE but after some refinements it was changed to SEQUEL. The acronym SEQUEL was later changed to SQL because "SEQUEL" was a trademark of the UK-based aircraft company.

SQL is an ANSI (American National Standards Institute) standard and there are many different versions of the SQL Versions. There Are 4 Version of SQL

It is Divided into two segments SQL DDL (Database Definition Language) SQL DML (Database Manipulation Language) Some databases require a semicolon at the end of each statement. SQL DML Consists of the commands for query requests. SELECT UPDATE DELETE INSERT INTO

SQL DDL Consists of the commands for tables to be created or deleted. CREATE DATABASE ALTER DATABASE CREATE TABLE ALTER TABLE CREATE INDEX DROP INDEX Not CaSe SeNsItIvE

SELECT * FROM Persons SELECT * FROM Book WHERE price 100.00 ORDER BY title;

SQL is used in a variety programs that people use everyday Websites (facebook, shopping websites) Oracle Microsoft Access Microsoft SQL Servers MySQL

SQL seems to have a strong community backing with hundreds of forums. SQL is a reliable standard because the main commands are still the same despite the version that is in use.

Security? No Security Issues Privacy? There are no privacy issues since this is strictly for database manipulation

SQL is a reliable standard It’s simple enough for anyone to use. Universal amongst relational database design. Used in countless ways all over the world. SQL structure has been the same since it’s conception over 40 years and probably won’t be changed for at least another 30-40 years.