Normalization Practice

Beschreibung

C175
Craig Willey
Quiz von Craig Willey, aktualisiert more than 1 year ago
Craig Willey
Erstellt von Craig Willey vor mehr als 5 Jahre
5061
2

Zusammenfassung der Ressource

Frage 1

Frage
In which state are the attributes shown (see table)?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 2

Frage
In which state is the table in (see table)?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 3

Frage
The primary key in the first table is Booking ID, and the primary key in the second is Client ID. How advanced are the two tables in the normalization process (see tables)?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 4

Frage
What characteristic points to the tables shown above being in third normal form?
Antworten
  • The tables are completely free of data redundancy.
  • “Client ID” appears in more than one table.
  • Each primary key has a functional dependency on every other primary key in the table.
  • The attributes are all single valued.

Frage 5

Frage
The primary key of the table is a composite key made up of Registration ID and Activity ID. In which form is the table?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 6

Frage
In which form is the table?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 7

Frage
In which state are the attributes shown?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 8

Frage
In which state are the attributes shown (see table)?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 9

Frage
In which state are the attributes shown (see table above)?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 10

Frage
In which state are the attributes shown?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 11

Frage
In which state is the table above?
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

LEK 1
Max Muster
IKA-Theoriefragen Serie 16 (15 Fragen)
IKA ON ICT GmbH
Klinische Psychologie Teil 2
Lisa Mariá Hchil
Kurvendiskussion
Sophia Lörsch
Vetie - Biochemie
Fioras Hu
GPSY SOPS
Kim Wannenwetsch
Biwi05 Fragenkatalog
Robin Pietsch
Vetie Radiologie Fragen VL 1
Péroline de Gail
Vetie Tierhygiene-Quiz 2013
Carolina Heide