Class Journal Week 8

Andrew Sandler's Class Journal Entry

1. I feel that I do have a better understanding of how the data mentioned in the 5.1 article looks in its stored form.
2. I really don't think any part of this assignment didn't make sense to me. I'm not sure if this answer suffices but really it was pretty easy. There is a lot of online documentation on the different SQL Query commands.
3. I think most of what was more difficult for me was just getting the hang of which Access Ribbon different buttons are under. I felt like the data made intuitive sense. I'm not sure how I would have faired with the primary keys because of the issues the class ran into with the FDA's documentation. The other difficulty I had was just getting my virtual machine connected through lmu to my laptop to use windows.
4. I would definitely like to know more about how to use the tons and tons of data we have to actually organize the data in a way we find really helpful insights rather than just the basics which we had to do just to learn. So I think what I really mean is I am excited to be given a dataset that matters.

Asandle1 (talk)

Charlotte Kaplan

Based on what you have seen of the FDA database, do you feel that you have a better understanding of how the data mentioned in section 5.1 of What is Code?—Spotify music, Fitbit exercise tracking, Twitter tweets, IRS tax returns, etc.—might look when stored on a computer?

Yes, do feel that I have a better understanding of the data mentioned in What is Code. By doing this exercise and looking at how the FDA database stores information, I now see how other companies store their data.

Which part of this assignment made the most sense to you?

The part about loading data into Access and manipulating it using CHAR, VARCHAR, and INTEGER data types made the most sense to me because it seemed more straightforward and easier to follow compared to the other aspects of the assignment. The instructions for this part were clearer, and working with text and numerical data seemed more manageable for someone who is unfamiliar with databases.

Which part of this assignment do you feel least confident about?

The part of this assignment that I felt least confident about is creating the relationships between the tables in order to construct the queries. It took me a couple of hours to figure out how to establish these relationships properly, as the program was difficult to manipulate. Despite the initial difficulty, I eventually managed to grasp the concept and proceed with constructing the SQL queries. However, the process was challenging and required a significant amount of time and effort.