Structure of Relational Database
Information is stored in two dimensional tables.
Columns may also be known as Attributes Values Fields Store single piece of information
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.
Server Grade databses
Microsoft SQL Server Oracle DB2 PostgresSQL MySQL
Desktop Database Applications
Microsfot Access FileMaker Pro Base (Open office libra office)