Building Tables

From Compsci1

First we start with a flat database - a database consisting of a single table.   Problems that can occur with a poorly designed table is

• - Redundancy - unnessesary duplication of data in the database

• - Multivalue field - a field that contains multiple values

• - Multipart field - a field that contains more than one data item.

  Important to remember - each subject of a database is represented by a table in the database, each characteristic of a subject represents a field in the corresponding table.  

So,

• One table, One subject

• One field, One value

• One table, One primary key

Databases

--mickdemp 16:53, 19 October 2006 (EDT)