Kopieren und bearbeiten

Normalization Practice

Beschreibung

C175
Craig Willey
Quiz von Craig Willey, aktualisiert more than 1 year ago
Craig Willey
Erstellt von Craig Willey vor fast 5 Jahre
2868
1
0

Zusammenfassung der Ressource

Frage 1

Frage
In which state are the attributes shown (see table)?
Image:
3 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 2

Frage
In which state is the table in (see table)?
Image:
4 (binary/octet-stream)
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)?
Image:
5 (binary/octet-stream)
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?
Image:
6 (binary/octet-stream)
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?
Image:
7 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 6

Frage
In which form is the table?
Image:
8 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 7

Frage
In which state are the attributes shown?
Image:
9 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 8

Frage
In which state are the attributes shown (see table)?
Image:
10 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 9

Frage
In which state are the attributes shown (see table above)?
Image:
11 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 10

Frage
In which state are the attributes shown?
Image:
12 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Frage 11

Frage
In which state is the table above?
Image:
13 (binary/octet-stream)
Antworten
  • Unnormalized
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Geschichte Deutschlands
max.grassl
Geographie Quiz
AntonS
Die Verwandlung (1915)
lilith.m
Evolution des Menschen (bioloos)
sonja.loos
Kunststoffe - Einführung
Fabian B.
FOST 3 - Inferenzstatistik
Kathy H
Vetie - Pathologie 2016
Fioras Hu
Vetie - Pathologie Fragen aus dem A-Skript
Fioras Hu
Französische Verben
Sofia Spörri
Vetie Virologie 2013
Isabelle K.
Innere Pferd Vetie
Anne Käfer
Bibliothek durchsuchen