Table

Row

Column

Cell

To ensure that the anomalies doesn’t occur

To reduce data or storage redundancy

To ensure easy for record searching/finding

All the above

Full Functional Dependency

Partial Functional Dependency

Transitive Dependencies

There are no functional dependencies.

There are no null values in primary key fields.

There are no repeating groups.

There are no attributes that are not functionally dependent on the relation's primary key.

Remove any functional dependencies from both relations

Assign both relations the same primary key field(s)

Create a primary key(s) for the new relation

Must meet 2nd normal form

All the non-key attributes must depend on another non-key attribute

All the non-key attributes must not depend on another non-key attribute

Must meet 4th normal form

partial

complete

transitive

indirect

Add, Delete and Save anomalies

Insert, Add and Save anomalies

Update, Save and Insert anomalies

Insert, Delete and Update anomalies

The storage space needed for a normalised database is likely to be smaller

The process of normalising a database is very easy and doesn’t require any skill

It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry

A unique identifier in a database

A primary key of one table that appears in another table

A field that should not be in a table and needs removing

when an non-key attribute is determined by a whole part of a COMPOSITE primary key.

When a key field is changed and it conflicts with another key

When a database function is dependant of the operation of another function to work correctly

When data is a database is repeated for different entities

A primary key that can be duplicated in the same table

An attribute that is a primary key in another table

A foreign key that is a primary key in more than one other table

A primary key made up from two or more attributes

Determinants

Repeating columns

Null values in primary key fields

Functional dependencies

only one primary key field

all of its fields are Whole Key Dependant

non-key fields that are functionally dependant

at least one repeating group

When any repeating fields have been removed and the table is given a primary key

When all repeating entries of data are removed and the fields in each table are directly related to the primary key and no fields are present that are not related to each other

When all the fields in each table are directly related to the primary key

A field that contains multiple items of data

A field that is repeated

A field that contains only one item of data

1NF

2NF

3NF

4NF

relational

object-oriented

conceptual

external

normal form

primary key

attributes

repeating groups