-

 

Week 8 – CST– 363 Introduction to Database Systems

Briefly summarize what you consider to be the three (3) most important things you learned in this course.

I thoroughly enjoyed this class and everything I learned in this course will be important in my journey to becoming a software engineer. Prior to this class, the only exposure to databases I had was creating a room database for an android app in android studio for CST-338 Software Design. Needless to say, I learned a lot.

Although I still have to continue practicing, one of the most important things I learned in this course was coding in SQL. We learned how to read schemas and interpret that schema into a functional database. I can use SQL to create tables and relationships between those tables with the use of primary and foreign keys. I also learned how to use SQL to search databases by using queries. Queries can be a simple select statement from a single table or a complex query that requires the use of grouping, joins, and subqueries from multiple tables.

Another especially important concept that we learned is transaction management. A transaction is a sequence of database operations that must be completed or rejected as a whole. If the transaction is partial or incomplete, it becomes inconsistent or incorrect data. When a transaction is completed successfully, you can save the results by executing a commit. In contrast, when a transaction fails, the database executes a rollback which reverses a transaction and resets data to the initial values. All transactions must be atomic, consistent, isolated, and durable (ACID). Atomic means that all the transactions must be executed and applied to the database otherwise it must be rolled back. Consistent means that only valid data is committed, otherwise, the transaction is rolled back. Isolated means that all transactions must be processed without interference from other transactions. Lastly, durable means that once a transaction is committed, the data is permanently saved in the database regardless of system failures.

Although I enjoy MySQL and the relational database concept, learning the basics to other types of DBMS like MongoDB is extremely important. MySQL is a relational structured database that uses fixed schema while MongoDB is a document database where the schema is flexible. Designing a database using MySQL workbench and using that database to create a web application was a great way to familiarize ourselves with how a database is used in an online application. Finally, using the same database and converting it to use MongoDB showed us the differences and similarities between the two DBMS.

 

 

 

Comments

Post a Comment

Popular posts from this blog

-
Image
  Week 2- CST-300 Module 2 OLI – Module 2 This week’s module focused on collective intelligence, reading the mind in the eyes, behavior of good teams, and why team skills will help after graduation. Collective intelligence illustrated how teams that have better collaboration skills were more successful. Meaning that everyone participated and contributed to complete the task or project. Some key features of successful teams were equal participation, higher number of women, and social sensitivity. I enjoyed the reading the mind in the eyes activity. It is difficult to tell a person’s emotions by examining just their eyes and not the entire face or body language. I scored about average. I will continue to participate and share my thoughts and ideas on topics being discussed in my team. Behaviors of good teams was a research article done at google looking for the perfect team. They found that teams promote better job satisfaction, better problem solutions and faster innovation.
Read more
-
Image
  Week 1- CST-300 Module 0 & 1 Team Resume Hello and welcome to my first post. This is a screen shot of our team resume. Although we ran into issues with some members missing, we eventually joined with another group and managed to collaborate on this assignment. Our team did an excellent job with their bios and completed the assignment on time. Module 1 Lecture   The readings from module 1 taught me about CSUMB's history and vision statement. It also covered the Degree programs from the School of Computing and Design and its faculty. The lecture also included a video titled "Study Tips to Succeed as an Online Student." The video taught me that I will need to read the syllabus, plan weekly study times, connect with classmates, check canvas frequently, and ask questions to be successful in this class.   Module 1 Lab   The lab for this week explains the American Psychological Association (APA) writing style. APA is the style used by the Computer Science departmen
Read more
-
  Week 3- CST-300 Module 3   OLI – Module 3 This week’s module is titled “What do You Bring to the Team?” and it is made up of six sections. The first section was Processing Styles and Diversity Communication. It explains approaches that would help an internal processor in your team. Some examples were to think silently for a minutes before discussing for answers, ask if members need more time before responding, and use email to communicate. The second section was Work Styles. Here we learned about work styles Get it Right – Task oriented, Get it Done – Task oriented, Get Along – people oriented, and Get Appreciation – People oriented. Each style had its strengths and weaknesses and we had to figure out how to balance them or how to help others with a different style. The third section was Your Booth Team Members. Here we watched a video of each booth member. We were then tasked with ways to support each member’s work style. The fourth section was Conflict Styles. It focuse
Read more