Jennifer Serafino

The most important thing I learned in this class was how to use tools tools such as R and data visualation software like Tableau to be better. I leave this term ‘better’ intentially vauge because I will use these tools to be a better intern at EY for FSO Assurance, a better leader in my organization, Student Center for the Public Trust, a better…[Read more]

In auditing, you need to have people’s full social security numbers at the beginning of the audit. As you get to later stages of the audit, They are listed in form XXX-XX-#### , with only the last four numbers being relevant. If I was trying to convert all social security numbers into the later format to make a compiled list of all subjects across…[Read more]

Street network orientation in major cities

I chose the infographic from FlowingData.com, ‘Street network orientation in major cities’. I thought this told a good story for two reasons. City street layouts are important because they are used in natural disasters and emergencies. It was interesting to see how…[Read more]

For exam one I would like to practice and get tips on ERD diagrams and cardinalities. I find them to be confusing. I would like to develop a process of solving them that I could replicate with every problem statement. While the steps we got in class were helpful, I still get confused on how some entities are related. (Ex: Ratings in the homework problem)

Joins are very useful tools when working with tables. They help you collect data from multiple locations and compile the data into usable information. An example where you might use this would be buying books from Temple’s book store. You could have a table for author names, book titles, and prices. By joining author.booktitles, and…[Read more]

I think the hardest thing about creating an ERD from a problem description is making sure you capture the true intent of the process described. This includes anything from making sure ‘First Name’ and ‘Last Name’ remain separate to making sure attributes are correctly assigned to entities, even if that means they belong to a relationship. The way…[Read more]

Over the summer I was lucky enough to have a great internship with Mitchell and Titus in their audit practice in the Philadelphia office. I was able to see many examples of how raw data could be meaningfully organized into useful information. Many times clients would send records with hundreds of files containing social security numbers, birth…[Read more]