schema

schema

group: clinic_data

clinic = {
	clinicID:number, hName:string, hAddress:string, hCity:string
	123,  		 'North York', 'NY Address',	 'Toronto'
	234,	         'Scarborough' 'S Address',	 'Toronto'
	456,	         'Bronx'	'B Address',     'NYC'
	789,	         'Toronto Gen' 'TG Address',	 'Toronto'
}

department = {
	departmentID:number, clinicID:number, dName:string, dHead:number
	100,		     123,	      'Dept A',	    500
	101,		     123,	      'Dept B',	    500
	102,		     123,	      'Dept C',	    501
	103,		     234,	      'Dept D',	    501
	104,		     234,	      'Dept E',	    502
	105,		     789,	      'Dept F',	    503
	106,		     234,	      'Dept G',	    501
}