Question

Fundamental design principles of a relational database

Answer 1

The fundamental design principles of a relational database are:

*Each row in a table must be distinct from the other rows present.

*All data should be stored in the most basic or atomic form. For example, separate fields should be created in the table to store the door number, street name, and pin code of an address.

*A field in a row should contain only one value. For instance, if a person has more than one child, there should not be just one field called children’s names containing names of all the children in the parent’s record.

*Avoid duplication of data. If a particular portion of data is likely to be used a number of times, then store it one location and refer to it instead of saving the same content many times.

*Do not store dependent data. If a value must be calculated from other data in the table, then calculate the value only when it is needed. Avoid having another field in the table to store the calculated value.

Answer 2

ANSWER
..........




➡️ ➡️ ➡️ ➡️ ➡️ ➡️ ➡️ ➡️ portion of data is likely to be used a number of times, then store it one location and refer to it instead of saving the same content many times *Do not store dependent data. If a value must be calculated from other data in the table, then calculate the value only when it is needed. Avoid having another field in the table to