Olympics Database Design Exercise Information These specifications were developed by Prof McMahon’s IT3060 students. They are meant to serve as an aid for students in his class as well as those in...

1 answer below »
Please see attached


Olympics Database Design Exercise Information These specifications were developed by Prof McMahon’s IT3060 students. They are meant to serve as an aid for students in his class as well as those in Prof Dekok’s section. In this exercise, students may work together in teams of 2 or 3. If a 4th person wants to then split the team into 2 and 2. Design functional database for the use in the Summer Olympics. Use the files found in Canvas as a guide to the different entities to be used – Files -> Midterm -> Olympics. This database does not need to keep track of medals won either for past or present. The list of Summer Olympics sports are found in the file OlympicsSports_ForSummer.csv. There are 47 sports listed. Note: Athletics = Track and Field Identify the entities (tables) that answers who, what, where, and when of an Olympics Create the conceptual model – the key entities such as sport, participants, venues, etc; Create the logical model – identify all the attributes (columns) and data types Identify PK and FK and create the relationships Identify the 1-to-many and many-to-many relationships. Keep in mind that many-to-many relationships will require an intermediate (linking) table between the two tables with the primary key being made up of the PK for each of the two tables being linked. Keep in mind that SQL Server allows up to 16 columns for a Primary Key. Implement the model along with the database diagram in the Sandbox using SQL Server. Please let your section’s faculty member and our TA (Joe Armstrong) whose sandbox we need to evaluate. Use Mockaroo to generate test data as best as is possible – you can create the table definition including columns and their data types; generates test data; Mockaroo does not generate Primary Keys nor does it create relationships between tables. Generate at least 200 athletes making sure they come for different countries and have different genders. /*********************************************************************************/ Sunday, Oct 3 notes **When creating the relationships which should be done after data is loaded into the tables, make sure to turn off relationship checking – ALTER TABLE table_name NOCHECK CONSTRAINT fk_constraint_name; https://stackoverflow.com/questions/737115/turn-off-constraints-temporarily-ms-sql https://database.guide/how-to-disable-a-check-constraint-in-sql-server-t-sql-examples/ https://docs.microsoft.com/en-us/sql/relational-databases/tables/disable-foreign-key-constraints-with-insert-and-update-statements?view=sql-server-ver15 – you can also use the Object Explorer to modify this setting in SSMS **Country iso code two vs three letters – in general the 3-letter ISO code should be used; that being said, Mockaroo only generates the 2-letter ISO so that will be fine to use. https://www.iso.org/iso-3166-country-codes.html https://www.iban.com/country-codes **Is it possible for a sport to be played at multiple venues, like soccer? -- Yes https://www.olympicbettingodds.com/venues/football-venues.html https://olympics.com/tokyo-2020/en/venues/yokohama-baseball-stadium A preliminary design that was created by a team in Prof McMahon’s class. This can be used a guide, but should NOT be assumed to be 100% correct. To get access to sandbox follow these steps.. 1. Download our vpn (https://www.uc.edu/about/ucit/services/connectivity-fac-staff/vpn.html). This allows you to connect to sandbox. 2. Log in to vpn [ USER - jasperjz / PASS - Batman102.] ~Dont forget the period in the pw. 3. You will see this, Hit “Send Me a Push”. It will notify me and I will have to hit accept on my end. 4. Once I let you in , in google chrome, open an incognito window, within that incognito window… go here (https://sandbox02.cech.uc.edu/vcac/). Select domain “ad.uc.edu”..then it will prompt you for the same information, just use the same login cred you used for the vpn. 5. Follow screenshots, here you will land on this page.Click deployments tab. 6. Here you will scroll down and click DB2442 gear option → Connect to remote.. 7. Once it loads the remote, the password is “Pa$$w0rd”. You will be logged in to the desktop and you will have to get on microsoft sql server, once sql loads you should be able to log right in.. if the window pops up just hit connect. ..All done. Athletes.xlsx Details NameNOCDiscipline AALERUD KatrineNorwayCycling Road ABAD NestorSpainArtistic Gymnastics ABAGNALE GiovanniItalyRowing ABALDE AlbertoSpainBasketball ABALDE TamaraSpainBasketball ABALO LucFranceHandball ABAROA CesarChileRowing ABASS AbobakrSudanSwimming ABBASALI HamidehIslamic Republic of IranKarate ABBASOV IslamAzerbaijanWrestling ABBINGH LoisNetherlandsHandball ABBOT EmilyAustraliaRhythmic Gymnastics ABBOTT MonicaUnited States of AmericaBaseball/Softball ABDALLA Abubaker HaydarQatarAthletics ABDALLA MaryamEgyptArtistic Swimming ABDALLAH ShahdEgyptArtistic Swimming ABDALRASOOL MohamedSudanJudo ABDEL LATIF RadwaEgyptShooting ABDEL RAZEK SamyEgyptShooting ABDELAZIZ AbdallaEgyptKarate ABDELAZIZ FarahEgyptTable Tennis ABDELAZIZ FeryalEgyptKarate ABDELMAWGOUD MohamedEgyptJudo ABDELMOTTALEB Diaaeldin Kamal GoudaEgyptWrestling ABDELRAHMAN IhabEgyptAthletics ABDELSALAM MohamedEgyptFootball ABDELSALAM NourEgyptTaekwondo ABDELWAHED AhmedItalyAthletics ABDI BashirBelgiumAthletics ABDIRAHMAN AbdiUnited States of AmericaAthletics ABDUL HADI Farah AnnMalaysiaArtistic Gymnastics ABDUL RAHMAN Kiria TikanahSingaporeFencing ABDUL RAZZAQ Fathimath NabaahaMaldivesBadminton ABDULHAMID SaudSaudi ArabiaFootball ABDULJABBAR Ammar RiadGermanyBoxing ABDULLAEV GulomjonUzbekistanWrestling ABDULLAEV MuminjonUzbekistanWrestling ABDULLAH Rahmat ErwinIndonesiaWeightlifting ABDULLIN IlfatKazakhstanArchery ABDULREDHA MohamedBahrainHandball ABDURAIMOV ElnurUzbekistanBoxing ABDURAKHIMOV RasuljonUzbekistanArtistic Gymnastics ABDURAKHMONOV BekzodUzbekistanWrestling ABE HifumiJapanJudo ABE TakatoshiJapanAthletics ABE UtaJapanJudo ABEBE MekidesEthiopiaAthletics ABEDINI MojtabaIslamic Republic of IranFencing ABEL JenniferCanadaDiving ABELA MatthewMaltaBadminton ABELVIK ROED MagnusNorwayHandball ABEYSINGHE MatthewSri LankaSwimming ABIAN PabloSpainBadminton ABICHA MohammedMoroccoBeach Volleyball ABICHT LorenaAustriaSailing ABIDINE AbidineMauritaniaAthletics ABLIAZIN DenisROCArtistic Gymnastics ABOUD HadelLibyaAthletics ABOUELKASSEM AlaaeldinEgyptFencing ABOUKE Nancy GenzelNauruWeightlifting ABRAHAM TadesseSwitzerlandAthletics ABRAHAMS Rusten JohnSouth AfricaHockey ABRAMS AliyahGuyanaAthletics ABRAMS JasmineGuyanaAthletics ABRAMYAN BenikGeorgiaAthletics ABREU DiogoPortugalTrampoline Gymnastics ABRINES REDONDO AlejandroSpainBasketball ABROSIMOV KirillROCMarathon Swimming ABU RABEE AsmaJordanShooting ABU RMILAH WesamPalestineJudo ABUAKU JoshuaGermanyAthletics ABUJBARA TalaQatarRowing ACERENZA DomenicoItalySwimming ACETI VladimirItalyAthletics ACHAB JaouadBelgiumTaekwondo ACHANTA KamalIndiaTable Tennis ACHILLEOS GeorgiosCyprusShooting ACHIUWA PreciousNigeriaBasketball ACHONWA NatalieCanadaBasketball ACHOURI HaikelTunisiaWrestling ACKERMANN SimoneSouth AfricaTriathlon ACOSTA BriseidaMexicoTaekwondo ACOSTA FERNANDEZ YasmaniChileWrestling ACOSTA GIRALDO ValentinaColombiaArchery ACOSTA MarceloEl SalvadorSwimming ACUNA YennyChileFootball ADACHI KazuyaJapanCanoe Slalom ADACHI SeiyaJapanWater Polo ADAM AmalEgyptArchery ADAM ConstantinRomaniaRowing ADAMEK KlaudiaPolandAthletics ADAMKIEWICZ PatrycjaPolandTaekwondo ADAMS LiamAustraliaAthletics ADAMS PaulAustraliaShooting ADAMS TaeyannaFederated States of MicronesiaSwimming ADAMUS Bartlomiej StejanPolandWeightlifting ADAO de SA Mateus DanielBrazilAthletics ADAR YaseminTurkeyWrestling ADEBAYO Edrice FemiUnited States of AmericaBasketball ADEGOKE EnochNigeriaAthletics ADEKUOROYE Odunayo FolasadeNigeriaWrestling ADEL IbrahimEgyptFootball ADENIYI Aminat OluwafunmilayoNigeriaWrestling ADESOKAN Dorcas AjokeNigeriaBadminton ADILKHANOVA AlinaKazakhstanRhythmic Gymnastics ADLERTEG JonnaSwedenArtistic Gymnastics ADLINGTON SarahGreat BritainJudo ADO PaulineFranceSurfing ADOLF BalazsHungaryCanoe Sprint ADOMAVICIUS AurimasLithuaniaRowing AEDO YanaraChileFootball AERNOUDTS ViolaineFranceRowing AFANADOR BrianPuerto RicoTable Tennis AFONSO PaixaoAngolaSailing AFOUMBA Gilles AnthonyCongoAthletics AFREMOVA NataliaROCCycling BMX Racing AFRIAT CharlotteMonacoAthletics AGADA CalebNigeriaBasketball AGAHOZO AlphonsineRwandaSwimming AGARD TerrenceNetherlandsAthletics AGARIE YutoJapanHandball AGATSUMA HarukaJapanBaseball/Softball AGBEGNENOU ClarisseFranceJudo AGERO EdenKenyaRugby Sevens AGGEFORS MikaelSwedenHandball AGHAEIHAJIAGHA SorayaIslamic Republic of IranBadminton AGHAMIROVA ZohraAzerbaijanRhythmic Gymnastics AGHAMIRZAEIJENAGHRAD AliIslamic Republic of IranCanoe Sprint AGHASYAN LevonArmeniaAthletics AGHAYEV RafaelAzerbaijanKarate AGIOMOR EkerekemeNigeriaWrestling AGIURGIUCULESE AlexandraItalyRhythmic Gymnastics AGRALI YavuzTurkeyAthletics AGRUSTI AndreaItalyAthletics AGUIAR MayraBrazilJudo AGUILAR AliUnited States of AmericaBaseball/Softball AGUILAR AndresChileArchery AGUILAR Evelis JazminColombiaAthletics AGUINAGALDE AQUIZU JulenSpainHandball AGUIRRE EduardoMexicoFootball AGUIRRE ErickMexicoFootball AGUIRRE UnaiSpainWater Polo AGUNDEZ GARCIA GabrielaMexicoDiving AH TONG Marion FaustinoSamoaBoxing AHMAD Muhammad IsaBrunei DarussalamSwimming AHMED AimanSaudi ArabiaFootball AHMED ALI YUSUF Abdulla EssaBahrainSwimming AHMED EnasEgyptWrestling AHMED JunaynaBangladeshSwimming AHMED MohamedBahrainHandball AHMED MohammedCanadaAthletics AHMED SamaaEgyptCanoe Sprint AHOUANWANOU OdileBeninAthletics AHOURE MurielleCôte d'IvoireAthletics AHSINGER NicoleUnited States of AmericaTrampoline Gymnastics AHYE Michelle-LeeTrinidad and TobagoAthletics AI YanhanPeople's Republic of ChinaSwimming AICARDI MatteoItalyWater Polo AICOBOAE VladRomaniaRowing AIGNER HannesGermanyCanoe Slalom AILINCAI AdrianaRomaniaRowing AIMABLE StevenSenegalSwimming AINAGULOV MirambekKazakhstanWrestling AIOANI MarianRomaniaFootball AISAH Windy CantikaIndonesiaWeightlifting AIT DAOUD KamelAlgeriaRowing AIT OUAGRAM ZiedMoroccoWrestling AIT SAID SamirFranceArtistic Gymnastics AITCHISON HollyGreat BritainRugby Sevens AIZAWA AkiraJapanAthletics AJAYI YinkaNigeriaAthletics AKAHO HimawariJapanBasketball AKGUL TahaTurkeyWrestling AKGUN OmerTurkeyShooting AKHAIMOVA LiliiaROCArtistic Gymnastics AKHMADIEV IldarTajikistanAthletics AKHMETOVA TatyanaKazakhstanWrestling AKHTAR Muhammad KhalilPakistanShooting AKIMENKO MikhailROCAthletics AKINRADEWO FolukeUnited States of AmericaVolleyball AKINYI ElizabethKenyaBoxing AKKUS MihracTurkeyJudo AKMAL NurulIndonesiaWeightlifting AKMATALIEV ErnazarKyrgyzstanWrestling AKMENS RobertsLatviaCanoe Sprint AKOZ Simge SebnemTurkeyVolleyball AKTAS UgurTurkeyKarate AL ADAWI Issa Samir HamedOmanSwimming AL AHRACH AliMoroccoEquestrian AL ALAWI MazoonOmanAthletics AL FAIHAN AbdulrahmanKuwaitShooting AL HARTHI BarakatOmanAthletics AL KHAFAJI MohammedIraqRowing AL KHATRI HamedOmanShooting AL MANWARI Bashair ObaidQatarAthletics AL OBAIDI AkerRefugee Olympic TeamWrestling AL RASHEDI MansourKuwaitShooting AL RUMAIHI MohammedQatarShooting AL YAARI AhmedYemenAthletics AL YASSIN Mazen MoutanSaudi ArabiaAthletics AL-KAABI Fatimah Abbas WaheebIraqShooting AL-KANJARI Amur Salim RamadhanOmanWeightlifting AL-OBAIDLY AbdulazizQatarSwimming AL-RAIMI YasameenYemenShooting AL-SADEQ JulyanaJordanTaekwondo AL-WIR AmroJordanSwimming AL-YAMANI MokhtarYemenSwimming ALAKHVERDOVI SakhilGeorgiaBoxing ALAMIAN NimaIslamic Republic of IranTable Tennis ALARIE ElissaCanadaRugby Sevens ALARZA FernandoSpainTriathlon ALBA CASTILLO Rafael YunierCubaTaekwondo ALBARRACIN MatiasArgentinaEquestrian ALBAWARDI ZaidSaudi ArabiaFootball ALBAYRAK VedatTurkeyJudo ALBERS FeliceNetherlandsHockey ALBERTARRIO AgustinaArgentinaHockey ALBICY AndrewFranceBasketball ALBRECHT SamuelBrazilSailing ALBRIKAN FerasSaudi ArabiaFootball ALBUKHARI AminSaudi ArabiaFootball ALDABBAGH YasmeenSaudi ArabiaAthletics ALDASS SandaRefugee Olympic TeamJudo ALDAWSARI KhalifahSaudi ArabiaFootball ALDAWSARI SalemSaudi ArabiaFootball ALDERSEY OlympiaAustraliaRowing ALEGRE BIOSCA DavidSpainHockey ALEKSANDROVA EkaterinaROCTennis ALEKSANYAN ArturArmeniaWrestling ALEKSIC MajaSerbiaVolleyball ALEKSIC MilanSerbiaWater Polo ALEKSIIVA MarynaUkraineArtistic Swimming ALEKSIIVA VladyslavaUkraineArtistic Swimming ALEMANNO Maria GraziaItalyWeightlifting ALEMU HabitamEthiopiaAthletics ALESSIO SimoneItalyTaekwondo ALEXANDER KaylaCanadaBasketball ALEXANDRI Anna-MariaAustriaArtistic Swimming ALEXANDRI EiriniAustriaArtistic Swimming ALEXIUSSON AgnesSwedenBoxing ALEXUC CIURARIU AlinRomaniaWrestling ALFADHEL AbdulrahmanKuwaitRowing ALFARAJ SalmanSaudi ArabiaFootball ALFONSO DOMINGUEZ Loren BertoAzerbaijanBoxing ALGHANNAM KhalidSaudi ArabiaFootball ALGOTSSON OSTHOLT SaraSwedenEquestrian ALHAMDDAN AbdullahSaudi ArabiaFootball ALHASSAN AliSaudi ArabiaFootball ALHASSANE IsmaelNigerJudo ALHINDAWI Odai Riyad AdelJordanBoxing ALHUMAYD Mahmoud Mohammed SSaudi ArabiaWeightlifting ALI Ali MerzaBahrainHandball ALI HasanBahrainHandball ALI MohamedBahrainHandball ALI MohamedBahrainHandball ALI MOHAMED SouhraDjiboutiAthletics ALI Ramla Said AhmedSomaliaBoxing ALI SelinBulgariaShooting ALI ZADA MasomahRefugee Olympic TeamCycling Road ALIEV MouradFranceBoxing ALIKAJ AhmadRefugee Olympic TeamJudo ALIMURADOVA LamanAzerbaijanRhythmic Gymnastics ALINEBrazilFootball ALIPOV AlexeyROCShooting ALIREZA HuseinSaudi ArabiaRowing ALIYEV HajiAzerbaijanWrestling ALIZADEH DaraBermudaRowing ALIZADEH ZENOORIN KimiaRefugee Olympic TeamTaekwondo ALKANA AntonioSouth AfricaAthletics ALKASBEH Obada Mohammad MustafaJordanBoxing ALKHADRAWI AliSaudi ArabiaTable Tennis ALKHULAIF AymanSaudi ArabiaFootball ALLEMAND JulieBelgiumBasketball ALLEN BecAustraliaBasketball ALLEN BertramIrelandEquestrian ALLEN DevonUnited States of AmericaAthletics ALLEN NathonJamaicaAthletics ALLEN NickUnited States of AmericaBaseball/Softball ALLICOCK KeevinGuyanaBoxing ALLIKVEE MartinEstoniaSwimming ALLMAN ValarieUnited States of AmericaAthletics ALMADA ThiagoArgentinaFootball ALMANZA Rose MaryCubaAthletics ALMAQABI AhmedBahrainHandball ALMAS DenizGermanyAthletics ALMATROOSHI YousufUnited Arab EmiratesSwimming ALMAYA HaimroIsraelAthletics ALMEIDA JoaoPortugalCycling Road ALMEIDA TeresaAngolaHandball ALMOSAWI Sayed MohammedKuwaitKarate ALMUTAIRI SaeidSaudi ArabiaShooting ALNAJI SamiSaudi ArabiaFootball ALOMRAN NasserSaudi ArabiaFootball ALONSO AgostinaArgentinaHockey ALONSO AlejandraParaguayRowing ALONSO AlejandroSpainHockey ALONSO LuanaParaguaySwimming ALOTHMANI AlaTunisiaShooting ALQAHTANI TahaniSaudi ArabiaJudo ALRASHIDI AbdullahKuwaitShooting ALRASHIDI TalalKuwaitShooting ALRUBAIE MohammedSaudi ArabiaFootball ALSALEEM Seraj Abdulrahim MSaudi ArabiaWeightlifting ALSAMAHIJI HasanBahrainHandball ALSHAHRANI YasserSaudi ArabiaFootball ALSHAMMARI MudhawiKuwaitAthletics ALTAYEV AltayKazakhstanWater Polo ALTENBURG LisaGermanyHockey ALTENHUBER LouisaAustriaRowing ALTHEMAN Maria SuelenBrazilJudo ALTO GastonArgentinaTable Tennis ALTUHAYFAN HamadSaudi ArabiaFootball ALTUKHOV PavloUkraineCanoe Sprint ALVARADO LucianaCosta RicaArtistic Gymnastics ALVARADO RobertoMexicoFootball ALVAREZ AnitaUnited States of AmericaArtistic Swimming ALVAREZ AZNAR EduardoSpainEquestrian ALVAREZ DarioDominican RepublicBaseball/Softball ALVAREZ EddyUnited States of AmericaBaseball/Softball ALVAREZ JorgeCubaShooting ALVAREZ JorgeHondurasFootball ALVAREZ LazaroCubaBoxing ALVAREZ LuisMexicoArchery ALVAREZ PIEDRAHITA EstefaniaColombiaArtistic Swimming ALVAREZ SantiagoArgentinaRugby Sevens ALVES DaniBrazilFootball ALVES LOPES MarciaCape VerdeRhythmic Gymnastics ALWADI MohammadJordanBoxing ALY ELKAMASH MarwanEgyptSwimming ALYOUHA YaqoubKuwaitAthletics ALZIGKOUZI KOMINEA Maria Elli LelaGreeceArtistic Swimming ALZINI MartinaItalyCycling Track AMADOR AndreyCosta RicaCycling Road AMAISTROAIE MadalinaRomaniaArchery AMANKUL AbilkhanKazakhstanBoxing AMARE GirmawIsraelAthletics AMARIS CesarVenezuelaRowing AMB KimSwedenAthletics AMBAKA WillyKenyaRugby Sevens AMBALA Atuhaire OgolaUgandaSwimming AMBROCIO GREIFO Pool EdinsonPeruWrestling AMDOUNI MorhadFranceAthletics AMES DavidGreat BritainHockey AMHA SelamEthiopiaCycling Road AMIALIUSIK AlenaBelarusCycling Road AMIHERE LaeticiaCanadaBasketball AMINE Myles NazemSan MarinoWrestling AMIRI NadiemGermanyFootball AMITIndiaBoxing AMOAH ChristianGhanaWeightlifting AMOAH Joseph PaulGhanaAthletics AMOE-TARRANT CharismaAustraliaWeightlifting AMONDE AndrewKenyaRugby Sevens AMORES CARUA Jhonatan JavierEcuadorAthletics AMORIM TALESKA EduardaBrazilHandball AMOROS EmileFranceSailing AMOS NijelBotswanaAthletics AMRI MarwaTunisiaWrestling AMUKAMARA PromiseNigeriaBasketball AMUSAN TobiNigeriaAthletics AN BaulRepublic of KoreaJudo AN ChangrimRepublic of KoreaJudo AN HejiRepublic of KoreaBasketball AN HyejinRepublic of KoreaVolleyball AN SanRepublic of KoreaArchery AN SehyeonRepublic of KoreaSwimming AN SeulkiRepublic of KoreaAthletics AN SeyoungRepublic of KoreaBadminton ANA Andreea BeatriceRomaniaWrestling ANACAN AndreaNew ZealandKarate ANAGNOSTOPOULOU ChrysoulaGreeceAthletics ANAGOZ YaseminTurkeyArchery ANANI KwadjoGhanaJudo ANASTASAKIS MichailGreeceAthletics ANASTASSIOU LucieFranceShooting ANCER AbrahamMexicoGolf ANDERSEN BrookeUnited States of AmericaAthletics ANDERSON AndyCanadaSkateboarding ANDERSON BritanyJamaicaAthletics ANDERSON DoneishaBahamasAthletics ANDERSON HaleyUnited States of AmericaMarathon Swimming ANDERSON LachlanAustraliaRugby Sevens ANDERSON MatthewUnited States of AmericaVolleyball ANDERSON ShaeUnited States of AmericaAthletics ANDERSON YvonneSerbiaBasketball ANDERSSON JonnaSwedenFootball ANDERSSON LasseDenmarkHandball ANDIA Mary LuzPeruAthletics ANDINO KoloheUnited States of AmericaSurfing ANDISON BaileyCanadaSwimming ANDO Elreen AnnPhilippinesWeightlifting ANDO YukaJapanAthletics ANDOH MikikoJapanWeightlifting ANDRADE JordinCape VerdeAthletics ANDRADE RebecaBrazilArtistic Gymnastics ANDRE AngelicaPortugalMarathon Swimming ANDRE SylvainFranceCycling BMX Racing ANDRE ThiagoBrazilAthletics ANDREEV Bozhidar DimitrovBulgariaWeightlifting ANDREEVA IuliiaKyrgyzstanAthletics ANDREJCZYK MariaPolandAthletics ANDREOLI TatianaItalyArchery ANDRESSABrazilFootball ANDRESSINHABrazilFootball ANDREW JoshterGuamJudo ANDREW MichaelUnited States of AmericaSwimming ANDREWS AbbyAustraliaWater Polo ANDREWS EllesseNew ZealandCycling Track ANDREWS-NAHU KanahNew ZealandWeightlifting ANDRIANTSITOHAINA Eric HermanMadagascarWeightlifting ANDRIANTSITOHAINA Tojonirina AlainMadagascarWeightlifting ANDRODIAS MatthieuFranceRowing ANDRULYTE ViktorijaLithuaniaSailing ANDRUSENKO VeronikaROCSwimming ANDUJAR PabloSpainTennis ANESTOR SabianaHaitiJudo ANGELA RamseyNetherlandsAthletics ANGELDAL FilippaSwedenFootball ANGHEL RoxanaRomaniaRowing ANGULO JesusMexicoFootball ANGULO RicardoMexicoFootball ANGULO YulianaEcuadorAthletics ANGYAL DanielHungaryWater Polo ANKUDINOFF AshleeAustraliaCycling Track ANNE Mame-IbraFranceAthletics ANNEN JolandaSwitzerlandTriathlon ANOSHKIN RomanROCCanoe Sprint ANSAH OwenGermanyAthletics ANSAH SarfoGhanaAthletics ANSAH-PEPRAH LucasGermanyAthletics ANSELL Liam PaulGreat BritainHockey ANSHU AnshuIndiaWrestling ANSLEY GiselleGreat BritainHockey ANTILL CalebAustraliaRowing ANTOGNELLI QuentinMonacoRowing ANTOMARCHI KaliemaCubaJudo ANTON ElizabethNew ZealandFootball ANTONIA FERREIRA JaquelineBrazilWeightlifting ANTONIOU KaliaCyprusSwimming ANTONIOU NikolasCyprusSwimming ANTONOVA NataliiaROCCycling Track ANTONSEN AndersDenmarkBadminton ANTONY AlexIndiaAthletics ANTONYBrazilFootball ANTOSOVA LenkaCzech RepublicRowing ANTUNA UrielMexicoFootball ANTUNOVIC AndelaMontenegroSwimming ANVEGARD AnnaSwedenFootball ANWARI FahimAfghanistanSwimming ANYANACHO Elizabeth OluchiNigeriaTaekwondo ANZANI SimoneItalyVolleyball
Answered 4 days AfterOct 08, 2021

Answer To: Olympics Database Design Exercise Information These specifications were developed by Prof McMahon’s...

Ali Asgar answered on Oct 13 2021
120 Votes
Identifying the Tables that Answer:
Who: Person Table
What: Sport, Event
Where: City, NOC_Region

When: Games
Conceptual Diagram
Logical Diagram
Identifying Foreign Keys and Primary Keys
1. Noc_region: primary key – id.
2. City: primary key – id.
3. Games:
a. primary key – gamesID
b. foreign key –...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here