relational database

Upload: joanne-ario-billones

Post on 08-Jan-2016

5 views

Category:

Documents


0 download

DESCRIPTION

Relational Database

TRANSCRIPT

Relational Database

Relational DatabaseRelation a two dimensional table with the following characteristics:

Entries are single valued.Each column has a distinct name.All values in a column are values of the same attribute.Order of column is immaterial.Each row is distinct.Order of row is immaterial.Primary key is the column that uniquely identifies a given row in that table.Relational database a collection of relations.

Query by Example users ask their questions by simply entering column names and other criteria using an on screen grid.Query is a question represented in a way that the DBMS can recognize it.