UML Lec4 Quiz

Description

Normalisation
Ray Welland
Quiz by Ray Welland, updated more than 1 year ago
Ray Welland
Created by Ray Welland over 10 years ago
20
0

Resource summary

Question 1

Question
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
Answer
  • True
  • False

Question 2

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

Question 3

Question
What happens if you delete staff number S0415?
Answer
  • Would work
  • Deletion Anomaly

Question 4

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

Question 5

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

Question 6

Question
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.
Answer
  • True
  • False
Show full summary Hide full summary

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