C Starting from the Office Depot headquarter in Wichita (Depot node 0), you are expected to determine a route for a salesman visiting all four clients (nodes 1, 2, 3, and 4) in four different cities once and returning to the headquarter. Distance between the two nodes is displayed below. Distance 0 (Headquarter) 1 2 3 4 0 N/A (Headquarter) 1 10 10 12 11 10 N/A 9 7 8 2 10 9 N/A 13 12 3 12 7 13 N/A 10 4 11 8 12 10 N/A Apply the Brute Force approach to analyze the problem. Numeric answers are only accepted. (a) How many routes should be considered? Blank 1 (b) What is the route for the salesman? (Hint: If the salesman visits 0 1 2 3 -> 4-> 0, then you should answer 012340). Blank 2

You are in charge of designing a location-based search service for Google. When a ner search for a service name on Google map (such as plumber, handyman, the system should generate a ranked list of suggested services. Can you design a ranking algorithm to provide the top 5 services. You can assume you have all y information such as the business website, address, clickthrough dats etc. Your ranking algorithm should take into consideration at least 3 factors and provide rationale for these 3 factors.

Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to theWashington, D.C. area. In recent years, LOST has grown quickly and is havingdifficulty keeping up with all of the various information needs of the company. Thecompany’s operations are as follows:LOST offers many different tours. For each tour, the tour name, approximatelength (in hours), and fee charged is needed. Guides are identified by anemployee ID, but the system should also record a guide’s name, home address,and date of hire. Guides take a test to be qualified to lead specific tours. It isimportant to know which guides are qualified to lead which tours and the datethat they completed the qualification test for each tour. A guide may be qualifiedto lead many different tours. A tour can have many different qualified guides.New guides may or may not be qualified to lead any tours, just as a new tour mayor may not have any qualified guides.Every tour must be designed to visit at least three…

Consider the process of reserving a bus ticket over the phone and write a step by step use case description/ elaboration of the case study given below: When a customer calls the Agent on the phone, they are asked about the Arrival date and time, and the Destination city. The agent then informs the customer about the available route timings. The customer then selects the appropriate route timings and number of seats he wants to reserve. The agent confirms if seats are available, then asks the customer for his name and phone number. Finally, the agent informs to the customer about successful reservation.

Complete the following table. Customer Arrival Time 0 3 8 10 15 28 1 2 3 4 5 6 Service Time 10 3 21 11 8 Finish Time Wait Time Assume there are two queues, what is the average waiting time?

The worksheet shown in the figure below contains two years of sales that will be used to create a PivotChart. The goal is to create a column chart that shows the total sales dollars by year for each month. Given this goal, what would be the best chart area to place the Year field? 1 2 3 4 3 6 7 . 9 10 11 12 13 14 15 Year Month 2017 April 2018 April 2017 August 2018 August 2017 December 2018 December 2017 February 2018 February 2017 January 2018 January 2017 July 2018 July 2017 June 2018 June VALUES O LEGEND AXIS FILTERS Total Sales Dollars $ 50,970.00 $ 48,400.00 $ 52,470.00 $ 50,700.00 $112,425.00 $120,000.00 $ 56,205.00 $ 56,850.00 $ 59,940,00 $ 62,950.00 $19.980.00 $ 18,500.00 $ 22.485.00 $ 21,000.00

Cozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person.  Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff.The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office. 1.Identify and briefly discuss three main issues that Cozy Inn could face in the absence of an information system to integrate the business processes. 2.Discuss briefly how Cozy Inn can make use of…

Cozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person.  Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff.   The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office.   List and briefly discuss five of the business processes in the organisation.

Cozy Inn is a low-cost family accommodation in a New Zealand resort town. Cozy Inn reception is open 24/7. Reception desk staff take bookings over the phone and in person.  Rooms at Cozy Inn are large, family-style rooms. There are tea-making facilities in each room. Breakfast is served to all the occupants. At the time of check in, reception desk staff ask the customers to choose the breakfast menu option for the duration of their stay. This information will be noted in a spreadsheet. At 6.00 am every day, a printed copy of this spreadsheet will be given to the kitchen staff.   The current business is using a simple informative website, a workstation, five desktops, three laptops and two network printers that are all connected using a small local area network (LAN) in the reception office 1.When the Cozy Inn decides to use online systems, what is the customer-related information that needs to be protected and what are the major ways by which they should protect individual privacy of…

We have established a Book Club at University. The students can donate the books they no longer need, andneedy student can take the book they want from the club. An ISBN is an International Standard Book Numberused to uniquely identify the book as well as the specific title, edition and format. Our book bank can have multiplecopies of the same book as many students in the class can donate same course book after the semester. We alsomaintain a simple interger book-id to unique identify the books. A book can have multiple authors. We havedesigned the following relational database schema for book club. Book (book_id, title, ISBN, publisher, edition, no_of_copies)Author (book_id, author_name)Book_Recieved(book_id, Member_ID, date)Book_Issued (book_id, Member_ID, issue_date, return_date)Member (Member_ID, RollNo, name, email, department) a) Identify domain for each column.b) Identify the primary key and candidate keys in each table.c) Populate the relations with a few sample tuples, and…