Database Design and Normalisation

what is compound primary key?

• a field that is a primary key in another table

• a primary key that is made up of 2-3 fields/attributes

• a column in the table/a piece of data about the entity/also known as an attribute

• a field that is a primary key in another table

what is referential integrity?

• a primary key that is made up of 2-3 fields/attributes

• a column in the table/a piece of data about the entity/also known as an attribute

• a column in a table/a piece of data in a record/also known as a field

• the accuracy and consistency of data within a relationship(if a record is deleted/changed in one table,any linked records/tables must also be updates)

what is candidate key?

• a primary key that is made up of 2-3 fields/attributes

• the accuracy and consistency of data within a relationship(if a record is deleted/changed in one table,any linked records/tables must also be updates)

• a field/attribute that could be used as the primary key

• a column in a table/a piece of data in a record/also known as a field

what is data duplication?

• creating an exact copy of a piece of data

• a field that is a primary key in another table

• a column in the table/a piece of data about the entity/also known as an attribute

• a primary key that is made up of 2-3 fields/attributes

what is primary key?

• a field/attribute that could be used as the primary ke

• made up of 2-3 fields/attributes

• a field that is a primary key in another table

• a field in the record that makes it unique

what is foreign key?

• a field that is a primary key in another table

• a primary key that is made up of 2-3 fields/attributes

• the accuracy and consistency of data within a relationship(if a record is deleted/changed in one table,any linked records/tables must also be updates)

• creating an exact copy of a piece of data

a column in a table/a piece of data in a record/also known as a field

another name of rows/tuples in the table

• entity

• records

• columns

• fields

other names of table

• columns

• file

• tuples

• entity

benefits of flat-file database

• quick and easy to set up

• data dependence is over come

• simple sorting can be carried out

• all records are stored in one place

• could have non-unique records