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

Identify the primary keys and foreign keys in the three tables by dropping the correct column name or names into the table. If there is no primary or foreign key then drop none as your answer.

Table	Primary Key	Foreign Key(s)
Camper	SelectCAMPER_NUMBERCAMPER_LAST_NAMECAMPER_FIRST_NAMECAMPER_ADDRESSCAMPER_CITYCAMPER_STATECAMPER_ZIP_CODECAMPER_DRIVERS_LICENSECAMPER_EMAILNoneItem 1	SelectCAMPER_NUMBERCAMPER_LAST_NAMECAMPER_FIRST_NAMECAMPER_ADDRESSCAMPER_CITYCAMPER_STATECAMPER_ZIP_CODECAMPER_DRIVERS_LICENSECAMPER_EMAILNoneItem 2
Spot	SelectSPOT_NUMBERSPOT_NAMESPOT_LENGTHSPOT_PULLTHRUSPOT_ELECTRIC_AMPSSPOT_WATERSPOT_SEWERSPOT_RATE_WEEKDAYSPOT_RATE_WEEKENDNoneItem 3	SelectSPOT_NUMBERSPOT_NAMESPOT_LENGTHSPOT_PULLTHRUSPOT_ELECTRIC_AMPSSPOT_WATERSPOT_SEWERSPOT_RATE_WEEKDAYSPOT_RATE_WEEKENDNoneItem 4
Reservation	SelectRESV_NUMBERRESV_DATERESV_NIGHTSSPOT_NUMBERCAMPER_NUMBERRESV_RATERESV_DEPOSITNoneItem 5	SelectRESV_NUMBERRESV_DATERESV_NIGHTSSPOT_NUMBERCAMPER_NUMBERRESV_RATERESV_DEPOSITCAMPER_NUMBER and SPOT_NUMBERNone

Answer rating: 100% (QA)

In the camper table the primary key is CAMPERNUMBER This table has no foreign keys In spot t... View the full answer