Concept explainers
A zoo has categorized its visitors into three categories: member, school, and general. The member category refers to visitors who pay an annual fee to support the zoo. Members receive certain benefits such as discounts on merchandise and trips planned by the zoo. The school category includes faculty and students from day care and elementary and secondary schools; these visitors generally receive a discounted rate. The general category includes all other visitors. The zoo has been concerned about a recent drop in attendance. To help better understand attendance and membership, a zoo staff member has collected the following data:
- a. Construct a bar chart of total attendance over time. Comment on any trend in the data.
- b. Construct a side-by-side bar chart showing attendance by visitor category with year as the variable on the horizontal axis.
- c. Comment on what is happening to zoo attendance based on the charts from parts (a) and (b).
Want to see the full answer?
Check out a sample textbook solutionChapter 2 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
- Information Systems & Design UML Class Diagram Please explain what is being illustrated in this diagram as well as the relationships that exist! Does the diagram meet the perameters for the following scenario? Health Care System -A health care system has multiple locations throughout the state of Alabama. -There are several different types of locations. -Locations types: 4 hospitals 8 affiliates 21 medical clinics -Each location offers a variety of health care services. A service can be offered at multiple locations. -The different types of health services include: Cancer services Diabetes Da Vinci Robotic Surgery Digestive Health Family medicine Emergency Services Heart Care Orthopedics Sleep Disorders Center Stroke Center Women’s Health Wound Care -Not every location offers every service, of course. Rural locations wouldn’t offer as much as major metro hospitals. -Each location needs to be linked to the health services it offers. Use an association class to model the…arrow_forwardDraw a single ER diagram that represents the specifications listed below. Follow the process below to help you do this: Consider a model of an airport with planes, models of planes, test of planes, and technicians. Draw an ER diagram to represent these entities and their attributes. Planes have a unique registration number. Airplane Models are each identified by a model number (e.g., DC-80, A380, B747), and each have a capacity and a weight. Several technicians work at the airport. You need to store for each technician the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes are safe. Each test has a unique FAA number, a name, and a maximum possible score. Extend your ER diagram with relationships to represent the following information. Each airplane is of one specific model. Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. Transport…arrow_forwardConsider a model of an airport with planes, models of planes, a test of planes, and technicians. Draw an ER diagram to represent these entities and the following attributes.Planes have a unique registration number. Airplane Models are each identified by a model number (e.g. DC-80), and each has a capacity and a weight. A number of technicians work at the airport. You need to store for each the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes aresafe. Each test has a unique FAA number, a name, and a maximum possible score.Extend your ER diagram with relationships to represent the following information.(a) Each airplane is of one specific model.(b) Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. (c) Transport Canada requires the airport to keep track of each time a given airplane is tested using a given test. For each testing event, the…arrow_forward
- Question 2: An organization has three categories of employee: professional staff, technical staff and support staff. The organization also has departments and divisions. Each employee belongs to either a department or a division. Draw a class diagram that captures the above scenario using an appropriate modeling tool. You should add attributes for name, address, ID, location, size into their appropriate classes. You should follow the proper design principles when placing the attributes.arrow_forwardConsider the following scenario and draw an E-R diagram for Cathay airlines. Cathay Airlines stores details about an airline’s fleet, flights, and seat bookings. The airline has one or more airplanes and an airplane has a model number, a unique registration number, and the capacity to take one or more passengers. An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time. Each flight is carried out by a single airplane. A passenger has given names, a surname, address and a unique email address. . Each address is made up of a street, a city and a postcode. A passenger can book a seat on a flight.arrow_forwardCreate Entity-Relationship (E-R) model for the internal view of gym membership system including all workers and organization units affected by processing gym memberships. When members join the gym, they pay a fee for a certain length of time. Most memberships are for one year, but memberships as short as two months are available. Throughout the year, the gym offers a variety of discounts on their regular membership prices (e.g., two memberships for the price of one for Valentine's day). It is common for members to pay different amounts for the same length of membership. The gym wants to mail out reminder letters to members asking them to renew their memberships one month before their memberships expire. Some members have become angry when asked to renew at a much higher rate than their original membership contract, so the club wants to track the prices paid so that the manager can override the regular prices with special prices when members are asked to renew. The system must track…arrow_forward
- A student must complete the basic level before entering the advanced level. After both levels, the student has to pass five examinations. An examination can be retaken at most twice. After the third failed attempt the student’s registration is cancelled Model the different levels using state chart diagramarrow_forwardHypothetically speaking, if you got a job offer and on your first day at work, you noticed that your officemate is a very quiet person and is not warm in welcoming you and avoids socializing with you. Plus, the manager interrupted his work to do some other work and he reluctantly accepted without negotiating, how would you identify your officemate’s personality: A- Assertive B- Aggressive C- Submissive D- Supportivearrow_forwardDevelop a design class diagram and package diagram for a library system according to the given scenario. The library system provides users with the opportunity to borrow books from the library. The system includes a service page that displays all services such as borrowing and computer services. It also includes a catalog where all possible books are categorized. Users can communicate with the library via the details available on the contact page. The system allows only registered users to borrow books and the books are either hardcopy or e-books. To borrow a book the system will have to check for the eligibility of the user before approval. If the user is not eligible, then the request will be declined. Borrowing could be done via the library system or in person. The admin is responsible for the in-person borrowing. For the borrowing of any book, a form that is available on the forms page has to be filled by the user. Also, the system must check for the availability of a book before…arrow_forward
- Information Systems & Design Please help me create a class diagram for the following scenario: Health Care System -A health care system has multiple locations throughout the state of Alabama. -There are several different types of locations. -Locations types: 4 hospitals 8 affiliates 21 medical clinics -Each location offers a variety of health care services. A service can be offered at multiple locations. -The different types of health services include: Cancer services Diabetes Da Vinci Robotic Surgery Digestive Health Family medicine Emergency Services Heart Care Orthopedics Sleep Disorders Center Stroke Center Women’s Health Wound Care -Not every location offers every service, of course. Rural locations wouldn’t offer as much as major metro hospitals. -Each location needs to be linked to the health services it offers. Use an association class to model the relationship. Additional Information:…arrow_forwardDraw an EER diagram for the following problem using this text's EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor. A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City /State/Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and volunteers have only a Skill attribute. Donors have only a relationship (named Donates) with an Iten1 entity type. A donor must have donated one or more items, and an item may have no donors or one or more donors. There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more…arrow_forwardDraw a partitioned activity diagram for the rent car use case of Rent-A-Car. Rent-A-Car company has a website through which a user is allowed to book and pay for their rental cars. When a customer makes a request to rent a car the customer is presented with different car models from the catalog. The customer selects a model. The system checks if a car is available for the model selected. If a particular car is not available, the customer is requested to choose a different model. If the chosen model is available, the rental price is displayed to the customer. The customer needs to confirm if they would like to proceed with renting the car at that price or would like to opt for a different model. If the customer decides to proceed with booking the car, they must upload their driver’s license for verification. The driver’s license is verified by a staff member once it is uploaded. Only if the license is valid, does the system deduct payment and deposit from the clients credit card. If…arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningInformation Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning