Database Systems - Week 3

    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.

Comments

Post a Comment

Popular posts from this blog

Learning Journal Final Entry...

     Well, this is the toughest journal entry I've had to write so far as I am excited to be moving forward but sad to finish this journey I have been on for so many years. I am 39 years old and have wanted to be a Software Developer since I was a kid. I had big plans while attending Jr College but life had a different plan in mind where I started a family at the age of 19 and I decided to put my goals of software development on hold. 17 years later, I was married to my wife raising 3 children, and working at the High School I graduated from while also coaching Football and Wrestling. I loved what I was doing but I felt like I missed out on my goals.      Covid hit and everything shut down. No more coaching and most of my job duties were diminished. It was at that time that I decided I would go back and finish my degree and make my career in Software Development a priority. Now here I am 4 years later and I'm finally finishing what I started out to do. I fi...
Read more

Software Engineering - Week 8

This is the final week of my Software Engineering class and I thoroughly enjoyed working on the projects I was presented with.  The five most important things I learned in the class are Selenium automated testing, Spring Boot Framework, Authentication, Stories and Epics, and React. I chose these because they have the most real-world applications and interest me. I have seen these things listed in job descriptions and knew they were used in many applications. Using Selenium to automate testing is a nice skill to have as it allows you to automate web browser interactions, making it easier to test web applications and have repeatable tests when updates are released. Spring Boot framework allows you to build web applications more quickly and with less code and is fairly simple to implement. Learning Authentication using JWT (JSON Web Tokens) is a very good skill because so many web applications use authentication. Learning about the Agile methodology and how it works with epics and sto...
Read more

Computer Networks - Week 8

This is the final week of my computer networking class, and it's been a journey of learning and discovery. This week, we focused on some security implementation, learning about firewalls and intrusion detection systems. I learned about the fundamentals of firewalls, which act as a protective barrier between internal networks and the outside world. Firewalls help with filtering network traffic and preventing unauthorized access. We also learned about intrusion detection systems (IDS), which are designed to detect and respond to potential threats or attacks within a network.  At the link layer, we focused on wireless security, recognizing the importance of protecting wireless networks from unauthorized access. I learned about encryption methods, authentication mechanisms, and best practices for securing wireless networks. Lastly, we have been working on finishing our team project and it has been a great learning experience.  This class has been an enlightening experience learnin...
Read more