One important concept to remember is that a relation exists even if data are not entered into it. It is the process used to assign attributes to entities. These attributes will transform into column names and the entities will transform into relations. Normalization reduces data redundancies and helps eliminate data anomalies. All the key attributes are defined There are no repeating groups in the entity.
All attributes are dependent on the primary key Consider the following data table.
Course Name Section No. Consider the preceding data table. If not, explain why. For example, consider that the attribute Wage is dependent on the attribute Job Grade. Wage is determined by Job Grade, yet neither Job Grade nor Wage are primary keys or part of a primary key.