1. E/R and UML (40 points) Restaurant chain management database system The following data model is designed to record occupation information relating to a campground chain (Such as KOA campground). For this scenario we need to define the following facts: These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation. Assuming that the campground chain has campgrounds in many locations throughout the United States and each campground has employees and various kinds of campsites: Campgrounds A campground of the Campground Chain may have location information, phone number, etc. Sites name, price. e.g. RV sites $50, tent sites $25, and cabin etc. Customers Name, address (for delivery purpose), phone. etc. The Entities are related as follows: Campgrounds can have various kinds of sites. Customers may stay at various kinds of sites from various campground locations.

When asking questions of the database we may need to know: 1. Which customer stayed at what type of sites in which campground location? 2. The from date and to date the customer stayed.

a) Create an E/R diagram capturing the objects and relationships described above. Describe all your design choices and constraints. Please use the notation for E/R diagrams introduced in the course. Rubrics used will be similar to the homework Rubrics for grading. (15 pts)

Required entity sets 4 pts Appropriate attributes for all entity sets 4 pts Correct Relationships (showing multiplicity) 3 pts Correct E/R format 4 pts

b) Create an UML diagram capturing the objects and relationships described above. Describe all your design choices and constraints. Please use the notation for UML diagrams introduced in the course. Rubrics used will be similar to the homework Rubrics for grading. (25 points)

Required entity sets 5 pts Appropriate attributes for all entity sets 5 pts Correct Relationships (showing multiplicity) 5 pts Correct keys and foreign keys 5 pts Correct UML format 5 pts