SWEN432 - Advanced Database Design and Implementation - Engineering Assignment Help

Assignment Task :

1. Overview(SWEN432)

Assume Wellington Tranz Metro has acquired an iPhone application that works as a data recorder for railway vehicles (cars, engines). The application uses mobile data connections to send information to servers in real-time. The information includes measurements such as tie location and speed of the vehicle. They have selected Cassandra as the DBMS to use for this project. Your job is to design a database and advise on its use. You are also required to implement a test database with a substantial part of the sample data provided in the assignment, as a proof of concept. Note. the grouping of test data in simple data tables does not necessarily imply their belonging to the same or different Cassandra COL tables. 
 

2. Application Requirements The application needs a database ax.taining cnta about drivers, railway vehicles. train time table, availability of drivers and vehicles. allocation drivers and vehicles to services, and current position and speed of vehicles.

Assignment Questions
 Question 1. List the read requests the application requires using plain ErWish. 
 

Question 2. List the database write and update requests the application requires using plain English. 
 

Question 3. Consider Cassandra data model mjide"s discussed in lectures and list names of database tables the premieres using plain English. Recall. Cassandra tables strongly depend on requested queries. If there is no queries needing a table. the table should not exist. (Don't invent queries to justify the existence of any tables.) After each table name, Est those queries you identified in your answer to Ouestbn 1 that use the table. 
 

Question 4. Create data model/ using COL 3 statements that suit the requirements. To answer questions, use Cassandra CCM. In your answers. copy your CCM and COL commands. 
 

a. Create a cluster and a keyspace that will satisfy the infrastructure and availability requirements above.
b. Define tables listed in your answer to question 3 above. For the table definitions include any non-default property settings needed to attain better performance. Optimize your database solution just for iPhone application queries and writes you identified in Questions 1 and 2 above, respectively. 
 

Question 5 Provide CQIB statements to support each of the applications write and update requests you specified in Ouestjon 2 above. Show the consistency level before each write and update statement. 
 

Question 6.  Provide COL3 statements to support each of the application read requests you specified in Question 1 above. To answer the query looking for the service to dispatch next assume the current time iS 09:30am (0930). Show the consistency level before each read statement. In your answer copy your COL Statement the result produced by Cassandra from the screen.

This SWEN432: Engineering Assignment has been solved by our Engineering Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.