1. Create an entity relationship diagram for the conceptual design using UML notation. The diagram can be created by hand or via some modeling tool. 2. Create a data dictionary for the entities, relationships and attributes. Make your best guess for representing the attributes. Schema 3 You have been hired by the Snowbird ski mountain resort to build a database for their data. The resort has ski mountain peaks, chair lifts, trails, stores and restaurants. For each mountain peak, you track the name, the elevation and its latitude and longitude. Each peak name is unique. The names of the mountain peaks are: Mount Superior, Mount Baldy, Twin Peaks and Hidden Peak. For each chair lift, you track a unique name, the vertical rise, the travel time, the number of people per chair (ranging from 2 to 4) , and its closing time. For each trail, you track its unique name, its elevation, its length, and the typical time it takes to complete. Each ski trail is classified by its level of difficulty. The values for the level of difficulty are: easiest represented as a green circle, intermediate represented as a blue diamond, advanced, represented as a black diamond and expert, represented as a double black diamond. Each trail is assigned one and only 1 level of difficulty and there can be 0 to many trails with the same level of difficulty. Each restaurant has a unique name, a description and a cuisine. Each store also has a unique name and a description. A store can be classified as either a ski rental shop, a retail shop or both a retail and a rental shop. Each trail is associated with at least one peak but may cross other peaks. Each mountain peak has at least 1 trail but typically has many trails. Each chair lift is found on one mountain peak and a mount peak will have one to many chair lifts. A chair lift has a collection of trails that it services. Each trial can be reached by 0 to many chair lifts and a chair lift services 1 to many trails. For each chair lift, we need to track the type of terrain that can be reached from it. For example, the only trails that can be reached from the chickadee chair lift are classified as easiest (green trails). Each store is found on 1 and only 1 peak but a peak may have zero to many stores. Each restaurant is found on 1 and only 1 peak but a peak may have zero to many restaurants.
1. Create an entity relationship diagram for the conceptual design using UML notation. The diagram can be created by hand or via some modeling tool.
2. Create a data dictionary for the entities, relationships and attributes. Make your best guess for representing the attributes.
Schema 3
You have been hired by the Snowbird ski mountain resort to build a
Each restaurant has a unique name, a description and a cuisine. Each store also has a unique name and a description. A store can be classified as either a ski rental shop, a retail shop or both a retail and a rental shop.
Each trail is associated with at least one peak but may cross other peaks. Each mountain peak has at least 1 trail but typically has many trails. Each chair lift is found on one mountain peak and a mount peak will have one to many chair lifts. A chair lift has a collection of trails that it services. Each trial can be reached by 0 to many chair lifts and a chair lift services 1 to many trails. For each chair lift, we need to track the type of terrain that can be reached from it. For example, the only trails that can be reached from the chickadee chair lift are classified as easiest (green trails).
Each store is found on 1 and only 1 peak but a peak may have zero to many stores. Each restaurant is found on 1 and only 1 peak but a peak may have zero to many restaurants.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
