Question #9 - 25 points

Create table(s) to support collecting data for the following scenario:
	We need to collect some key information about campgrounds in
	national parks.  Each campground has a set number of camp spots,
	some that support accessibility needs, others that do not.  A national
	park may have multiple campgrounds (think Yellowstone).  Each national
	park has a point of contact (first name, last name, email, phone).  The
	same person can be responsible for multiple parks.

	Provide statements to create the tables you think meet the above need.  As
	before, preface each table name with your first initial and full last name.
*/
CREATE TABLE cmauNationalParks
(
	ParkID int IDENTITY (1,1) NOT NULL,
	ParkName varchar(255) NULL
)

CREATE TABLE cmauCampgrounds
(
	CampgroundID int IDENTITY (1,1) NOT NULL,
	ParkID int references cmauNationalParks(ParkID),
	CamgroundName varchar(255) NULL,
	TotalCampgrounds int NULL
)

CREATE TABLE cmauContacts
(
	ContactID int IDENTITY (1,1) NOT NULL,
	FirstName varchar(255) NULL,
	LastName varchar(255) NULL,
	email varchar(255) NULL,
	phone varchar(255) NULL
)

CREATE TABLE cmauCampgroundAssignments
(
	ContactID int references cmauContacts(ContactID),
	CampgroundID int references cmauCampgrounds(CampgroundI)
)