The main objective of this assignment is to create several…

  

The main objective of this assignment is to create several… The main objective of this assignment is to create several endpoints that can be used in other applications to perform CRUD operations on a dataset revolving about space exploration. 1. Set up a table in your database that according to the following schema:id name distance description discoverydate Pick appropriate types for each column. The id of every record should be created automatically. The name represents the name of the celestial object. The distance should represent the object’s distance from earth in astronomical units (AUs). The description can be a paragraph of text. The discoverydate represents the date the celestial object was discovered.Fill your table with at least 5 records. 2. Create the following 4 REST API service endpoints to perform CRUD operations:1) /api/addcelestialobject: This endpoint should allow to add a new celestial object to the table. The data for the record should be sent asa JSON object in the request payload. 2) /api/deletecelestialobject: This endpoint should delete a celestial object based on the id provided. This endpoint should be secured by a token with the value: “880e0d76” 3) /api/getfurthestcelestialobject: This endpoint returns the object that’s furthest from earth with all its properties as a JSON object 4) /api/getmostrecentthree: This endpoint returns the three most recently discovered celestial objects and their corresponding attributes in JSON format.  This exam requires you to have a remote MySQL database (local DB setups will not be accepted) It is recommended that you use MySQL Workbench for creating the table and adding the 5 initial records. But you can use any tool that you are comfortable with. You do not have to submit any SQL code that fills the table.   Computer Science Engineering & Technology Python Programming CIS 3368

Don't use plagiarized sources. Get Your Custom Essay on
The main objective of this assignment is to create several…
Just from $13/Page
Order Essay
  

Leave a Reply

Your email address will not be published.

Related Post

Question 2 [36 Marks] The diagram below shows a system for automatic control of pressure. y(t) is the displacement, where y=0 corresponds to the…Question 2 [36 Marks] The diagram below shows a system for automatic control of pressure. y(t) is the displacement, where y=0 corresponds to the…

  Question 2 [36 Marks] The diagram below shows a system for automatic control of pressure. y(t) is the displacement, where y=0 corresponds to the initial equilibrium position due to a given constant pressureThe

READ MOREREAD MORE
Open chat
💬 Need help?
Hello 👋
Can we help you?