edemodb if x$1 = x goto error if ! { creatdb $1 } exit ingres -s $1 < /mnt/ingres/demo/qry echo database $1 created exit : error echo no database name dept~ #Book 7 Candy  Furniture Major Appliances Jewelry !+Children's  AJunior's :Men's <Sportswear  cGiftwrap bBargain Linens ?Women's &1Toys #FWomen's  IChildren's  "Stationary !/Junior Miss Women's  employee pJones, Tim .VSmith, Paul p!#Evans, Michael  Thomas, Tom ' Edwards, Peter (#Collins, Joanne X 7James, Mary .Thompson, Bob 2bWilliams, Judy (# Smythe, Carol Z#!Hayes, Evelyn t'Bullock, J.D. xi%Bailey, Chas M. KSchmidt, Herman +^ Wallace, Maggie J. gChoy, Wanda +7Ferro, Tony 557%Raveen, Lemont .cWilliams, Bruce >4!Zugnoni, Arthur A. MBrunet, Paul C. EIwano, Masahiro =2Onstad, Richard K"  Ross, Stanley $> Ross, Stuart #/item~ XEarrings vTowels, Bath +Maze 1EYjClock Book 1}1 lb Box d*4Jacket < ,Jean A9!Shirt :!xTwin Sheet  -Boy's Jean Suit +!yQueen Sheet _XeSlacks ?@EsGold Ring  2 lb Box, Mix K*wSqueeze Ball 1Y Wash Cloth K?Bellbottoms +X!ABC Blocks }kThe 'Feel' Book #YySki Jumpsuit A}parts~ •central processor pink memory gray  disk drive black tape drive black tapes gray line printer yellow Bl-p paper white _terminals blue  paper tape reader black kpaper tape punch black terminal paper white ^ byte-soap clear card reader gray G card punch gray qry(Ccreate item ( number is i2, name is c20, dept is i2, price is i2, qoh is i2, supplier is i2) create sale ( number is c6, date is c8, store is i2, dept is i2, item is i2, quantity is i2, employee is i2, credit is c8) create employee ( number is i2, name is c20, salary is i2, manager is i2, birthdate is i2, startdate is i2) create dept ( number is i2, name is c20, store is i2, floor is i2, manager is i2) create supplier ( number is i2, name is c15, city is c15, state is c6) create store ( number is i2, city is c15, state is c6) create parts ( pnum is i2, pname is c20, color is c8, weight is i2, qoh is i2) create supply ( snum is i2, pnum is i2, jnum is i2, shipdate is c8, quan is i2) copy item (number is i2, name is c20, dept is i2, price is i2, qoh is i2, supplier is i2) from "{pathname}/demo/item" copy sale ( number is c6, date is c8, store is i2, dept is i2, item is i2, quantity is i2, employee is i2, credit is c8) from "{pathname}/demo/sale" copy employee ( number is i2, name is c20, salary is i2, manager is i2, birthdate is i2, startdate is i2) from "{pathname}/demo/employee" copy dept ( number is i2, name is c20, store is i2, floor is i2, manager is i2) from "{pathname}/demo/dept" copy supplier ( number is i2, name is c15, city is c15, state is c6) from "{pathname}/demo/supplier" copy store ( number is i2, city is c15, state is c6) from "{pathname}/demo/store" copy parts ( pnum is i2, pname is c20, color is c8, weight is i2, qoh is i2) from "{pathname}/demo/parts" copy supply ( snum is i2, pnum is i2, jnum is i2, shipdate is c8, quan is i2) from "{pathname}/demo/supply" range of i is item define permit all on i to all range of s is sale define permit all on s to all range of e is employee define permit all on e to all range of d is dept define permit all on d to all range of s is supplier define permit all on s to all range of s is store define permit all on s to all range of p is parts define permit all on p to all range of s is supply define permit all on s to all \g nsale~ C10058175-01-15v0000000010058175-01-15x0000000010058275-01-15V2435654010058675-01-16+#5409683110058675-01-161j#5409683110059275-01-17:0000000010059375-01-18  1165213310059475-01-18<412591815store~ ΕESan Francisco Calif Oakland Calif El Cerrito Calif 2supplier~ Z Koret Los Angeles Calif Cannon Atlanta Ga !Levi-Strauss San Francisco Calif YFisher-Price Boston Mass }Playskool Dallas Tex *Whitman's Denver Colo White Stag White Plains Neb supply pp73-12-3174-05-31 73-12-3174-05-31z75-02-01z75-02-010z 75-02-0174-10-1073-12-31>74-06-1873-12-31 74-07-0174-11-1575-01-2275-01-1075-01-10K75-06-0175-06-01 75-06-01C75-07-01 76-01-0175-07-01 75-07-01