Structure of Relational Database

Relations/Tables

Information is stored in two dimensional tables.

Colums

Columns may also be known as Attributes Values Fields Store single piece of information

Rows

Records Made of a series of values Every record in the table has an identical structure horizontaly Each record represent a single entity for exame a single user in the table

Rules of Relations

Cells contain single values for example address is saved in sepreate fields like county, city, zip, street, area Colums store a single type of information Column names are unique Order is insignificant. Rows are unique.

System Categories

Server Grade databses

Microsoft SQL Server Oracle DB2 PostgresSQL MySQL

Desktop Database Applications

Microsfot Access FileMaker Pro Base (Open office libra office)