CS代写|CS 5200 Homework 2 Conceptual design using UML notation



This assignment gives you an opportunity to create a complex conceptual design from a textual description. For each of the schemas below:

  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.
  1. Create a data dictionary for the entities, relationships and attributes. Make your best guess for representing the attributes.

Schema 1 COVID-19 clinic: (30 points)

Mass General Hospital runs a collection of COVID-19 clinics throughout the city of Boston. A clinic has many staff members who work at it. A staff member has a name, an employee number, (empNo) which is unique for the employee, a job role, as well as a description of the job role. A staff member may only work at one clinic. Each clinic has a unique clinic number (clinicNo) , clinic name, and an address. The clinic has a stock of vaccines that are available for injection. Each vial of the vaccine has a unique serial number to differentiate the vials from each other. Currently there are three vaccine types approved in the US, the Pfizer, the Johnson and Johnson and the Moderna vaccine type. For each vaccine type the clinic must track the number of doses required for full immunization and the time interval (number of recommended days) between the doses.

When a citizen is required to receive a COVID-19 vaccine, he/she contacts a clinic to schedule an appointment. The appointments are an hour in length and can be scheduled from 8AM-8PM on Monday through Friday for a specific day of the year. Each appointment has a unique appointmentId. At the appointment, a citizen is administered the vaccine by a staff member. After that, the citizen is then monitored for a ½ hour by potentially a different staff member for side effects. The side effects are:

allergic reaction, swelling at the point of injection, stiffness at the point of injection, joint stiffness, fever and headache. After the monitoring stage, the patient is then required to monitor him/herself and to contact the clinic if he/she experiences any side effects. The patient is also required to contact the clinic for any further innoculations needed for the vaccine type that has been administered.Schema 2: Wildlife populations. (30 points)

Your goal is to create a database containing wildlife species populations for specific regions in the world.

A region will lie in one country and have one climate associated with it. A country may be situated on 1 to many continents. For each continent you track its name. For each country you also track its name. Each region will have a name and a unique id. For each type of climate you track, the climateId, climateType and a description of the climate.

Surveys are conducted on the various animal species found in the regions across the world. These surveys count the number of animals for each species found in that region. This will provide a general sense of the distribution of the animals in this region. Each tracked species has a scientific name, a common name as well as a unique speciesId. You will survey regions of the world and determine the species found in that region.

Not only are you tracking species’ distributions for the regions, you also are going to monitor individual animals. The monitoring will be done with the help of sensors. Tagging an individual animal involves attaching a sensor tag to the ear of the animal. Each sensor tag has a unique TagId. For each tagged animal you track the sex, the date of the tagging, and the approximate age of the animal.

Schema 3 (40 points)

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.


本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: itcsdx@outlook.com  微信:itcsdx