Test
UML Lec4 Quiz
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (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
- AVerdadero
- BFalso
2What happens if you want to insert a new branch that does not have any members of staff yet?
- AWould work
- BInsertion Anomaly
3What happens if you delete staff number S0415?
- AWould work
- BDeletion Anomaly
4What happens if you want to change the telephone number of branch B001?
- AWould work
- BModification Anomaly
5To minimise data redundancy, relations that contain redundant data may potentially suffer from update anomalies, which is NOT true
- AInsertion anomalies
- BDeletion anomalies
- CModification anomalies
- 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.- AVerdadero
- BFalso
Información
- Descripción
- Normalisation
- Autor
- Ray Welland
- Idioma
- English
- Visitas
- 66
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test