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
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 |
hes PCAPER FIRST OPERA CAMPER CITY CAPER STATE CAREERS LEC Q Search the coue
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To complete the Crows Foot ERD for the campground reservation system youll need to establish the rel...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Constraint Databases And Applications Second International Workshop On Constraint Database Systems Cdb 97 Delphi Greece January 1997 Cp 96 Workshop On Constraints And Databases Cambridge Ma Usa August 1996 Selected Papers Lncs 1191
Authors: Volker Gaede ,Alexander Brodsky ,Oliver Gunther ,Divesh Srivastava
1st Edition
3540625011, 978-3540625018
