Mike Divine's Learning Journal

Here are five of the things I have learned in this course so far.  One is that databases are very useful for organizing data effeciently as well as finding and formatting data quickly.  Two is that you can join tables together to pull data together and see much more data concurrently.  Three is that you can create temporary tables called Views that you can use to pull pertinent data more easily.  Four is that you can select data from other sub select statements which allows you to do things otherwise unavailable.  Five is that you can alter tables and change them in the future if needed. Here are three of the thing I would like to learn about.  First is I would like to learn about Big Data databases as I have heard a lot of references to them and I am not really sure about how they differ and what they are useful for.  Second is I would like to learn more in depth about how to do complex data pulls as I still struggle sometimes to figure out how to get...

    3rd Normal Form is making sure all the data is stored in a way where updates to a database can be done without having to update data in multiple locations.  This will help so mistakes are not introduced where data is thought to have been updated but then outdated or incorrect information can still be pulled without realizing it.  Creating Primary Keys and Foreign keys which rely on other table's Primary Keys ensures data integrity is kept.  Also, you should not have to store the same data in multiple table except for those keys.     A SQL View is a temporary table that pulls data from the actual live database tables.  It is used only for an existing query and is recreated every time you pull data from the View.  It is very similiar to a table except that the table is actually stored on the server and the View is pulled from the database and then stored into the View on the client side.

I was thinking that joining tables on something other than primary keys and foreign keys would not be something that should exist, but I guess you never know what you would eventually want to use data for.  An example I thought of was having to join tables with populations if the tables weren't related in another way. Join a table countries with population and then a table cities with population.   SELECT ci.Name AS city, c.Name AS country, c.population FROM city ci, country c; SQL language is not that easy to learn.  It is fairly simple to learn the basics but figuring out how to do specifics with large datasets can be very complicated and hard to grasp.  The questions I find most challenging are trying to pull specific data and trying to figure out how to get only that data and format it the way you want.

     This week we learned about how a (DBMS) Database Management System works and how to create tables, insert data, delete data, and pull data using SELECT, DELETE, CREATE, and UPDATE commands.     Databases are different from spreadsheets because the data are stored in tables that are relational and use key values to link to other tables.  Some other differences are that spreadsheets often times have formatted data and it is harder to access and manipulate.  Databases store data without formatting.  Also there are many different ways to access the data and only pull out the data you need within databases.      There are many reasons to store data in a database rather than just in a file system.  You can pull data more easily by querying the database and find data much more quickly.  You can join tables to pull data together and organize it the way you would like.  Databases can also handle a lot of data and access i...

     The most challenging part of Library was trying to test the program as I went because so many methods called other methods.  I ended up writing a majority of the code and then troubleshooting and testing it afterwards which definitely made it tougher.  The easiest part was using the other classes that we had already written.  It was nice to use code in conjunction within a larger program.  I am most proud that I kept putting in the effort needed to eventually make it all work like it is supposed to.  Also I am proud that I was able to keep my code effecient, concise, and formatted clean.       The topics most useful were the HashMap experience as I had not gotten a chance to use that before this class.  I also liked learning about coding designs as I didn't have much experience with that as well.  I am not sure of improvements to the assignments as I thought it went well and I enjoyed it quite a lot.  If I c...

          I worked with Russell Frost when discussing our solutions to the Markov Assignment.  My strategy for solving the Markov Assignment was to look at the UML Diagram and create all my constants, variables, constructors, methods, etc.  Then I would go through and code the easiest methods first.  I would then write the tougher methods while trying to make sure I followed the instructions.  Then I took the MarkovTest Class that Professor Clinkenbeard wrote and I used it to test my Markov Class.  Then as it came back with tests not passing, I would look at any errors I got and started trying to track down the issue until I found it and fixed it.  Then I would run the test again and go to the next issue.  I did this until it worked fully.  Russell's strategy seemed to be similar to mine, just writing code as he went and troubleshooting issues while testing.          I would change my strategy...

My review on Bit by Bit Development's video on Quantum Computing: I thought you guys did a great job on covering the topic and included a lot of pertinent info. I do find the presentation to be clear and the research looked to be decent.  The video production could definitely use some more images, videos, transitions, effect, etc. I didn't find the video to be as engaging since I there are not mich visuals.  Everyone in your group looks to have contributed so that is good to see. My review on Business Geeks Proud's video on Healthcare Robotics: I thought the topic was covered fairly well and had a lot of good info on the subject. The research looked good from my end. You had some effects in the beginning but not much throughout once you went to covering your subject.  The video production being increased would help with better engagement.  Overall, good job. My review on Initech's video on Cybersecurity/Cyberwarfare: I thought the topic was covered well and...