Created
December 12, 2014 12:42
-
-
Save morris821028/e4856a97f1a054b3fb5b to your computer and use it in GitHub Desktop.
database hw 1 scheme data
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| bars | |
| name city owner | |
| joe bar champaign joe | |
| green st bar champaign sally | |
| purple bar urbana paul | |
| drunk urbana bob | |
| bar bar Decatur zoe | |
| beers | |
| name manf | |
| bud Anheuser-busch | |
| bud lite Anheuser-busch | |
| michelob Anheuser-busch | |
| sam adam Boston Beer | |
| summer ale Boston Beer | |
| Winter Lager Boston Beer | |
| mine TTL | |
| taiwan beer TTL | |
| kirin Kirin Brewery | |
| heineken Heineken International | |
| MeZ Tooheys Brewery | |
| blue bitter Tooheys Brewery | |
| red bitter Tooheys Brewery | |
| gold bitter Tooheys Brewery | |
| corona Grupo Modelo | |
| victoria Grupo Modelo | |
| drinkers | |
| name city phone | |
| alex champaign (217) 111-2222 | |
| roy champaign (217) 333-4444 | |
| sally urbana (315) 555-6666 | |
| al urbana (315) 874-2312 | |
| rob savoy (117) 777-8888 | |
| barry savoy (117) 754-1616 | |
| babs decatur (432) 518-8417 | |
| betty decatur (432) 154-1975 | |
| tory decatur (432) 974-5757 | |
| sean decatur (432) 159-7763 | |
| john savoy (117) 156-1789 | |
| frequents | |
| drinker bar | |
| alex joe bar | |
| roy green st bar | |
| sally green st bar | |
| al purple bar | |
| rob joe bar | |
| barry bar bar | |
| babs drunk | |
| betty drunk | |
| tory drunk | |
| sean drunk | |
| john drunk | |
| likes | |
| drinker beer | |
| alex bud | |
| alex sam adam | |
| alex michelob | |
| roy blue bitter | |
| roy red bitter | |
| sally bud | |
| sally michelob | |
| sally gold bitter | |
| al taiwan beer | |
| al mine | |
| rob kirin | |
| rob red bitter | |
| rob gold bitter | |
| barry heineken | |
| babs bud | |
| babs sam adam | |
| babs summer ale | |
| babs winter lager | |
| babs Mez | |
| betty victoria | |
| betty corona | |
| betty bud | |
| tory bud lite | |
| sean michelob | |
| sean kirin | |
| john victoria | |
| sells | |
| bar beer price | |
| joe bar bud 5 | |
| joe bar bud lite 3 | |
| joe bar sam adam 6 | |
| joe bar mine 4.5 | |
| joe bar kirin 3.5 | |
| joe bar corona 3 | |
| green st bar sam adam 5.5 | |
| green st bar bud 6 | |
| green st bar michelob NULL | |
| green st bar blue bitter 3 | |
| green st bar red bitter 3 | |
| green st bar michelob 4 | |
| green st bar victoria 3.5 | |
| purple bar bud 4.5 | |
| purple bar sam adam 5 | |
| purple bar taiwan beer 3.5 | |
| purple bar mine 4 | |
| purple bar heinken 4 | |
| purple bar Mez 4.5 | |
| purple bar winter lager 3.5 | |
| purple bar sumter ale 3.5 | |
| purple bar kirin 3 | |
| drunk bud 4.5 | |
| drunk kirin 3 | |
| drunk bud lite 4.5 | |
| drunk michelob 4.5 | |
| drunk blue bitter 3 | |
| drunk red bitter 3 | |
| drunk gold bitter 3.5 | |
| drunk sam adam 5.5 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment