Question

The following table lists the common names by which beer drinks of various volumes may be ordered in hotels in the states of Australia. Volumes are measured in fluid ounces (oz). The sample data is significant. A double hyphen indicates that beer drinks of that volume are not on sale in that state. For instance, in Queensland exactly three different beer drinks may be ordered. Schematize this UoD.

Answer 1

Hi,

I am giving the table names directly for your convenience with SQL syntax.

CREATE TABLE CITY (

CityCode varchar(5) NOT NULL PRIMARY KEY

Ounces int references Quantity (Ounces),

BeerName varchar(32) references Beers (BeerName)); CREATE TABLE BEERS ( BeerName varchar(32) NOT NULL PRIMARY KEY); CREATE TABLE QUANTITY ( Ounces int NOT NULL PRIMARY KEY); The City table consists of the city code and the Beer names (from Beers table) and its relevant Ounces (from the Quantity table). Eg of a record - First one is Data of Beers table, second one is data of Quantity table and third one is data of City table. Beers Small Beer Glass Pot Pony Seven Middy Schooner Pint Butcher Shetland Six Eight Handle Ten Quantity 4 Oz 5 Oz 6 Oz 7 Oz 8 Oz 10 Oz 15 Oz 20 Oz City Qld Small Beer 5 Oz NT Handle 10 Oz So, we can get all the relevant data as mentioned in the above table.