Database Systems: Week 3

-

 1. An SQL view is based on a stored query. It shows what the query has saved and it is similar to a table. The similarities they have are the structures of columns, and they can be queried in similar ways. The differences they have is that a table cannot store data, and there are no indexes which in result means there are no primary keys. Having no indexes can also affect the performance especially when doing operations like insert, update, and delete.

2. The features that are similar to Java and SQL and the one I noticed right away from starting this class is the if statements being similar to the where clauses. SQL has been a bit easier for me to code and it has been enjoyable to acknowledge all the similarities that SQL and other programming languages have. There are also many functions that are similar as well as how we comment a line. A difference between SQL and Java is how they control the data. Java manages files and SQL manages data in relational databases. Another difference is how they handle errors. Java handles them by doing a try-catch method and SQL uses exception blocks.

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