comp3278 assignment 3

relax-group.txt

group: COMP3278 Assignment3

Facilities = {
	fID:number, name:string, category:string  , maxUser:number
	1         , 'fac1'     , 'Stationary bike', 10            
	2         , 'fac2'     , 'Treadmill'      , 11            
	3         , 'fac3'     , 'Treadmill'      , 12            
	4         , 'fac4'     , 'Treadmill'      , 13            
	5         , 'fac5'     , 'Treadmill'      , 14            
	6         , 'fac6'     , 'Treadmill'      , 15            
	7         , 'fac7'     , 'Treadmill'      , 16            
	8         , 'fac8'     , 'Treadmill'      , 17            
	9         , 'fac9'     , 'Treadmill'      , 18            
	10        , 'fac10'    , 'Stationary bike', 19            
	11        , 'fac11'    , 'Stationary bike', 30            
	12        , 'fac12'    , 'Stationary bike', 31            
}

Members = {
	mID:number, name:string, gender:string
	1         , 'mem1'     , 'M'          
	2         , 'mem2'     , 'M'          
	3         , 'mem3'     , 'M'          
	4         , 'mem4'     , 'M'          
	5         , 'mem5'     , 'M'          
	6         , 'mem6'     , 'F'          
	7         , 'mem7'     , 'F'          
	8         , 'mem8'     , 'F'          
	9         , 'mem9'     , 'F'          
	10        , 'mem10'    , 'F'          
}

Booking = {
	bID:number, mID:number, fID:number, date:date
}