Database Systems - Week 8

    The three most important thinga about this course are the things we learned about Database planning and designing.  You need to understand what data you will be storing and how often it will be accessed, what type of queries will be used, etc.  

    Data integrity is key when you are having users access, update, and insert data on a regular basis.  Data validation and design are both important to keeping data integrity to make sure invalid data isn't being inserted.  Designing a system to make it as difficult as possible to make mistakes is important.

    Scalability and performance are also very important because many databases handle large amounts of data and the more time it takes to find the data you need, the more money the company is losing.  Being able to grow as the need arises will set yourself up for the future rather than pushing the buck to the future.

    Accessibility and usability need to be on the primary list of things to think about when database planning.  There needs to be ways for users and admins to access the database with relative ease.  It should also be able to provide reporting, whether it be with visualizations or simple analysis reports.  It would also be a good idea to provide access to the device through as many different portals/devices as possible to allow good access to all users.

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