#CST363 CSUMB ComputerScience

[dancsjournal]

Week 4 of Databases

Here is my most interesting question, from week 3 problem number #10: -- 10. how many different native countries are found in the data set? select count(distinct native_country) from census; --> 42 I thought this was the most interesting question as it showed me how to use the select count function as well as the distinct qualifier. It was really cool Derek. Please give good grade

[dancsjournal]

Week 1 of Databases

I thought that the best way to create these blog posts would be to use the platform which blog posts really took off in popularity: tumblr! Which is why you are here and where I will be putting all of my other blog posts for this class! 

To start off this journal, here are the answers to the questions asked for this journal:

What makes a relational database relational? (i.e. what is difference between relational and a non-relational database)

In my own opinion, a relational database is relational because it’s indices are kept separate from the data, which helps keep all of the information in the database organized in a specific way. The data is also broken up and stored in such a way that each row/entry has its data stored in different columns, so that you can specifically search by a column identifier and then a key in a row.

A relational database is far more structured and organized than a non-relational database.

Is SQL the same thing as a relational database?

According to what I’ve read, SQL is not considered a relational database, but it is a programming language used by many different relational databases. Basically, SQL is a language and not a database.

Can’t wait to continue this class! This will be extremely exciting!