{"id":26457,"date":"2024-03-27T17:27:36","date_gmt":"2024-03-27T16:27:36","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/does-this-schema-look-normalized-to-3nf-need-help-with-class-project\/"},"modified":"2024-03-27T17:27:36","modified_gmt":"2024-03-27T16:27:36","slug":"does-this-schema-look-normalized-to-3nf-need-help-with-class-project","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/does-this-schema-look-normalized-to-3nf-need-help-with-class-project\/","title":{"rendered":"Does This Schema Look Normalized To 3NF? Need Help With Class Project."},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>MATCH(<strong>MatchID<\/strong>, Season, MatchDate, MatchStartTime, <em>Field#<\/em>, <em>Park<\/em>, <em>HomeTeamID<\/em>, <em>AwayTeamID<\/em>, RefereeName, MatchScore) <\/p>\n<p>FIELD(<strong>Field#<\/strong>, <strong>Park<\/strong>, FieldName) <\/p>\n<p>PLAYER(<strong>PlayerID<\/strong>, JerseyNumber, PlayerFirstName, PlayerLastName, PlayerGender, PlayerAge, <em>TeamID<\/em>, Position, CaptainStatus) <\/p>\n<p>PLAYERSTATS(<strong><em>MatchID<\/em><\/strong>, <strong><em>PlayerID<\/em><\/strong>, MatchDate, MatchStartTime, HomeTeamName, AwayTeamName, JerseyNumber, PlayerName, Goals, Assists, PossessionPercent, PassCount, PassingChain#) <\/p>\n<p>TEAM(<strong>TeamID<\/strong>, TeamName, <em>CoachID<\/em>, <em>AssistantCoachID<\/em>, <em>SponsorID<\/em>) <\/p>\n<p>COACH(<strong>CoachID<\/strong>, CoachFirstName, CoachLastName, <em>TeamID<\/em>, CoachAge, CoachGender, CoachRole) <\/p>\n<p>SPONSOR(<strong>SponsorID<\/strong>, SponsorName, SponsorEmail, SponsorAddress) <\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/volkxx\"> \/u\/volkxx <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1bp5spy\/does_this_schema_look_normalized_to_3nf_need_help\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1bp5spy\/does_this_schema_look_normalized_to_3nf_need_help\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-26457 jlk' href='javascript:void(0)' data-task='like' data-post_id='26457' data-nonce='614a020375' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-26457 lc'>0<\/span><\/a><\/div><\/div> <div class='status-26457 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>MATCH(MatchID, Season, MatchDate, MatchStartTime, Field#, Park, HomeTeamID, AwayTeamID, RefereeName, MatchScore) FIELD(Field#, Park, FieldName) PLAYER(PlayerID, JerseyNumber, PlayerFirstName, PlayerLastName,&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-26457","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/26457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=26457"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/26457\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=26457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=26457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=26457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}