Quiz

UML Lec4 Quiz

Ray Welland 6 perguntas

Fazer o quiz

Perguntas do quiz (6)

1The 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
1. AVerdadeiro
2. BFalso
2What happens if you want to insert a new branch that does not have any members of staff yet?
1. AWould work
2. BInsertion Anomaly
3What happens if you delete staff number S0415?
1. AWould work
2. BDeletion Anomaly
4What happens if you want to change the telephone number of branch B001?
1. AWould work
2. BModification Anomaly
5To minimise data redundancy, relations that contain redundant data may potentially suffer from update anomalies, which is NOT true
1. AInsertion anomalies
2. BDeletion anomalies
3. CModification anomalies
4. DCriteria anomalies
6Is 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.
1. AVerdadeiro
2. BFalso