The following three tables make up a simple reservation system for a small campground. The database should
Question:
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 |
Fundamental Statistics for the Behavioral Sciences
ISBN: 978-1285076911
8th Edition
Authors: David C. Howell