The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits.

Table: Camper

CAMPER_NUMBER	1000	1001	1002	1003
CAMPER_LAST_NAME	Jones	Schmidt	Williams	Cooper
CAMPER_FIRST_NAME	Jamie	Pat	Clifford	Amanda
CAMPER_ADDRESS	1278 Essex Pl	4954 Spangled Way	956 Segull Lane	P. O. Box 998877
CAMPER_CITY	Birmingham	El Paso	Portland	Portsmouth
CAMPER_STATE	AL	TX	ME	OH
CAMPER_ZIP_CODE	45251	79919	4108	45662
CAMPER_DRIVERS_LICENSE	JJ998743-98	87632434	WIL885123	765A876B897
CAMPER_EMAIL	jjones@somewhere.com	patwonderfu34l@nowhere.net	williams98342@foomail.com	coopera@nowhere.net

Table: Spot

SPOT_NUMBER	101	102	103	104
SPOT_NAME	The Pines	The Glade	Teardrop Spot	Tent In Trees
SPOT_LENGTH	55	50	20	0
SPOT_PULLTHRU	1	0	0	0
SPOT_ELECTRIC_AMPS	50	50	20	0
SPOT_WATER	1	1	1	1
SPOT_SEWER	1	1	0	0
SPOT_RATE_WEEKDAY	35	33	15	12
SPOT_RATE_WEEKEND	42	42	22	15

Table: Reservation

RESV_NUMBER	1	2	3	4	5
RESV_DATE	2015-05-15	2015-05-14	2015-05-14	2015-05-20	2016-06-01
RESV_NIGHTS	2	4	4	1	2
SPOT_NUMBER	101	103	104	101	101
CAMPER_NUMBER	1002	1000	1001	1002	1002
RESV_RATE	84	150	24	35	85
RESV_DEPOSIT	20	25	24	10	0

Add the ends to the relations on the Crows Foot ERD for the campground reservation system.

Transcribed image text