CST 363 - Module 4

 Now we are half way through the course, and there is quite a few things that I have learned so far. For starters, I have learned a lot about how to use MySQL, using all the basics, using different methods of joining tables, creating views, and subqueiries. I also learned a good bit about normal form, an example being the third normal form, where all non-key columns must depend on the key, the whole key, and nothing but the key. So if a table has a key of one column, all non-key columns must depend on it, or if there are multiple columns in a key, then all non-columns must depend on all of those key columns(not part of it). As well as non-key columns must only depend on key columns, and not other columns. I also learned more about entity relationships. Whether the relationship is weak or strong, and if it is one-many, one-one, or many-many.

However, there are still things I am confused about. I can put the pieces together with normalization, however, when viewing tables it still takes some time for me to see if it is in a specific normal form. I also need to learn more about b+ tree's and how to use them. I also need to learn more about storage in general as it would be crucial for large databases. Though I'm sure I will gain a better understanding of this as time goes on.

Comments

Post a Comment

Popular posts from this blog

CST 300 - Module 4

Part 1 - Educational Goals This week's lecture readings in class have to do with setting goals. There are a few different types of goals to consider such as career, financial, family, artistic, attitude, physical, and public service. However, for now let's go over my educational goals. Some things I would particularly like to learn more about are software design and software engineering. I want to be able to create more professional applications to be an important member of any team I may join in the work field. To be more general, I would like to pass all of my classes with a grade higher than a C as I think they all are useful to know, especially for some of the things I want to do in the far future. Part 2 - Career Goals Another type of goal I should talk about is my career goal. Overall, I would like to have enough experience in working with the game development industry. There are a few levels to this goal, one is I would like to work with a company that develops games suc
Read more

CST 300 - Module 2

Image
Part 1 - Review and Reflect Learning Strategy After reading a paper on effective study skills by Dr. Bob Kizlik, I have come to realize there are more aspects of studying than I realized, and I do follow a large amount of them. However, there are also some aspects in which I struggle with that I have noticed, especially recently when it comes to reading. Although, to save your time, I will talk about the top 3 aspects I believe I am good at, and the top 3 I am bad at. One thing I am good at is taking notes. Especially in the digital age we are in, there are many ways to take notes, for me I separate my notes by module and assignment using google docs. Another is getting the main idea in a reading, also allowing me to take notes to reflect on later, instead of re-reading an entire segment of an essay or book. Finally, I feel I am also adept at surveying, to get an idea of what I'm going to study, before I actually study. However, some things I need to work on is to actually read bec
Read more

CST 300 - Module 3

Hello Everyone, Part 1 Last week I mentioned the areas in studying I need to work on such as paying attention to what I am reading, and to stick to a schedule as I often lose focus and prolong assignments. So, after visiting AcademicTips.org, I took some notes on concentration. Some things I am trying to do differently is to further avoid any distractions and to keep focus on my studies by taking breaks less often but do something that needs to be done other than just daydreaming, such as using the time to eat. Part 2 This week’s class module covered quite a bit of material. The readings covered topics such as the Code of Integrity for CSUMB CS Online, going over the rules of what should and should not be done when submitting any work or assisting/receiving assistance. Code of Ethics, as one may expect, be honest, avoid harm, maintain high standards, be professional, and many more aspects of what it is to be ethical in one’s work. This module puts an emphasis on ethics as it is the ma
Read more