UML Lec4 Quiz

Descripción

Normalisation
Ray Welland
Test por Ray Welland, actualizado hace más de 1 año
Ray Welland
Creado por Ray Welland hace más de 10 años
20
0

Resumen del Recurso

Pregunta 1

Pregunta
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
Respuesta
  • True
  • False

Pregunta 2

Pregunta
What happens if you want to insert a new branch that does not have any members of staff yet?
Respuesta
  • Would work
  • Insertion Anomaly

Pregunta 3

Pregunta
What happens if you delete staff number S0415?
Respuesta
  • Would work
  • Deletion Anomaly

Pregunta 4

Pregunta
What happens if you want to change the telephone number of branch B001?
Respuesta
  • Would work
  • Modification Anomaly

Pregunta 5

Pregunta
To minimise data redundancy, relations that contain redundant data may potentially suffer from update anomalies, which is NOT true
Respuesta
  • Insertion anomalies
  • Deletion anomalies
  • Modification anomalies
  • Criteria anomalies

Pregunta 6

Pregunta
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.
Respuesta
  • True
  • False
Mostrar resumen completo Ocultar resumen completo

Similar

Chapter 3 : Use Cases
Jo Hart
Chapter 6 – Essentials of Design and the Design Activities
Jo Hart
French Verbs
dylankhakh
Chapter 5: Extending the Requirements Model
Jo Hart
UML Lec1 Quiz
Ray Welland
Basics in Object Oriented Programming
Bit buddy
Metodos y modelos para desarrollo de sofware
SERGIO GIL HERRERA
UML Lec2 Quiz
Ray Welland
UML Lec3 Quiz
Ray Welland