CST 363: Week 4

 Briefly summarize 5 things what you have learned in the course so far.  

  1. SQL utilizes various constraint keywords to ensure the values within a database are following rules that best suit the desired functionality and utility of the database. These constraints can dictate if a value is a reference to another value, whether or not NULL can be placed into a cell, and more. It's similar to how conditional statements can be implemented in Java to conduct user input validation. 
  2. Database tables can be structured for maintaining data integrity and reducing redundancy through normalization. Through this process, a table may go through one or more stages called normal forms that establish rules on the table requiring rows to be moved to other tables or removed all together. 
  3. SQL allows tables to be joined together using related columns. These related columns can be joined with the keyword 'using' if they have the same column name or the 'on' keyword if the columns have different names. There are various types of joins, like inner or outer, which indicate what rows will be featured in the newly established table and whether or not null values will be present and on which side of the table they can appear on.
  4. SQL allows the creation of custom tables intended to simplify the process of inquiring. One type of custom table is called a Common Table Expression, or CTE, where a table is created based on the expression and is followed by a single inquiry. Another type is called a view, which stores a query in the database and allows the result of that query to be used in other queries. 
  5. Databases can have different orientations that dictate how data is stored, read, and modified. Row-oriented storage systems tend to perform adequately for query performance and maximum storage usage when rows are small relative to block size. Column-oriented storage systems tend to perform best for data compression algorithms and faster data access.

List at least 3 questions you still have about databases.

  1. How is data managed when being accessed and modified by multiple users simultaneously?
  2. How do database designers assist in implementing security measures for their database?
  3. Are there ways to save states or snapshots of a database, if so how is this done?

Comments

Post a Comment

Popular posts from this blog

Week 2 Learning Journal Post

Image
  Part 1: Learning Strategies When it comes to learning strategies, three areas I feel I am good at are creating an adequate study space, establishing study habits, and taking notes. Before I study, I make sure to clean my desk area and have drinks and snacks nearby for easy to reach replenishment. Then when I study, I make sure to add my notes in OneNote along with my assignment and quiz due dates so I can make sure to highlight and organize details based on when something will be needed for either. As for study habits, I make sure to set a timer so I don't sit down for more than 2 hours at a time so I can make sure to move around or give my brain a rest. Additionally, three areas I believe I am weakest in are writing papers, answering easy questions first, and not reading aloud. These all have a tendency to make me take longer doing assignments than I should have to. When I am writing a paper, like our industry analysis paper, I get so stuck on the words I am choosing and whether...
Read more

Week 1: Learning about CSUMB and the CS Major.

    This week, w e learned more about California State University Monterey Bay (CSUMB) and its school for computing and design (SCD). Prior to this course, I only had consideration for the computer science (CS) degree program, and it did not occur to me what else the school had to offer. It was interesting to learn about the campus' origin as an army base turned university and inspiring to hear how the university aims to mold their students into what sounds like successful and contributing individuals.      In addition to learning more about CSUMB and the SCD, we also began to work on our first essay outline and conducted a review of APA style formatting for referencing sources. I took a small number of English courses at my community college, so taking the time to review APA is essential for me to succeed in this course. For my essay, I decided to do an analysis of the cybersecurity industry, which is where I hope to work in after graduating.    ...
Read more

Week 3 Learning Journal Post

Part 1: Time Management and Study Strategy There was a short period of time when I first started college that I would go to the library to study, but that caused me social anxiety and I began focusing more on those around me than my work, so I just study at home. To improve my notetaking, I am going to try using the split page method and using colors. Additionally, I stated last week that I spent more time that I had allotted for my essay draft, so something new I plan to try is not to be a perfectionist and prioritize better.  Part 2: Learnings from This Week In addition to the other parts of this post, we gathered together with our teams to look into the various courses that are offered within the computer science (CS) curriculum and how they may serve an importance to us as CS majors. Additionally, we reviewed our Individual Learning Plans which indicate what courses we are expected to take and when we will take them. We also took some time to learn about how well we can read ot...
Read more