{"id":540,"date":"2025-08-20T03:22:49","date_gmt":"2025-08-20T03:22:49","guid":{"rendered":"https:\/\/egco.org\/design\/?p=540"},"modified":"2025-08-20T03:25:32","modified_gmt":"2025-08-20T03:25:32","slug":"egco321-assignment-1-entity-relationship-diagram","status":"publish","type":"post","link":"https:\/\/egco.org\/design\/?p=540","title":{"rendered":"EGCO321: Assignment 1 &#8211; Entity-Relationship Diagram"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>Suppose you are given the following requirements for a simple database for the English Premier League (EPL):\n<ul class=\"wp-block-list\">\n<li>The EPL has many team (20 teams).<\/li>\n\n\n\n<li>Each team has a name, a city, a manager, a captain, and a set of players.<\/li>\n\n\n\n<li>Each player belongs to only one team.<\/li>\n\n\n\n<li>Each player has a name, a number, and a position (such as goalkeeper or midfielder)<\/li>\n\n\n\n<li>A team captain is also a player.<\/li>\n\n\n\n<li>A game is played between two teams (referred to as host team and guest team) and a date and score.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Create an ERD to support EPL data using <strong>draw.io<\/strong>, export it as a PDF, and send it to my email (<a href=\"mailto:kanat@egco.org\">kanat@egco.org<\/a>)<\/li>\n<\/ul>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0);color:#ff0000\" class=\"has-inline-color\">Deadline: 29 August 2025<\/mark><\/strong><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Deadline: 29 August 2025<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-540","post","type-post","status-publish","format-standard","hentry","category-assignments"],"_links":{"self":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/posts\/540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/egco.org\/design\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=540"}],"version-history":[{"count":2,"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/posts\/540\/revisions"}],"predecessor-version":[{"id":560,"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/posts\/540\/revisions\/560"}],"wp:attachment":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/egco.org\/design\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/egco.org\/design\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}