CST 363 - Module 3

 Week 3!

One thing that is considered important in database engineering is the normalization rule which reduces redundancy in tables. Focusing on the third normalization rule (the combination of the first two rules plus a third rule), Edgar Codd, considered as the father of relational databases, once described the third normalization rule as "a non-key column depends on the key, the whole key and nothing but the key, so help me Codd." where the key means primary or other candidate key of a table, whole key referring to a key containing multiple columns, including them all not just some columns of the key. Essentially, what is being said is the fact that non-key columns must depend on or are related to the key to each row. If it is not related to a key, then the database is not in normal form. This is important because it maintains the integrity of data, preventing redundancy or repetition and makes the data consistent.

One thing we used recently in MySQL a view which is essentially a name query. It is useful for reusing queries, especially if it is complex. It is similar to a table in the way that it is essentially a virtual table. However, it is different because it does not store information like a table would, it is the query itself.

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