Assignment 5 - Cassandra¶ Learning Outcomes¶ In this assignment, you will do the following: · Design Data Model for Cassandra using Chebotko Diagrams · Create Cassandra tables based on data model...

Hello, I have an assignment in the Cassandra NoSQL language. I am simply have to much on my plate to tackle this. I have attached the details in a word doc. Best Regards, Ed


Assignment 5 - Cassandra¶ Learning Outcomes¶ In this assignment, you will do the following: · Design Data Model for Cassandra using Chebotko Diagrams · Create Cassandra tables based on data model designed · Insert sample data of your choice Recommended¶ Watch example of how Chebotko Diagrams are created https://academy.datastax.com/units/logical-chebotko-diagrams Assignment Instructions¶ Your Challenge: Design a data model for a database which stores information about all universities which offer a course in Data Science. Each university has the following information: (Name, Phone, Address) Each course has the following information : (Course Name, ID, Cost, Course Registration Date) Each person has the following information: (Name, Phone, Address) Your data Model should solve the problem of storing data in Cassandra based on these Query requirements 01. Find universities(including university info) near a person 02. Find information about a given university 03. Find people(Only names) interested near a university 04. Find courses whose registration date is in future based on universities found in Query A. 05. Find details about a person found in Query C. Assumptions: Distance(km range) between a university and a person is already available. Hint: Create a field called distance where required. Questions ( 10 marks) 1. Draw Logical Data Model using Chebotko Diagram. 2. cql file that creates the keyspace, tables, types as required (Add 2 rows of any sample data for all the tables created). 3. Note: You can draw the Chebotko Diagram on a paper and upload a picture of it for submission. cql file is just a txt file saved with extension .cql. It should only have the cql queries, so that the grader can run the file directly without requiring any changes. 4. Grading Scheme 5 marks for Chebotko Diagram ( As mentioned above, you have to create data model based on the above 5 query requirements. 1 mark for each of the 5 queries) 5. 5 marks for cql file ( 1 mark each for cql queries matching the data model design) Note: Your assignment must be submitted in the following file types: · Image file (PNG, JPEG) OR Microsoft Word (DOCX) file which has Logical Data Model using Chebotko Diagram · AND · CQL file (text file) that contains Cassandra queries