Suppose that your university has a tie-upwith a travel agency which helps plan tripsfor students. The agency provides information on resorts, room types, room capacity,room rate, and availability. Students can bookthrough the agency, while payment is madedirectly to the resort. Construct an E-R modelfor this scenario.

Suppose that your university has a tie-upwith a travel agency which helps plan tripsfor students. The agency provides information on resorts, room types, room capacity,room rate, and availability. Students can bookthrough the agency, while payment is madedirectly to the resort. Construct an E-R modelfor this scenario.

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter11: Nonlinear Programming

Section11.13: Pareto Optimality And Tradeoff Curves

Problem 5P

See similar textbooks

Similar questions

Question 2: Suppose you have the following scenario: People who use the Palm Tree System are either farmers or experts. They both have name and phone number. The farmer has an address and has the ability to search and buy a product, reserve an appointment and add comments. An expert has a number of years of experience and can answer questions and post advices. An Expert can communicate with many farmers while a farmer can communicated by only one expert. By using Star UML tool, draw a Class diagram for this scenario.
Let’s say, you are given a task to identify the community which is severely infected by a virus such as Covid-19. As an environmental engineer, using the concepts of conditional probability, how can you develop a mathematical model to identify the infected community. Write all the parameters and show their relationships?
Question 2: Suppose you have the following scenario: People who use the Palm Tree System are either farmers or experts. They both have name and phone number. The farmer has an address and has the ability to search and buy a product, reserve an appointment and add comments. An expert has a number of years of experience and can answer questions and post advices. An Expert can communicate with many farmers while a farmer can communicated by only one expert. By using Star UML tool, draw a Class diagram for this scenario.
Draw an ER model based on following scenario.A travel agency has different bus stations at different location. Each station has a unique name, locationand buses. Each bus has a unique bus number, color and type. The bus takes routes between stations.Each route has a name, arrival time and departure time. A single bus can take routes to different stations.Some buses may not take any route in some days however a station must have a route each day. Eachbus contains seats. Each seat has unique number, row and seat type. There are three different types ofseats as first class, standard and economy. Passengers can make reservations. Passenger has id number,full name, age, gender and address. Each reservation will have a unique reservation number, fare, dateand time. Each reservation can have any numbers of seats. The reservation is dependent on passenger.
A partially completed version of the worksheet is shown below. To complete the spreadsheet, you need to understand the discount policy, which states that a discount is given if the total sale is equa to or greater than the discount threshold. Complete the worksheet in the figure, then create two additional scenarios for different selling strategies. In one scenario lower the discount threshold and discount percentage to $3000 and 12%, respectively. Increase these values in a second scenario to $10,000 and 20%. Save all three scenarios and submit the completed assignment. MIAMI, FLORIOA AMOUNTOF OisCoUNT DISCOUNTED TOTAL SALES TAX AMOUNT DUE PROGRAM CURRENT PRICE UNITS SOLD 1OTAL SALE CUSTOMER NAME AAA SOFTWARE SALES Norton Utities COMPUSOFT. INC 35 45 15 30 17 116.99 Microsoft Office 2010 $ 317.95 కం 55 59.99 KINGS BAY SOFTWARE Adobe Photoshop MICROSALES INC PC& Me software Personal Software Sales Quicken Deluxe Service Software Software and More Software to go Unique Software Sales…
Consider the following Scenario the Modeling of which you have completed in Assignment1: The Ministry of XYZ is the government body in the in charge of religious affairs. The application for Hajj is submitted to the hajj directorate, part of XYZ Ministry. Initial documents are submitted to the hajj directorate for registration. Documents are checked and verified by the Assistant Registration Officer. There are two categories of applicants based on their nationality. Specified percentage of seats are fixed for locals and other nationals. A unique registration number is issued to each applicant by the Assistant Registration Officer. After the completion of registration process, each applicant is asked to submit the detailed documentation which includes passport, vaccination certificate, medical certificate, receipts of payments. One Additional document (permission letter from home country) is needed for other national. Payments can be made through cash or card. Assistant Registration…
A publisher plans to boost the sales of its most popular magazine by sending out promotional mails. We refer to a customer as a responder if he/she subscribes to the magazine for the next year after receiving a promotional mail. Otherwise the customer is referred to as a non-responder. Denote responder by C1 and non-responder by C2. The publisher has built a model to classify each customer as either a responder or a non-responder. In practice only 1% of the customers are responders, and the remaining 99% are non-responders. In order to build an unbiased model, the publisher employed the oversampling method in creating the training set and the validation set, such that both datasets contain 50% responders and 50% non-responders. The validation confusion matrix is given below. Actual Class C1 C2 Predicted Class C1 645 112 C2 255 788 Round your answers to 3 digits after the decimal point. The oversampling factor of C1 is . The oversampling factor of…
This is the problem Create a complete ERD in Crow’s Foot notation that can be implemented in therelational model using the following description of operations. Hot Water (HW) is asmall start-up company that sells spas. HW does not carry any stock. A few spas areset up in a simple warehouse so customers can see some of the models available, butany products sold must be ordered at the time of the sale.• HW can get spas from several different manufacturers.• Each manufacturer produces one or more different brands of spas.• Each and every brand is produced by only one manufacturer.• Every brand has one or more models.• Every model is produced as part of a brand. For example, Iguana Bay Spas is amanufacturer that produces Big Blue Iguana spas, a premium-level brand, andLazy Lizard spas, an entry-level brand. The Big Blue Iguana brand offers severalmodels, including the BBI-6, an 81-jet spa with two 6-hp motors, and the BBI-10,a 102-jet spa with three 6-hp motors.• Every manufacturer is…
. Draw the ERD for the following scenario. In a university, a Lecturer can teach many different courses and even the same course numerous times. Courses can also be taught by many lecturers. A student is enrolled in only one program but a program can contain many students. Students can be rolled in many courses at the same time and the courses have many students enrolled.
Read the following scenario and answer the questions given bellow.• A car rental company has its offices in three major cites of the area. Acostumer once registered with the company, can avail its services from anynearby office. Every office keeps record of the vehicles, their drivers andrenting details. Salaries of administrative staff are controlled at a single sitewhile the drivers are paid (according to the services they provide) from their local office. Rates for famous tourism spots are fixed (with a slight difference for different vehicles), while other spots are charged according to the mileage covered. 1. Identify the entities involved in the database designed for thecompany.2. Draw GCS for the system.3. Give details of any of the relations replicated on more than one sites
b. Consider a tiny social network containing high school students and their "crushes" (desired romantic relationships example: BTS or TWICE). Each student may have a crush on at most one other student and associated with each crush is the length of time the crush has been going on. Students have a name and a grade, and names are unique. Draw a UML diagram that models this information. Make sure to capture the asymmetry and multiplicity of the crush relationship.
In order to implement the expected system, the following information have been received from the managers of INSIGHTS: A company can request one or more quotations. A quotation is issued by a salesman. It concerns one or more stands. It may also be concerned by an invoice. A stand has a type. An invoice is issued by a salesman. Based on the salesman, a discount will be applied to this invoice. The company will pay one or more invoices. The company can make one or more reservations. Every reservation concerns one or more stands. The company can cancel a reservation. In this case, a penalty pay be applied. The salesman is controlled by one supervisor. The supervisor generates one or more reports. A report concerns the stands. It also concerns the companies. Question: Propose a UML class diagram for the process described above.