Intro to Database Systems: Week 1

-

1. Relational database tables and spreadsheets are similar but also have differences. Spreadsheet data is stored in a single sheet with no relationships between the different sheets. The relationships have to be inferred or created manually. In contrast, data in relational database tables is stored in tables that can be linked through relationships with each other. In these tables, there are primary keys and foreign keys.

2. Some important reasons that make a database a useful investment of time are the integrity of the data and consistency as well as the performance of the data. It is important to maintain the integrity of the data by using the primary keys to help prevent any duplicates and also by using foreign keys to ensure the consistency of the data. This helps us make fewer errors when dealing with the database. The performance can also be a useful investment because there are several times there is a large amount of data in a database and the databases are designed for that large amount to work with data efficiently. 

3. Learning just from the orientation, I learned how important databases can be especially for a large application or system. I have heard the terms data and database, but I haven’t gotten into depth with them. Therefore, it will be very useful to learn everything in this class to higher my knowledge in databases and how to correctly use them. Database is essential when getting a degree in computer science because it is fundamental to what we work in. 

Comments

Post a Comment

Popular posts from this blog

My first week

-
I am excited and eager to have started this journey with an amazing cohort and faculty!  The material I reviewed included tips to help me be successful in our online program and the syllabus. D uring module 0, I made a weekly study schedule, and it was my first time making one. It was very interesting and helpful to use. I enjoyed interacting with my cohort and getting familiar with everyone during our discussion. Besides that, my wonderful teammates and I started working on our assignment early which included having a team name and making a collective resume as if we had a business. I suggested a few team names and my teammates agreed on Code Busters. We managed to work together to make our resume and the only thing we could have left out was AI. Our business consists of helping our customers debug their systems. (Our collective resume is included below.) Now continuing to Module 1 my team and I started off the week right by finishing our assignment the day we received it. We rev...
Read more

Second Week

-
Here are the following parts of this week's learning journal assignment. Part 1:  The three things I am good at are asking questions, taking notes, and gathering my materials. When looking over material or doing assignments, I always have questions, and I try to figure them out to understand what I am doing. In the SQ3R method, questions are great for learning because it covers the why, what, how, who, where, and when. I also enjoy implementing note taking. I have a notebook for my CST 300 class, and I also use my notes on my computer to make sure I get everything done. Taking notes helps memorize what you are writing. I am also good at having my materials on my desk where I study. I keep everything together so it’s easily accessible. The three things that I need to work on more are time management, where I study, and having a correct schedule that works for me. I always struggled with time management, and I felt it this week because I did several assignments on the day it was due....
Read more

Fourth Week

-
 Part 1: One educational goal of mine is to receive As and Bs throughout my journey in this program. This aligns with my second educational goal, getting a 180 out of 200 on my Ethics Argument Essay in my CST 300 class. I want to accomplish this goal by getting help from others. During this class, I received an 84 out of 100 on my Industry Analysis essay. I wasn’t too far out but the Ethics argument essay will be difficult. My last educational goal is to get ahead of my assignments by managing my time. I am always busy studying, working, being with my family, and trying to leave time for myself. I spend over twenty hours trying to figure out or perfect assignments and reviewing them in the Modules. Part 2: My career goal that I can work on is making projects to start my portfolio. Starting this can help recruiters and myself to acknowledge the progress I will be making. Considering I will have more knowledge by the end of this program. I also want to learn new program languages and...
Read more