Normalisation

What is the main focus of this video tutorial?

• Exploring data redundancy

• Understanding SQL queries

• Revisiting database normalization to 3rd normal form

• Learning how to create a database

Which rule is violated if the values in a field are not atomic?

• Rule 4: No identical records

• Rule 3: Atomic values

• Rule 2: Values from the same domain

• Rule 1: Unique field names

What is a partial dependency in the context of 2nd normal form?

• A field that is independent of the primary key

• A field that depends on part of the primary key

• A field that is dependent on another field

• A field that depends on the entire primary key

What is a transitive dependency?

• A field that is independent of all other fields

• A field that depends on multiple fields

• A field that depends on another field, which in turn depends on the primary key

• A field that depends on the primary key

What is the purpose of separating the mark field into its own table?

• To reduce data redundancy

• To remove transitive dependencies

• To simplify the database structure

• To increase data redundancy