Assignment 4 -- Write A Stored Program (Part 2 of 6)
In this assignment I want you to write one or more stored programs to support the transactions related to importing data from external Social Media data feeds used to load your relational User Profile database
What you will be loading is listed below in the Hybrid part of the assignment
This is once again a group effort, so a good way to break up the work is to consider the needed functionality and divide the work and use each other to validate the functionality (as testers)

Consider the trade-offs between one monolithic loader program and a load by state process where the information is processed through multiple programs. Remember, the data is, by definition, "Not Clean", some information is missing, some cannot be loaded

At a minimum, your stored program should be able to take data from a file following a key value store format and load it into your database

It must be able to handle missing data (limited use of NOT NULL) fields
Hybrid Class Assignment - Putting You In Position For What Comes Next
In this assignment you will create a sample data feed file
Create a sample data feed file from the fictitious social media platform -- Best Environment for Natural Discussion On Virtually Every Rant or BENDOVER

In addition to the identification of an individual (keep in mind this may not be a key) your program may need to figure it out

The data feed should include space for view point data for the individual that would support positions for:
  1. Political affiliation and political intensity
  2. Religious affiliation and religious intensity
  3. Social issue views and view intensity
  4. Social mate preference
  5. Gender -- Do not make a selection for Binary gender. You should include F, M, I, TF, TM and NB at a minimum
It should also include a few more data points. Take a look at lab 5 for help on ideas
Run your stored programs on your data feed file and prove that it can load the data into your database schema
Assignment Submission Criteria
To turn in this assignment you will go to the NSC Canvas shell for this class. Submit:
  1. A list of your programs, what type they are and Pseudo code on what they are supposed to do. This can be worth up to 70% of the score for this part depending on how good of a job you do.
  2. The code for your programs -- in a MySQL Workbench schema. They should work or tell me they do not work in advance. I can and will deduct points if you send me something that does not work figuring you can slip it by me
  3. A copy of your sample data feed -- it should conform to a common format .cdf or .csv

    **NOTE**If you use XML or JSON, write me a program so I can view the data


Return to Assignment Index