UML Lec4 Quiz

The process of normalisation involves applying a series of refinements to groups of data items in order to produce relations that conform to specified standards, known as normal forms

What happens if you want to insert a new branch that does not have any members of staff yet?

What happens if you delete staff number S0415?

What happens if you want to change the telephone number of branch B001?

To minimise data redundancy, relations that contain redundant data may potentially suffer from update anomalies, which is NOT true

Is this true about Functionally Dependency? In a table listing employee characteristics including Social Security Number (SSN) and name, it can be said that name is functionally dependent upon SSN (or SSN -> name) because an employee's name can be uniquely determined from their SSN. However, the reverse statement (name -> SSN) is not true because more than one employee can have the same name but different SSNs.