{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":532,"n_cols":12,"rows_kept":532,"cut":false,"hidden":false,"merged":[[16,0,16,6],[17,0,17,6],[18,0,18,6]]}
["Normalisierungsübung 3"]
["Gegeben ist folgende Ausgangstabelle"]
[]
["SchülerNr","Name","Klasse","Klassenlehrer","Infogruppe","Info-Lehrer","2.FS Gruppe","2FS-Lehrer","3.FS Gruppe","3FS Lehrer","Profil","Profillehrer"]
[1,"Böse, Berta","10/3","Schiller","inf10_23","Hard","Fra_1","Chevalier",null,null,"Bionik","Taster"]
[2,"Chaos, Chris","10/2","Herder","inf10_2","Maus","Fra_1","Chevalier","LAT","Senora"]
[3,"Drama, Dagmar","10/3","Schiller","inf10_23","Hard","Spa","Senora",null,null,"Bionik","Taster"]
[4,"Edelmann, Edgar","10/3","Schiller","inf10_3","Taster","Spa","Senora",null,null,"Astro","Rakete"]
[5,"Frei, Frank","10/2","Herder","inf10_23","Hard","Fra_2","Madame","LAT","Senora"]
[6,"Gans, Gustav","10/1","Kant","inf10_11","Maus","Fra_2","Madame",null,null,"Astro","Rakete"]
[]
["1. Gib für jede Art der Anomalien ein Beispiel zu dieser oben gezeigten nicht normalisierten Tabelle an."]
["2. Erstelle die erste Normalform, beachte dabei auch, dass eine Tabelle nur zwei 'Dimensionen' haben sollte, der Aufbau mit mehreren Spalten für bestimmte Fächer/Lerngruppen die die Schüler belegen sollte beseitigt werden"]
["3. Erstelle die zweite Normalform und dann auch die dritte NF."]
[]
["1."]
["Insert Anomalie: fehlen von Informationen (zb einfügen eines Lehrers aber ohne Schüler und Klasse)"]
["Update Anomalie: Bei Änderung eines Names wird einmal richtig und einmal falsch geschrieben"]
["Lösch Anomalie: löschen aller Zeilen mit Madame, dadurch löschen von zwei Schülern und einer klasse"]
[]
[]
[]
[]
["1 NF"]
[]
["SchülerNr","Name","Vorname","Kurs","Kurs Lehrer"]
[1,"Böse","Berta","10/3","Schiller"]
[1,"Böse","Berta","inf10_23","Hard"]
[1,"Böse","Berta","Fra_1","Chevalier"]
[1,"Böse","Berta","Bionik","Taster"]
[2,"Chaos","Chris","10/2","Herder"]
[2,"Chaos","Chris","inf10_2","Maus"]
[2,"Chaos","Chris","Fra_1","Chevalier"]
[2,"Chaos","Chris","LAT","Senora"]
[3,"Drama","Dagmar","10/3","Schiller"]
[3,"Drama","Dagmar","inf10_23","Hard"]
[3,"Drama","Dagmar","Spa","Senora"]
[3,"Drama","Dagmar","Bionik","Taster"]
[4,"Edelmann","Edgar","10/3","Schiller"]
[4,"Edelmann","Edgar","inf10_3","Taster"]
[4,"Edelmann","Edgar","Spa","Senora"]
[4,"Edelmann","Edgar","Astro","Rakete"]
[5,"Frei","Frank","10/2","Herder"]
[5,"Frei","Frank","inf10_23","Hard"]
[5,"Frei","Frank","Fra_2","Madame"]
[5,"Frei","Frank","LAT","Senora"]
[6,"Gans","Gustav","10/1","Kant"]
[6,"Gans","Gustav","inf10_11","Maus"]
[6,"Gans","Gustav","Fra_2","Madame"]
[6,"Gans","Gustav","Astro","Rakete"]
[]
[]
[]
[]
["2 NF"]
[]
["Schüler Tabelle",null,null,null,"Kurstabelle",{"$nulls":4},"Schüler - Kurse Tabelle"]
["SchülerNr","Name","Vorname",null,"Kurs_ID","Kurs","Lehrer",null,null,"SchülerNr","Kurs ID"]
[1,"Böse","Berta",null,1,"10/1","Kant",null,null,1,3]
[2,"Chaos","Chris",null,2,"10/2","Herder",null,null,1,6]
[3,"Drama","Dagmar",null,3,"10/3","Schiller",null,null,1,11]
[4,"Edelmann","Edgar",null,4,"Bionik","Taster",null,null,1,4]
[5,"Frei","Frank",null,5,"Astro","Rakete",null,null,2,2]
[6,"Gans","Gustav",null,6,"inf10_23","Hard",null,null,2,7]
[{"$nulls":4},7,"inf10_2","Maus",null,null,2,11]
[{"$nulls":4},8,"inf10_3","Hard",null,null,2,10]
[{"$nulls":4},9,"inf10_11","Maus",null,null,3,3]
[{"$nulls":4},10,"LAT","Senora",null,null,3,6]
[{"$nulls":4},11,"Fra_1","Chevalier",null,null,3,12]
[{"$nulls":4},12,"Spa","Senora",null,null,3,4]
[{"$nulls":4},13,"Fra_2","Madame",null,null,4,3]
[{"$nulls":9},4,8]
[{"$nulls":9},4,12]
[{"$nulls":9},4,6]
[{"$nulls":9},5,1]
[{"$nulls":9},5,9]
[{"$nulls":9},5,13]
[{"$nulls":9},5,10]
[{"$nulls":9},6,1]
[{"$nulls":9},6,9]
[{"$nulls":9},6,13]
[{"$nulls":9},6,5]
[]
["3 NF"]
[]
["Tabelle Lehrer",null,null,"Kurs- Lehrer - tabelle",null,null,"Schüler Tabelle"]
["Lehrer_ID","Lehrer",null,"Kurs_ID","Lehrer_ID",null,"SchülerNr","Name","Vorname",null,"Schüler - Kurse Tabelle"]
[1,"Kant",null,1,1,null,1,"Böse","Berta",null,"SchülerNr","Kurs ID"]
[2,"Herder",null,2,2,null,2,"Chaos","Chris",null,1,3]
[3,"Schiller",null,3,3,null,3,"Drama","Dagmar",null,1,6]
[4,"Taster",null,4,4,null,4,"Edelmann","Edgar",null,1,11]
[5,"Rakete",null,5,5,null,5,"Frei","Frank",null,1,4]
[6,"Hard",null,6,6,null,6,"Gans","Gustav",null,2,2]
[7,"Maus",null,7,7,{"$nulls":5},2,7]
[8,"Senora",null,8,6,{"$nulls":5},2,11]
[9,"Chevalier",null,9,7,{"$nulls":5},2,10]
[10,"Madame",null,10,8,{"$nulls":5},3,3]
[null,null,null,11,9,null,"Kurstabelle",null,null,null,3,6]
[null,null,null,12,8,null,"Kurs_ID","Kurs",null,null,3,12]
[null,null,null,13,10,null,1,"10/1",null,null,3,4]
[{"$nulls":6},2,"10/2",null,null,4,3]
[null,"Entity",{"$nulls":4},3,"10/3",null,null,4,8]
[null,"Relation",{"$nulls":4},4,"Bionik",null,null,4,12]
[{"$nulls":6},5,"Astro",null,null,4,6]
[{"$nulls":6},6,"inf10_23",null,null,5,1]
[{"$nulls":6},7,"inf10_2",null,null,5,9]
[{"$nulls":6},8,"inf10_3",null,null,5,13]
[{"$nulls":6},9,"inf10_11",null,null,5,10]
[{"$nulls":6},10,"LAT",null,null,6,1]
[{"$nulls":6},11,"Fra_1",null,null,6,9]
[{"$nulls":6},12,"Spa",null,null,6,13]
[{"$nulls":6},13,"Fra_2",null,null,6,5]
{"$rows_empty":318}
[{"$nulls":8},"                         "]
{"$rows_empty":93}
[{"$nulls":8}," "]
[]
[]
[{"$nulls":8}," "]
[]
[{"$nulls":8},"  "]
[{"$nulls":8},"                                                        "]
[{"$nulls":8},"   "]