Julia is a freelance hakers. She receives a few cake orders, for this Saturday. Since she gotquite a number of orders on the same day, so she needs to deliver the cakes in an optimalway.She has studied the distance (in kilometer) to each location, as shown in Table 1. Thedata shown in upper triangular matrix only. This means that the distance between twolocations is same from location a to location b and the other way round. While co meansthere is no direct route between two locations.123456781Table 1: Distance of the locations2 3 4 5 6 75.1 12.5 13.0 7.57.29.28.000 00 00 00 00 00(d) Report the output of the problem.00:00:008.500 15.5910(a) In your opinion, what is the objective of this problem?(b) Propose an algorithm to solve the problem.11.5(c) Solve the problem using the proposed algorithm.8 913.5 00 00 24.10021.514.110.5 17.311.2008.900 33.200 0000 0011.1001013.8 12.700 8.512.1

Here below I have written the code in C++ along with the code and output screenshot

Julia is a freelance hakers. She receives a few cake orders, for this Saturday. Since quite a number of orders on the same day, so she needs to deliver the cakes in an way. She has studied the distance (in kilometer) to each location, as shown in Ta data shown in upper triangular matrix only. This means that the distance bet locations is same from location a to location b and the other way round. While there is no direct route between two locations. 1 2 3 4 5 6 7 8 Table 1: Distance of the locations 45 6 12 3 5.1 12.5 13.0 7.5 7.2 9.2 8.0 (d) Report the output of the problem. 00 00 00 00 00 00 00:00 00 8.500 15.5 9 10 (a) In your opinion, what is the objective of this problem? (b) Propose an algorithm to solve the problem. 11.5 (c) Solve the problem using the proposed algorithm. 7 8 9 13.5 00 00 24 21.5 14.1 10.5 17.3 11.200 8.9 00 33.2 00 00 11.100 13.8 00 8.5

Julia is a freelance hakers. She receives a few cake orders, for this Saturday. Since quite a number of orders on the same day, so she needs to deliver the cakes in an way. She has studied the distance (in kilometer) to each location, as shown in Ta data shown in upper triangular matrix only. This means that the distance bet locations is same from location a to location b and the other way round. While there is no direct route between two locations. 1 2 3 4 5 6 7 8 Table 1: Distance of the locations 45 6 12 3 5.1 12.5 13.0 7.5 7.2 9.2 8.0 (d) Report the output of the problem. 00 00 00 00 00 00 00:00 00 8.500 15.5 9 10 (a) In your opinion, what is the objective of this problem? (b) Propose an algorithm to solve the problem. 11.5 (c) Solve the problem using the proposed algorithm. 7 8 9 13.5 00 00 24 21.5 14.1 10.5 17.3 11.200 8.9 00 33.2 00 00 11.100 13.8 00 8.5

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Fruvento is going to be used by any client to search for the fruits available in the farm. This search could be done by fruit names or by date. The client can also use the system to order fruits, pay them, and complain if he/she faces any inconvenience. Fruvento is also going to be used by any employee of the farm to assess the complains, list the fruits available, and issue invoices for the clients. When needed, the employee can request quotations from providers and submit orders to obtain specific services related to the management of fruits. Providers, who are going to use Fuvento to offer their services, will check the orders received from the employees of the farm and submit quotations, accordingly. The employee can then pay for the services ordered if he/she gets a convenient quotation. Question: Propose a UML use-case diagram for the process described above.
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…
Let's say there is room in the class for only one more student, but two individuals want to sign up for it nevertheless. Why aren't the two pupils allowed to sit in the one remaining empty seat in the database system?
Please explain A major airline decides it wants to board passengers passed on their priority status. The passengers will board the airplane one at a time in a single file order. The higher the priority passenger rating, the earlier they should board (assume there are no ties). What data structure should this airline use? How long will it take to board N passengers in Big-O? Note: We do not know when the passengers will arrive at the gate, but we will always want to allow the passenger with the highest priority to board first. Group of answer choices a. A priority queue is the best data structure. The priority queue uses a max-heap such that passengers with the highest priority will be at the top of the heap. In order to board N passengers, it will take O(nlog(n) time. N removals for each of the passengers and then log(n) time for each removal to rebuild the max-heap structure. b. A binary search tree is the best data structure. The binary search tree will search for…
In the country of Wakanda, the government have prepared a vaccination plan to vaccinateall citizens. A database is needed to keep track the record of the vaccination to ensure everyone getsfull2 doses of vaccination. Patients’ record such PatientIC, PatientName and Age will be recorded. Every patient will at least need 1 dose of vaccination. There are currently 5 type of vaccines and each vaccine can be used on anyone above 18years old for now. Every patient will be sent an appointment date and time for each dose of vaccination and a doctor will administer the dose and the doctor’s name will also be recorded in the database.However,some doctors in the lists may just be there to help but not administering the vaccine.The vaccine name given to each patient will also be recorded in the database. Many big venues and halls are repurposed as vaccination centreswhere patients will go to get their vaccination. The name and address of the vaccination centrewill also be mentioned in the…
To prove that a database's values are subject to arbitrary alteration, just show that they sometimes do. The use of longitudinal parity in a detection code helps to pinpoint errors. for all bits in the Oth place, another parity bit is computed and saved for all bits in the 1st position, etc.)
You are required to follow the Unix domain server and client example done in the classroom. After this point, you need to setup the server in a way that it will process the data sent by the client and send back the processed data. You must read at least two set of data, and send back at least a piece of information. For instance, client might send two numbers and the server will send the summation back. This is only an example, please do something a little more complicated. I do not want to see same operation over and over again in the assignments. You can use scanf and printf with dup2 to obtain numbers. Alternatively, you could read the text and use sscanf and sprintf. You could also perform text based operations. It is up to you. You must perform all error checks. Submit two C files.
Fruvento is going to be used by any client to search for the fruits available in the farm. This search could be done by fruit names or by date. The client can also use the system to order fruits, pay them, and complain if he/she faces any inconvenience. Fruvento is also going to be used by any employee of the farm to assess the complains, list the fruits available, and issue invoices for the clients. When needed, the employee can request quotations from providers and submit orders to obtain specific services related to the management of fruits. Providers, who are going to use Fuvento to offer their services, will check the orders received from the employees of the farm and submit quotations, accordingly. The employee can then pay for the services ordered if he/she gets a convenient quotation. In order to implement the expected system, the following information have been received from the managers of the farm: A client can make one or more orders (we call them buy-orders). For every…
GoldStar Bank is helping companies to do money transaction for their customers who holds their credit card (GoldStar Bank Credit Card). Please consider the following parameters: The Bank’s has one Data Center where it keeps all customer data transactions. Data Center in a building in NYC. GoldStar Bank has only one building in NYC where all employee computers are connected to each other and the main database via INTRANET. The Bank’s database can be accessed remotely by the companies. Currently, there are five companies accepting the GoldStar Bank Credit Card in their stores. All, these companies are connected to the GoldStar Bank Data center via Wide Area Network (WAN). GoldStar Bank Data center has been proving service to the companies via Wide Area Network (WAN). There are five companies already accepting GoldStar credit card. And, there are located at; Miami FL Needs 2Gbp data speed to reach the GoldStar server in NYC Dallas TX Needs 20Gbp…
For how long does it take to run the database? Even if it's one more thing, I'll do it. A single action may be able to delete a maximum of how many times? It doesn't matter if it's used for a single ad or a series of ads. As a direct result of a single web search?
Let's say there is room in the class for only one more student, but two individuals want to sign up for it nevertheless. Why aren't the two pupils allowed to sit in the one remaining empty seat in the database system?
please answer the two questions under the second image. Also please include how you knew it was the foreign and primary key