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.

What would you like to know more about?

I would like to learn more about database design, query optimization techniques, and database management tools to improve the efficiency of creating relationships between tables and constructing queries.

Ckapla12 (talk) 19:26, 13 March 2024 (PDT)

Dean Symonds

1. Yes, I do believe I have a better understanding of how the article mentions the data in section 5.1. Now that I have worked with a relational database, even though it was a rather simple one, I do believe I understand what it may look like more, and I can only imagine how extensive such databases must be for something such as Spotify because of all of the tables that the music must require, such as the artists, record company, release date, etc.
2. The part of the assignment that made the most sense to me is importing the tables and establishing the parameters for each variable, and establishing the relationships. If felt like something that could be repeated relatively easily and something that formed a rhythm after awhile.
3. I feel the least confident about running queries to find certain things on the database. Because it required different syntax for each one, which many times was difficult to figure out what it must need, and it did not feel like there was a common pattern to be applied to all of the queries.
4. I would like to know more about how these databases are used in my daily life, I am aware of how these databases exist in my daily life, through student Identification, song titles or IDs, but I am curious to know more about what it would mean if these databases did not exist in my daily life and how it would make it more difficult.

Msymond1 (talk) 19:56, 13 March 2024 (PDT)