CST 363 Week 1 Learning Journal

-

Part 1: Relational Database Table and Spreadsheet

Spreadsheets and relational databases allow the user to manage data in different ways. A spreadsheet provides easy access to data in cells and allows the user to manage information in a table. The user can easily add, delete, update, and sort rows and columns of information regardless of how the information is connected. Changes can be made directly in the cell, and the user can see all information. Information does not need to be a certain type unless a formula is applied to a certain cell. 

Relational Databases hold their information in tables that the user does not have access to unless certain queries are called to access and manage the information. Queries involve the use of keywords such as "SELECT," "DELETE," and  "INSERT." Data in relational databases have a more secure way of managing data as there are certain rules that need to be followed so that information can be updated. In relational databases, we also need to assign data types to each piece of information in the table before adding data. Once that is complete, only data of that data type can be entered into rows. 

Part 2: Why Databases Are Useful Investments

Databases are a useful investment because they allow the user to follow certain rules when managing the data. These rules add security to the database, which prevents other programs from accessing the data. This is a very important aspect of databases, especially when using them for transactions and currency. Using databases also helps keep your data organized and easy to manage. 

Part 3: Expected Learning Outcomes from CST 363

After finishing CST 363, I hope to create my own database and implement it as an app using Android Studio. Right now, I feel a bit comfortable using INSERT and DELETE, but I hope to get more practice with UPDATE. I also hope to know what features can be implemented to make the data even more secure so I can create my own app. 

Comments

Post a Comment

Popular posts from this blog

CST 300 - Week 8

-
 Part 1: Review of other team's final video projects Final Video Project Review # 1: Otter This World The video project from Otter This World is about Genomics. They describe how genomics is important and what advances we have made in this area. The topic is well-covered, and the presentation is clear. They cover each section described at the beginning of the video and provide various videos that go along with those sections. The quality of the research and video project is well done. They provide definitions and statistics with references. The video has a lot of visuals and could have used some slides with text at the beginning of each section. The information is being provided via audio, and there should be some text to supplement it. Also, the General Public video cuts off at the end with no conclusion. The video is engaging and interesting. They made a nice choice of visuals for each section. Team work is evident as each person had a section they covered. Overall, the video is
Read more

CST 300 - Week 5

-
Image
Part 1: Support and Comments on Teammates' Goals Victoria's Comment Guillermo's Comment Part 2: Possible Capstone Ideas Some ideas for capstone that I have are in the area of education with a focus on classroom management and video game design.  My first idea is to create a seating chart generator app for teachers to use in their classrooms. As a teacher, creating a seating chart can be a challenge. Whether you have a challenging class or are just looking to mix seats up, this app will help create the perfect seating chart. The app will give the teacher a variety of options to create a seating chart: individual, partner, or grouping (3 or more). The teacher can create a seating chart or groupings based on current grade in class, on an assignment, IEP requirements, or behavioral issues.  My second idea is to create a school environment application or website. With technology in the classroom becoming more and more popular, students are having to manage their own apps, homewo
Read more

CST 300 - Week 4

-
Image
 Part 1: Educational Goals My primary educational goal in the CS program is to graduate with my Bachelor's in Computer Science in December 2025 with experience in the field from internships and our service learning class. Another goal I have by the end of the program is to create projects that will showcase my experience and skill set and have them on display on my GitHub. Furthermore , my secondary goal is to graduate with my Master's degree  with a focus on Artificial Intelligence or Computer and Network Security.  from Stanford University in December 2027.  Part 2: Career Goals My career goal is to work in the field of computer science as a backend developer in cybersecurity or software development once I graduate from the CS Online program or the Computer Science Master's Degree program at Stanford University. I want to work with a company that strives to create products that will improve the quality of life while keeping user's data safe and secure.  Part 3: Percen
Read more