COMPUTER SICENCE
define the term relation
an entity put down with its detail in form of a table
define the term relationship
how relations are connected to eachother
define the term tuple
a record that is inserted into a table
normalisation
the process of organising data into relations with proper relationship
Give 3 reasons to why normalisation is necessary.
removing data redundency, enforcing data entegrity, preventing anomalies (insertion, deletion, update)
how do you establish a reaction?
putting Primary Key of one table (entity, relation) into another table as a Foreign Key establishes a relation.