Week 17

-

 The first week of my third class, Intro to Database Systems, is about wrapping up. Due to complications and what not my previous weeks may not add up to week 17 but this is officially my 17th week.


Relational database tables and spreadsheets look similar, with both having rows and columns.  What are some important differences between the two?

Database Tables are designed with relationships between tables like foreign keys. Referential integrity and avoids redundancy through nomalization. Spreadsheets have no enforced relationships and has a lot of redundant data. Databases also have constraints like not null and check preventing invalid data. 


Installing and configuring a database and learning how to use it is more complicated than just reading and writing data to a file.  What are some important reasons that make a database a useful investment of time? 

Databases are important to learn because they have enforced rules and no duplicates. Ensuring there are no manual errors. Databases are also great for performance at scale, speed, concurrency, and optimization are all things that databases excel at. They are also very secure.

What do you want to learn in this course that you think will be useful in your future career? 

I would just like to get a great understanding of Databases as a whole on the theoretical and practical level. So many times in my undergrad, I've heard of the importance of learning SQL. So I'm glad to finally get around to it. 

Comments

Post a Comment

Popular posts from this blog

Week 1

-
 I'm excited to begin my first official week at CSUMB CS online! I started off the first week by going over the lecture. I learned about how we will be utilizing APA format, different sources and what is expected of us, paraphrasing, and plagiarism. I will do my best throughout the year and I believe I'm off to a great start. This Thursday I will thoroughly review the writing lab and begin. Let's have a great first week.
Read more

Week 4

-
Set Your Educational Goals      I have several educational goals. The first one is a strong understanding of core computer science concepts such as data structures and algorithms, operating systems, databases, and computer networks. A deep understanding of advanced math such as calculus, discrete math, and linear algebra will also help. With a clear emphasis on getting better at programming, that will be beneficial. I also want to have an internship and more personal projects. I then want to specialize in an area of computer science, maybe artificial intelligence as that's what I wrote for my paper but it's still up in the air. I want to be good at communicating, teamwork, and problem-solving. Set Your Career Goals      Short term wise I want to land a role in my specific interest. Whether it be software development, data science/AI, cybersecurity, or other fields. Then build technical depth and gain industry experience. I can then network with others to fu...
Read more

Week 2

-
Image
Part 1:      The first thing I'm good at is schedules, I agree there is a ton of value to schedules and they save an immense amount of time. Figuring out what days and hours I have available to do what work also relieves stress on my mind because I know I will figure out those problems when my availability is open to do so. One thing I'm not good at is not storing my notes in a good place. I'm scatterbrained in that sense so according to this effective study skills document I should try and consolidate my notes for better retention of information. The second thing I'm good at is answering easy questions first, as soon as I'm stumped I skip past it to let my subconscious handle it and get on an easier problem. Another thing I'm bad at is reading multiple-choice questions, I have a bad habit of rushing so I need to take some time to read the questions multiple times to make sure I understand what is being asked. I do have a good study space, that is quiet and comf...
Read more