u Database design consists in grouping attributes that form “good” relation schemas.
u Normalization: a design process to reduce redundancies and update anomalies in a relational schema.
– Result: a set of decomposed relations that meet certain normal form tests
– Four most commonly used normal forms are first (1NF), second (2NF) and third (3NF) normal forms, and Boyce–Codd normal form (BCNF)
– A process that is based on keys and functional dependencies among the attributes of a relation
Advertisement
