3/17/10&1&Course&Project&Phase&2&1&Copyright&©&Ben&Cartere;e&Phase&2&• Three&steps:&– Translate&your&ER&diagram&to&relaConal&schemas&– Create&tables&in&a&MySQL&database&– Import&flight&data&• Turn&in&a&document&describing&– Any&changes&from&your&iniCal&model&– FuncConal&dependencies&that&hold&on&each&schema&– Any&relaConal&decomposiCons&to&3NF&or&BCNF&(and,&if&you&choose¬&to&use&BCNF,&a&jusCficaCon)&– The&SQL&commands&you&used&to&create&the&tables&and&import&the&data&Copyright&©&Ben&Cartere;e& 2&3/17/10&2&Phase&2&Data&• I&will&provide&data&(five&text&files&in&CSV&format)&consisCng&of:&– Airline&informaCon&(21&different&airlines)&– Airport&informaCon&(48&different&airports)&– Aircra[&informaCon&(~50&unique&aircra[&models)&– Flight&informaCon&(several&thousand&flights)&– Fare&informaCon&(fares&sold&on&each&flight)&• You&may&use&the&data&as&provided,&or&you&may&pre`process&it&in&any&way&you&choose&Copyright&©&Ben&Cartere;e& 3&Using&MySQL&• Each&group&will&have&an&empty&database&set&up&in&the&MySQL&server&on&orioles.acad.ece.udel.edu&– Please&make&sure&you&are&able&to&log&in&and&let&me&know&ASAP&if&you&can’t&• To&access:&/usr/local/mysql/bin/mysql&–u&[username]&–p&[dbname]&• I&will&email&each&group&a&database&name&and&password&Copyright&©&Ben&Cartere;e& 4&3/17/10&3&ImporCng&Data&from&CSV&/usr/local/mysql/bin/mysqlimport&``local&[dbname]&``fields`terminated`by=,&``fields`enclosed`by='"'&[file].csv&`u&[username]&–p&• This&will&import&into&a&table&with&the&same&name&as&the&file&• Field&order&in&table&schema&must&be&the&same&as&the&field&order&in&the&file&Copyright&©&Ben&Cartere;e& 5&Phase&2&Due&Date&• April&6th&(right&a[er&spring&break)&– I&recommend&finishing&earlier&to&have&more&Cme&to&program&the&applicaCon&• Also:&&midterm&will&be&April&8th&in&class&Copyright&©&Ben&Cartere;e&
View Full Document
Unlocking...