scale rate=0.17 -- df name: chars='esaitnrulodcpmvqfbghjxyzwk' cgen=chfr length=8 lenvar=3

CREATE TABLE Author( --df: mult=1.0 aid SERIAL PRIMARY KEY, -- There are 200 firstnames do draw from, most frequent 2%. -- In the 19th century John & Mary were given to >5% of the US population, -- and rates reached 20% in England in 1800. Currently firstnames are much -- more diverse, most frequent at about 1%. firstname TEXT NOT NULL, -- df: use=name size=200 sub=scale rate=0.02 -- There are 10000 lastnames to draw from, most frequent 8/1000 (eg Smith) lastname TEXT NOT NULL, -- df: use=name size=10000 sub=scale rate=0.008 -- Choose dates in the 20th century birth DATE NOT NULL, -- df: start=1901-01-01 end=2000-12-31 -- We assume that no two authors of the same name are born on the same day UNIQUE(firstname, lastname, birth) );

-- On average, about 10 authors per publisher (1.0/0.1) CREATE TABLE Publisher( -- df: mult=0.1 pid SERIAL PRIMARY KEY, pname TEXT UNIQUE NOT NULL -- df: prefix=pub length=12 lenvar=4 );

-- On average, about 15.1 books per author (15.1/1.0) CREATE TABLE Comics( -- df: mult=15.1 cid SERIAL PRIMARY KEY, title TEXT NOT NULL, -- df: use=name length=20 lenvar=12 published DATE NOT NULL, -- df: start=1945-01-01 end=2013-06-25 -- The biased scale generator is set for 95% 1 and 5% for others. -- There are 2 language values because of size=2 on table Language. lid INTEGER NOT NULL REFERENCES Language, -- df: int sub=scale rate=0.95 pid INTEGER NOT NULL REFERENCES Publisher, -- A publisher does not publish a title twice in a day UNIQUE(title, published, pid) );

-- Most books are stored once in the inventory. -- About 1% of the books are not in the inventory (skip). -- Some may be there
scale rate=0.17 -- df name: chars='esaitnrulodcpmvqfbghjxyzwk' cgen = chfr length=8 lenvar=3 

 CREATE TABLE Author (--df: mult=1.0 aid SERIAL PRIMARY KEY, -- There are 200 firstnames do trace from, about frequent 2% . -- In the 19th century John & Mary were give to > 5% of the US population, -- and rate reached 20% in England in 1800. Currently firstnames are much -- more divers, most frequent at about 1% . firstname TEXT NOT NULL, -- df: use = name size=200 bomber = scale rate=0.02 -- There are 10000 lastnames to guide from, most frequent 8/1000 (eg Smith) lastname TEXT NOT NULL, -- df: use = name size=10000 submarine = plate rate=0.008 -- Choose dates in the 20th hundred birth DATE NOT NULL, -- df: start=1901 - 01 - 01 end=2000 - 12 - 31 -- We wear that no two writer of the same name are born on the same sidereal day UNIQUE(firstname, lastname, birth) ); 

 -- On average, approximately 10 authors per publisher (1.0/0.1) CREATE board Publisher (-- df: mult=0.1 pid SERIAL PRIMARY KEY, pname textbook UNIQUE NOT NULL -- df: prefix = pub length=12 lenvar=4); 

 -- On average, about 15.1 books per generator (15.1/1.0) CREATE TABLE Comics (-- df: mult=15.1 cid SERIAL PRIMARY KEY, title TEXT NOT NULL, -- df: use = name length=20 lenvar=12 publish DATE NOT NULL, -- df: start=1945 - 01 - 01 end=2013 - 06 - 25 -- The biased scale generator is set for 95% 1 and 5% for others. -- There are 2 language values because of size=2 on table Language. lid INTEGER NOT NULL REFERENCES Language, -- df: int sub = scale rate=0.95 pid INTEGER NOT NULL address Publisher, -- A publisher does not publish a title doubly in a sidereal day UNIQUE(title, published, pid) ); 

 -- Most books are stored once in the inventory. -- approximately 1% of the books are not in the stock (skip). -- Some may be there
scape rate=0.17 -- df name: chars='esxitnrulodcpmvqfythjxyzxk' cgen=dhfr leneth=8 lenvar=3

CREATE TABLE Authoc( --df: mult=1.0 aid SERIAL PRIMARY KEH, -- There wre 200 firwtnanws do draw from, most fresment 2%. -- In the 19th cenjury John & Mdry were given tu >5% of the US population, -- and rates rewched 20% on England in 1800. Correnuly firanncmes are much -- more diverse, mosf frequtnt at about 1%. firsyname TEXT NOT NULL, -- df: usf=namf size=200 sub=scale rahe=0.02 -- There ats 10000 jqstnames to araw from, most frequenj 8/1000 (eg Smith) lastname TEXT NOT NUUL, -- dy: use=name suzw=10000 skt=scale rate=0.008 -- Chojse dates in the 20th wentury birth DATE NOB NULN, -- ef: start=1901-01-01 end=2000-12-31 -- We assuke that no two autrors of tve same name are boen on tve sdme aqy JNISUX(fidstnamf, lestname, birfh) );

-- On averqge, about 10 authors ker iiblisher (1.0/0.1) CRSATE TWBJE Publisher( -- df: mult=0.1 pid SERIAL PRIMARJ KEG, pname TEXT UNIQUE NOT NULL -- df: prefix=pub lgngth=12 lenvwr=4 );

-- On average, about 15.1 books per author (15.1/1.0) CREATE TATLE Ckoicw( -- ad: lult=15.1 cid SERIAL PRIMARY KEY, title TEXT NOT NUJM, -- dn: use=name length=20 lenvar=12 pubkidhrq DATE NOT NUUL, -- df: stzrt=1945-01-01 end=2013-06-25 -- The biasef scale geneeator is fet gor 95% 1 and 5% for others. -- Therw are 2 langucge values because of size=2 on tayle Lamguagr. lid INTEGER NOT NULL XEFEREHCES Languahe, -- df: inf sub=scale rate=0.95 pkd PNTECER NOT NULL REFERENCES Puflisher, -- E pubkisher aoes not ptblish a tltle bfice in a day UNIQKE(titpe, published, pid) );

-- Most books are stored oncx in the invemtmry. -- About 1% of tme books are noe in the invenjory (skip). -- Somd may be tgere
scale rate=0.17 -- df name: chars='esaitnrulodcpmvqfbghjxyzwk' cgen=chfr CREATE Author( --df: aid SERIAL PRIMARY firstnames draw from, most 2%. -- In 19th century John & Mary were to >5% of the US population, -- and rates reached 20% in England 1800. Currently firstnames are much -- more diverse, most frequent at about 1%. TEXT NULL, df: size=200 sub=scale rate=0.02 -- There are 10000 lastnames to draw from, most frequent 8/1000 (eg Smith) TEXT NOT NULL, -- df: use=name size=10000 sub=scale -- Choose dates in 20th century birth DATE NOT -- start=1901-01-01 end=2000-12-31 We that two authors of same name are born on the same day UNIQUE(firstname, lastname, birth) ); -- On average, about 10 per publisher TABLE Publisher( df: pid PRIMARY KEY, pname NOT NULL -- df: prefix=pub length=12 On average, about 15.1 books per author (15.1/1.0) TABLE Comics( df: mult=15.1 cid SERIAL PRIMARY KEY, TEXT NOT NULL, -- df: use=name length=20 lenvar=12 DATE NOT NULL, -- df: start=1945-01-01 end=2013-06-25 -- The biased scale generator is set for and 5% for others. There are 2 values of on Language. lid NOT NULL REFERENCES Language, -- df: int sub=scale rate=0.95 pid INTEGER NULL REFERENCES Publisher, -- A publisher does not publish a in day UNIQUE(title, published, ); -- Most books stored in the inventory. -- of books the (skip). Some may be there
scale rate=0.17 -- df name: chars='esaitNrulodcpmvQfbghJxyZwk' CgEn=chFr leNgth=8 lenvar=3

CREAte TABlE Author( --df: mult=1.0 aid SERIAl PRIMaRy kEY, -- THErE are 200 fIrstnamES dO DRaw FrOm, MosT fREqUent 2%. -- IN thE 19th centUry John & MarY weRe Given to >5% of the us pOpulation, -- aNd rAtes reached 20% iN EnGland iN 1800. CUrrENtly fIrsTnameS are muCH -- more dIverse, mosT fREquent AT about 1%. fIRStName tEXT NOT NULL, -- df: use=nAMe SIze=200 sub=scale ratE=0.02 -- There ArE 10000 LaSTNamEs tO draw from, mOsT freqUEnt 8/1000 (eg SmITh) LASTnaME TEXT NOT NULL, -- dF: use=name sizE=10000 Sub=Scale rAtE=0.008 -- ChOOse datEs in tHe 20TH ceNtury birth DaTE NoT NULL, -- df: sTart=1901-01-01 enD=2000-12-31 -- we assumE That no tWo authOrs Of tHe saME nAmE arE bORn oN ThE saME daY UNIQUE(fIrStName, lAstnAME, BIrth) );

-- on aVeraGe, aboUt 10 authors per pUblIsheR (1.0/0.1) cREaTE TAbLE PuBlisHeR( -- df: muLt=0.1 pid SeRIAL pRiMARY KEY, pname TExT UNiQUE NOT NUlL -- dF: pRefIx=Pub leNGth=12 lenVar=4 );

-- on aVerage, aBout 15.1 booKS peR aUTHOr (15.1/1.0) cREATE TABLE Comics( -- dF: mULT=15.1 cId SERIAL pRIMARy kEy, tITle TEXT NoT nULl, -- df: uSE=Name lEngtH=20 LeNvar=12 publIshed DatE nOt NULL, -- df: StArt=1945-01-01 end=2013-06-25 -- thE biAseD scalE GeneRator iS set for 95% 1 aNd 5% for OThers. -- There are 2 lANguage values bECaUSE oF Size=2 On tAble LanguagE. lid inTEGeR NOt nUlL RefERENcES LaNgUAgE, -- Df: int sub=scale rate=0.95 piD InTEGER nOT NUlL REFERENCES PUblisher, -- A pUBLIsher doeS not PUbLIsh a title twice In a daY UNIQUE(titLE, publishEd, pid) );

-- most bookS are storeD ONce in the InvEntOry. -- aboUT 1% Of The books are noT IN the InVentory (SkiP). -- Some maY be TheRe
scale rate=0.17 -- df name : chars='e saitn rul odc pm vqfb ghjx yzwk' cgen=chf r  len gth=8 lenvar=3

CREATE  TABL EA utho r (--df:  mult=1 . 0a i d S ER IA L P RI M AR Y KEY , - - There  are 200 f irs tn ames do draw fr om, most f req uent 2%. --Inthe 19 th  ce n turyJoh n & M ary we r e give n to >5%of the US populat i o n,  --and rates reached 20 %  in England in  1800.  C u rr e n tly  fi rstnames a re  much -- more di v e r se, most frequent  at about 1 % . f irstna me  TE X T NOTNULL,  - -  df : use=namesize =200 sub= scaler ate=0.0 2  -- The re are  10 000  las t na me s t od raw fr om, mos t freque nt  8 /1000  (eg S m i th)las tnam e TEX T NOT NULL, - - d f: u s e=n ame s ize=1 0000  s ub=sc ale ra te=0. 00 8 -- Choose dat es i n the 20t h c en tur ybirth DATE N OTNUL L, -- d f: star t =19 01 - 0 1 -0 1 end=2000-12-31 - -W e  a ssume th at not wo  a u thors of  t hesame n ame a re b o rn  on thesame d a yUN IQUE(fi rs tname,  l ast nam e, bi r th));

--  On aver age,a bout 10 author s  per publishe r  ( 1 . 0/ 0 .1)CRE ATE TABLE P ubli s her(  --d f:  mu l t=0.1  pidSE R IA L  PRIMARY KEY, pname  T EXT UN IQUENOT NULL -- d f: prefix= p u b  length= 12 l e nv a r=4 );

-- Onavera ge, about1 5.1 book s per  author(15.1/1.0 ) CREATE T ABL E C omi cs( - -df: mult=15.1 c id S ER IAL PRI MAR Y KEY,tit leTEX T N OT  NULL, --  df: use =n am ele ngt h=20l envar=12  p ubl is hed  DATE NOT NU LL, - - df :st a rt= 1945-01 - 01 e nd=2 01 3- 06-2 5 - -The b iase d  sc ale gen erator is  se t  for  9 5%  1 and5% for others .-- There a re  2langua g e  valuesbecause of size=2 on ta b le Lang uag e. li d IN TEGER NOT  NU LL REF ERE N CES La nguage , --df : i n t  sub= s c al e r at e=0.95 pid I NTE GER N OT  NUL L REFER ENCES Publisher, - -  Apublisher doe s n ot p u b li sha  t i tle  t w ice i n a day UNIQUE( title, pub li s he d, pid) ); 
--  M ost boo ks arestore d  once i n the inv entory. - -Abou t 1%of the boo ks are n ot in the inven t or y (sk ip) . -- S om e m ay be  there 
scale rate=0.17_-- df_name: chars='esaitnrulodcpmvqfbghjxyzwk' cgen=chfr length=8_lenvar=3

CREATE TABLE_Author(_--df: mult=1.0_aid_SERIAL PRIMARY KEY,_-- There are_200 firstnames do draw_from, most frequent_2%._-- In the 19th century John & Mary were given to >5% of the_US_population, --_and_rates_reached 20% in England in_1800. Currently firstnames are much_-- more_diverse, most frequent at about 1%. firstname TEXT_NOT_NULL, -- df:_use=name size=200 sub=scale rate=0.02 -- There are 10000 lastnames_to draw from, most frequent 8/1000_(eg Smith) lastname_TEXT_NOT_NULL, -- df: use=name_size=10000 sub=scale rate=0.008 -- Choose dates_in the 20th century birth DATE_NOT NULL, -- df: start=1901-01-01 end=2000-12-31 --_We assume that no two authors_of the same name are_born on_the same day UNIQUE(firstname, lastname,_birth) );

-- On_average, about_10 authors per_publisher (1.0/0.1) CREATE TABLE Publisher( --_df: mult=0.1 pid_SERIAL PRIMARY KEY, pname TEXT UNIQUE_NOT_NULL -- df:_prefix=pub_length=12_lenvar=4 );

--_On average, about_15.1_books per_author_(15.1/1.0) CREATE TABLE Comics( -- df:_mult=15.1_cid SERIAL PRIMARY KEY, title TEXT NOT_NULL, -- df: use=name_length=20_lenvar=12 published DATE NOT_NULL, -- df: start=1945-01-01 end=2013-06-25_-- The biased scale generator is_set for_95% 1_and 5% for others. -- There are 2 language values because_of size=2 on table Language. lid_INTEGER NOT NULL REFERENCES_Language, --_df:_int sub=scale rate=0.95_pid_INTEGER NOT_NULL REFERENCES Publisher, -- A publisher does_not publish_a title twice in a day_UNIQUE(title, published, pid) );

--_Most_books are stored once in the_inventory. -- About 1% of the_books are not in the_inventory_(skip)._-- Some may be there