A small group of specific data is included below.

A large group of random data is not required for this assignment, but
you will get 25% extra credit if you can generate data for 1000 users,
1000 commuting requests, and 1000 other trip requests and handin your
results with this assignment (we don't care how you generated the data
except that your code must be parametric, i.e., 1000 must be a
parameter than one can change to any other reasonable number).  Your
results for this part should include the code that you use to generate
the data and load the data into the database, statistics (including
minimally the row count of each table) of your database obtained using
appropriate SQL queries, together with the code for these SQL queries.

---------------------------------------------------------------------------
Usr(loginName,password,phone,lastName,firstName,email) 
(user01,01,123-456-7890,Vincent,Jimmy,jm@yahoo.com)
(user02,02,098-765-4321,Cage,Nickle,cn@hotmail.com)
(user03,03,111-222-3333,Jordan,Michael,mj@yahoo.com)
(user04,04,222-333-4444,Gates,Bill,gb@hotmail.com)

Student(loginName,major,status) 
(user01,Computer Science,junior)
(user02,Physics,graduate)

FacultyStaff(loginName,department,position)
(user03,Computer Science,professor)
(user04,Physics,professor)

Lives(loginName,addrId)
(user01,1)
(user02,1)
(user03,3)
(user04,4)

Address(id)
(1)
(2)
(3)
(4)
(5)

CampusAddr(addrId,street,roomNo)
(1,Steeley,A101)
(2,Steeley,A102)

ResidenceAddr(addrId,street,state,town,zipcode,nearestIntersection) 
(3,Stony Brook Road,NY,Stony Brook,11790,Centerreach)
(4,Jerusalem Avenue,NY,Sea Ford,11794,Wantagh)
(5,South Station,MA,Boston,01800,South Station)

OptionalInfo(loginName,birthyear,sex,smokerOrNot,
	preferDriveOrNot,commuteCostCompensation,currentCommuteMethod) 
(user02,1976,M,N,N,10,bus)
(user04,1964,F,N,Y,10,drive alone)

Owns(loginName,carId)
(user03,1)
(user04,2)

Car(carId,manufacture,model,year)
(1,Honda,Civic,2000)
(2,Ford,Taurus,2001)

DailyCommute(loginName,startTime,endTime,
	maxMinutesEarlyArrival,maxMinutesLateDeparture,year,season)
(user03,8:00am,6:00pm,10,10,2002,spring)
(user04,9:00am,5:00pm,10,10,2002,fall)

OtherTrip(tripId,date,reason,departureTime,arrivalTime,
	maxMinutesEarlyDeparture,maxMinutesEarlyArrival,costCompensation,
	numberOfPassengers,maxNumberOfPassengers,fromAddr,toAddr,loginName)
(1,03/23/2002,visiting friend,8:00am,12pm,10,30,30,2,0,1,5,user01)
(2,03/02/2002,tennis game,9:00am,15pm,10,60,50,1,2,3,5,user03)
---------------------------------------------------------------------------