deletion anomaly

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…

Devise a datasheet in access based on a subject table that allows a user to enter information about a subject.  Your subject table should have at least ten (10) fields, including:- A primary key field to identify the record ([aut*-RecordIdentifier]).- A single field alternate key.- AT least one date field.- At least one number field.- The standard fields.- Any other fields that you think are appropriate.

In Chapter 13, lab problem 5 of Database Systems and Management. I am using inputting the code:  SELECT CUS_CODE, P_CODE, SUM(SALE_UNITS*SALES_PRICE) AS TOTSALES FROM DWDAYSALESFACT GROUP BY ROLLUP(CUS_CODE, P_CODE);    into the mySQL shell. (Note: solution on site was incomplete missing an (, but it was otherwise logical and makes sense even to me.   However, the shell won't accept the query and says:   ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(CUS_CODE, P_CODE)' at line 3.    I am not sure what I am missing. The instructions expressly tell you to use Rollup in the questions. And the rest makes sense.