#include <stdio.h>
#include <time.h>

char codes[500][4];

int rando()
{ return (rand()/3); }

void main(void)
{ FILE *script, *flights;
  int npass,pass,flight,month,day,date,i,j,k,price,paid,went;
  char seat[10];
  srand(time(NULL));
  script=fopen("makereservations","w");
  if (script==NULL) exit(1);
  flights=fopen("reservations","w");
  if (flights==NULL) exit(1);
  fprintf(script,"create table reservations\n");
  fprintf(script,"( passenger int,\n");
  fprintf(script,"  flight int,\n");
  fprintf(script,"  date int,\n");
  fprintf(script,"  seat char(3),\n");
  fprintf(script,"  price int,\n");
  fprintf(script,"  paid char(1),\n");
  fprintf(script,"  went char(1));\n");
  fprintf(flights,"PASGR FLT DATE____ SEAT PRCE P W\n");
  for (i=0; i<200; i+=1)
  { if (i%2==1) 
      npass=10+rando()%20;
    else
      npass=50+rando()%100;
    month=1+rando()%2;
    if (month==1)
      day=1+rando()%31;
    else
      day=1+rando()%28;
    date=19990000+month*100+day;
    flight=100+rando()%100;
    for (j=0; j<npass; j+=1)
    { pass=10001+(rando()%660)*3;
      sprintf(seat,"%d%c",1+j/5,'A'+j%5);
      k=rand()%5;
      if (k==0)
        price=70+rando()%100;
      else if (k<4)
        price=300+rando()%400;
      else
        price=1100+rando()%2000;
    if (month==1)
      paid=(rando()%9==0?'N':'Y');
    else
      paid=(rando()%4==0?'N':'Y');
    if (month==2)
      went='N';
    else if (paid=='N')
      went='N';
    else if (rando()%20==3)
      went='N';
    else
      went='Y';
    fprintf(flights,"%05d %3d %8d %4s %4d %c %c\n",pass,flight,date,seat,price,paid,went);
    fprintf(script,"insert into reservations values (%05d, %d, %d, \'%s\', %d, \'%c\', \'%c\');\n",
            pass,flight,date,seat,price,paid,went); } }
  fclose(flights);
  fclose(script);  }