We aren't endorsed by this University

33 Pages

22 Pages
###### ITDA1001 Database Fundamentals

**Course**
**Type**
**Subject**
**University**

Question: Read the entire assignment before you start working on the assignment.A complete report is expected to get full marks. Description: In this assignment, students will experiment with dat ...

ITDA1001

Programming

Database

Victorian Institute of technology

18 Pages
###### ISY1002- Database Management for Business

**Course**
**Type**
**Subject**
**University**

Aim To give you practical experience in database modelling, normalization and writing SQL statements to query a relational database Part A: Entity Relationship Diagram 1. Your first task is t ...

ISY1002

Programming

Database

Australian Institute of Higher Education

19 Pages
###### BN204 Database Technologies

**Course**
**Type**
**Subject**
**University**
**Season**

Questions: Database Design The School of Information Technology & Engineering (SITE) would like to help its Master of Networking students with placement in various companies and firms. To faci ...

Bn204

Programming

Database

Melbourne Institute of Technology

Spring

5 Pages
###### COMP2750 Applications Modelling and Development

Task 1: SDLC Q1) Explain how this project would be carried out in traditional SDLC vs Agile Methodology. You are allowed to make any assumptions you wish about the scope of the project. Please e ...

Answered

"Ticket to Ride" C Programming Introduction Ticket to Ride is a popular board game that involves connecting cities in a given railroad network. In this assignment you will prototype some potential approaches for creating an AI player for this game (since the AI players for the computerised version are currently terrible!) The basic gameplay of Ticket to Ride requires players to fulfill "tickets" that are randomly selected. A ticket consists of two cities that need to be connected. Adjacent cities are connected by placing the required number of train tokens on the track. While there are other complications in the full game, the basis of a good strategy is to fulfill your tickets using the least number of train tokens - this in turn allows you to fulfill more tickets with the fixed number of train tokens available. Data Structures and Input We will represent the map using the following data structures, as used in tutorials. (Please note that you need to use the same struct below)

Graph; In this case, the vertices represent the cities on the map, and the edge weight will be the number of train tokens required to connect adjacent cities. We will also use the same redirected input method used in tutorials to create the graph. To build the Graph: - Add a file called main.c with a main function and #include the graph definitions - Declare a variable called G in the main function that is a Graph - Add a file called input.txt to resources and copy the above text into the file. Modify the project properties to redirect input from this file - Add code to scanf the first number and store it in G, and initialise the edge list array of G - Now add a for loop that loops through each vertex and: + scans the number of edges from the vertex + initialises the edge list for the vertex to NULL (NOTE: You could wrap this code up in a new_graph function for the graph data structure)

However, the graph in this case is undirected, so two edges need to be added for each pair of adjacent cities. i.e. if cities 2 and 7 are adjacent, an edge needs to be added from vertex 2 to 7 and from vertex 7 to 2. The graph input will include only edges from cities with a lower index to cities with a higher index, but you must also add the edges in the other direction. The graph input will then be followed by input for a given number of tickets. For example, the following input will create a graph of 7 cities, with 2 tickets from cities 2 to 4 and 0 to 1: 7 2 6,4 3,3 2 4,4 2,1 2 5,2 3,3 2 6,2 4,5 1 6,3 0 0 2 2,4 0,1 (same format for ouput because i need to test this function using different vertex and edge so it need to be random, not specified) Testing: We could just print the graph somehow to check if it is correct, but this is messy.

Instead we will calculate the in-degrees of all vertices and print those instead. - Add some code to initialise an array of in-degrees and set them all to 0 - Add some code to loop through all of the edges in the graph and increment the in-degree for the to-vertex of each edge - Add some code to print the in-degrees and check that you got the right answer - Finally, if you have time, add code to free all dynamically allocated memory Part A The problem of finding the cheapest way to fulfill tickets is obviously related to the minimal spanning tree problem. So part A is a warm-up exercise where you will implement Prim's MST algorithm.

The following high-level pseudocode should be followed: Prim's Minimal Spanning Tree (from Wikipedia) Associate with each vertex v of the graph a number C[v] (the cheapest cost of a connection to v) and an edge E[v] (the edge providing that cheapest connection). To initialize these values, set all values of C[v] to +? (or to any number larger than the maximum edge weight) and set each E[v] to a special flag value indicating that there is no edge connecting v to earlier vertices. Initialize an empty forest F and a set Q of vertices that have not yet been included in F (initially, all vertices). Repeat the following steps until Q is empty:

Find and remove a vertex v from Q having the minimum possible value of C[v] Add v to F and, if E[v] is not the special flag value, also add E[v] to F Loop over the edges vw connecting v to other vertices w. For each such edge, if w still belongs to Q and vw has smaller weight than C[w], perform the following steps: Set C[w] to the cost of edge vw Set E[w] to point to edge vw Return F Your implementation must follow the above pseudocode and use the following C function prototype: Graph prims_mst(Graph *self); The following assumptions and hints will be useful. Hints In the pseudocode F will be a Graph data structure Since you know that the graph is connected, you may start by initialising F in step 2 as a graph containing all vertices (but no edges). This means that you can skip the part "Add v to F" in step 3b, you will only need to add the edge E[v] to F You can combine the C[v] and E[v] lists by using an array of Edges Q can also be implemented as a membership array (i.e. array representation of a set) You can use a simple search for step 3a. You do not need to use any of the more sophisticated heap-based approaches. For part A, you can ignore the tickets. You just need to return the MST for the given fully connected graph.

Having returned the graph, you should print all of the edges that have been added and the total cost of the MST. Part B You will now write an algorithm to find the cheapest way to fulfill your tickets. This is not a trivial task. For example, a naive solution might be to find the shortest path for each ticket and then add all of the paths together. However, for certain tickets, this may be very wasteful, as illustrated below. In this case the top map shows the shortest paths for tickets A and B. The bottom map shows one way that these tickets can be fulfilled more efficiently. So, the ticket fulfillment problem is related to the MST problem and also to the Steiner tree problem of finding an MST for a subset of the vertices in the graph. While there are many polynomial time algorithms for MST, there are suprisingly no known efficient algorithms for the Steiner tree problem - it is an NP-hard problem. Like the Steiner tree problem, I suspect that the problem of finding the most efficient way to fulfill tickets is also NP-hard. Luckily, I do not expect you to find an exact solution. Your task is to find a good approximate solution.

Some of the approaches for finding an approximate solution to the Steiner tree problem, may suggest approaches that you can use here. Any solution that finds a set of edges to fulfill all your tickets (including a correct combination of shortest paths) will receive an HD grade for this part of the assessment. However, to get full marks for this part you will need to find a good approximation of the optimal set of edges. One example of a solution that would get full marks is as follows. Find an approximate solution to the Steiner tree problem of finding the minimal spanning tree for the subset of vertices that are destinations in any of your tickets Remove any edges that are not required to fulfill any ticket. This solution would get full marks, but I am sure that you can do better! The output for Part B should be the edges that were added and the total cost.

Solved by qualified expert

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Q

We aren't endorsed by this University

**Question:
Read the entire assignment before you start working on the assignment.A complete report is expected to get full marks.
Description:
In this assignment, students will experiment with database indexing and generate a report based on their findings. Each assignment must be unique to each ...**

Q

We aren't endorsed by this University

**Aim
To give you practical experience in database modelling, normalization and writing SQL statements to query a relational database
Part A: Entity Relationship Diagram
1. Your first task is to study the Case study requirements and gather as much knowledge to list all the main Entities and a ...**

Q

We aren't endorsed by this University

**Questions:
Database Design
The School of Information Technology & Engineering (SITE) would like to help its Master of Networking students with placement in various companies and firms. To facilitate this, they need to design a database with the primary purpose of scheduling interviews and fa ...**

Q

We aren't endorsed by this University

**Task 1: SDLC Q1) Explain how this project would be carried out in traditional SDLC vs Agile Methodology. You are allowed to make any assumptions you wish about the scope of the project. Please ensure you have referenced the sources and cited them in your report.
Task 2: Requiremen ...**

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.io then please raise the content removal request.

Payment required!

Only one step away from your solution of order no.