Programing project MySQL, JavaScript JSON, and REST


OverviewFor this assignment, you will be selecting an online JSON data source, create a database model that will hold the data, and import the JSON data into MySQL. In addition to the tables, you will also create SQL Views, and use the views in your REST read queries. You will also create a stored procedure.AssignmentStep 1: Identify JSON Data SourceReddit contains a large number of categorized topics. Find a topic of interest by navigating to the reddit website Links to an external site., enter a topic of interest, and search for a reddit in the search results Communities and Users section. You will need to find a reddit with at least 20 postings, so select a reddit with a large number of subscribers.Each reddit URL consists of the reddit domain name, followed by an r, then the name of the reddit. For example, for the cyber security reddit: Links to an external site.. The “r” indicates that the reddit is a community.Every reddit community includes a JSON version of the postings. To view the JSON version, remove the trailing slash, and append .json. The cyber security reddit becomes: Links to an external site.. The display of the JSON data will depend upon the browser you are using. Some browsers will help with JSON formatting.Important: The JSON data appears to only be available for communities, and not individual posts or even a list of communities about a specific topic.You will need to extract the raw JSON data, and save the data to a file called cit381-assign07-reddit.json.Tip: If your browser does not help present the JSON data to help you understand the JSON structure, you should find an online tool or application to help with the JSON data structure visualization (e.g. JSON Editor Online Links to an external site.). By default Chrome didn’t appear to help, but Firefox created a navigable JSON layout.Step 2: Create a model to hold your JSON dataYou will need to design a database to store some of the reddit information. Analyze the JSON, and determine what tables you will need, and the primary keys for each table. You must store enough information to provide most of the information visible for a “Listing” reddit posting. You will need to look at the reddit in your browser, and find the information in the JSON, to better understand the data.Hint: Look for the children array property.The required data items are:Title of postingAuthor name that could be used to find the author (analyze the posting to determine which property is used to lookup a user)Date/time of posting (stored as UNIX epoch, use Epoch Converter Links to an external convert epoch to human readable date/time)Actual reddit linkAny links to an external or original articleNumber of commentsNumber of cross postsLink to comments (analyze the posting to determine what property contains the comment link)Note: Include the comments table in your schema, but don’t worry about populating this table. Only individual reddit posting contain links to comments, so will not be parsing out this data.You will also need to store user names in a user table, and relate the user table to the posting table.Save your database model as cit381-assign07-schema.sql. Export an image of your schema as a png file and save as cit381-assign07-schema.png.Step 3: Manually enter a few rows of JSON data into MySQLYou will need to eventually load at least 10 rows of your reddit JSON into your database tables, but for now, manually enter in a couple of entries.Export the manually entered data from all of the tables using the Export recordset to an external file button above the results in the Result Grid. You will need to export each table as a csv file, then combine all of the data into a single file called cit381-assign07-data.csv.Step 4: Create SQL ViewCreate one meaningful view for your data. Do not simply create a select statement that returns all columns from one table: you MUST use a join, and include a computed field, such as the age of the posting.Save the SQL to create the view in a file called cit381-assign07-view.sql.Step 5: Create stored proceduresCreate the following two stored procedures without using a view, only base tables:The first stored procedure inserts user names and any other user information you can find into the user table.The second stored procedure inserts data into the posting table and must include a user name value in addition to all of the data required by the posting table.Save the SQL to create both stored procedures in a file called cit381-assign07-procedures.sql.DeliverablesYou will need to collect all of the files for this assignment, and create a single compressed/ZIP folder called that contains all six files. Upload this single file to Canvas.Below is the list of files that are required for this assignment.(5) cit381-assign07-reddit.json(15) cit381-assign07-schema.sql(5) cit381-assign07-schema.png(5) cit381-assign07-data.csv(5) cit381-assign07-view.sql(10) cit381-assign07-procedures.sql

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.