Assignment: Chapter $03$ Use It Assignment Score: $50\mathrm{.}00\%$

Keyboard Navigation Help

Questions

Previous Question $2$ of $2$

co$5$ds$13$h$.$Ch$03\mathrm{.}02$

$1.$ Answered Correctly

$2.$ Answered Incorrectly

Question Workspace

Clear All Check My Work

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$\_$LAST$\_$NAME CAMPER$\_$FIRST$\_$NAME CAMPER$\_$ADDRESS CAMPER$\_$CITY CAMPER$\_$STATE CAMPER$\_$ZIP$\_$CODE CAMPER$\_$DRIVERS$\_$LICENSE CAMPER$\_$EMAIL

$1000$ Jones Jamie $1278$ Essex Pl Birmingham AL $45251$ JJ$998743-98$ jjones@somewhere.com

$1001$ Schmidt Pat $4954$ Spangled Way El Paso TX $7991987632434$ patwonderfu$34$l@nowhere.net

$1002$ Williams Clifford $956$ Segull Lane Portland ME $4108$ WIL$885123$ williams$98342$@foomail.com

$1003$ Cooper Amanda P$.$ O$.$ Box $998877$ Portsmouth OH $45662765$A$876$B$897$ coopera@nowhere.net

Table: Spot

SPOT$\_$NUMBER SPOT$\_$NAME SPOT$\_$LENGTH SPOT$\_$PULLTHRU SPOT$\_$ELECTRIC$\_$AMPS SPOT$\_$WATER SPOT$\_$SEWER SPOT$\_$RATE$\_$WEEKDAY SPOT$\_$RATE$\_$WEEKEND

$101$ The Pines $55150113542$

$102$ The Glade $50050113342$

$103$ Teardrop Spot $20020101522$

$104$ Tent In Trees $000101215$

Table: Reservation

RESV$\_$NUMBER RESV$\_$DATE RESV$\_$NIGHTS SPOT$\_$NUMBER RESV$\_$RATE RESV$\_$DEPOSIT

$12015-05-15210110028420$

$22015-05-144103100015025$

$32015-05-14410410012424$

$42015-05-20110110023510$

$52016-06-0121011002850$

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

Hide Feedback

Incorrect

Clear All Check My Work

Icon Key

Previous Question $2$ of $2$co$5$ds$13$h$.$Ch$03\mathrm{.}02$