Week 24

During this course we learned a lot about SQL and database but the empirical topics of this course has been the language SQL, designing schemas for databases and interacting with databases using Java. Initally we started of with learning how to query databases and then once we had a better

Week 23: Data warehousing

A data warehouse is a database that uses operational databases or external sources to store historical information for business analytics and intelligence. A data warehouse has become a vital business intelligence tool that has enabled companies and organizations to ensure consistency, make better decisions, and improve their bottom line. Furthermore,

Week 23: Data warehousing

A data warehouse is a database that uses operational databases or external sources to store historical information for business analytics and intelligence. A data warehouse has become a vital business intelligence tool that has enabled companies and organizations to ensure consistency, make better decisions, and improve their bottom line. Furthermore,

Week22: MongoDB

* Compare MongoDB with MySQL.  What are some similarities?  What are some differences?  When would you choose one over the other? * MongoDB and MySQL are both databases used to hold information. The biggest differences between the two would be how they store data, Mongo stores data in JSON documents which hold

Week22: MongoDB

* Compare MongoDB with MySQL.  What are some similarities?  What are some differences?  When would you choose one over the other? * MongoDB and MySQL are both databases used to hold information. The biggest differences between the two would be how they store data, Mongo stores data in JSON documents which hold

Week 21: Projects, Indicies and Concurrency

This is the second and final week working on our OtterZone medical database application. I've learned quite a bit about how querying remote databases works since we decided to host our DB on AWS to make changes and make our lives a little easier. The more frustrating aspect

Week 21: Projects, Indicies and Concurrency

This is the second and final week working on our OtterZone medical database application. I've learned quite a bit about how querying remote databases works since we decided to host our DB on AWS to make changes and make our lives a little easier. The more frustrating aspect

Week 20

Briefly summarize what you have learned in the course so far.  List at least 5 things. 1) I've learned how to create schemas and tables. 2) How to query a database with multiple relations to find an answer by using Select statements. 3)  Alter or drop tables and

Week 20

Briefly summarize what you have learned in the course so far.  List at least 5 things. 1) I've learned how to create schemas and tables. 2) How to query a database with multiple relations to find an answer by using Select statements. 3)  Alter or drop tables and

Week 19

To achieve the 3rd Normal Form relation,  a relation must be 2NF and not contain any transitive partial dependency. In simpler terms, there shouldn't be any non-key attributes that determine another attribute; furthermore, deleting x shouldn't affect y. 3NF is crucial for reducing data duplication and

Week 19

To achieve the 3rd Normal Form relation,  a relation must be 2NF and not contain any transitive partial dependency. In simpler terms, there shouldn't be any non-key attributes that determine another attribute; furthermore, deleting x shouldn't affect y. 3NF is crucial for reducing data duplication and

Week 18: Advanced SQL

SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ).  As long the column(s) are type compatible.   Most of the time the join will have a join predicate with primary key of one table equal to a foreign key of the other table.

Week 18: Advanced SQL

SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ).  As long the column(s) are type compatible.   Most of the time the join will have a join predicate with primary key of one table equal to a foreign key of the other table.

cst363

Week 17: SQL Adventures Begin

Week 17 marks the first week of my third class at CSUMB, CST 363 Database. While this is not my first time learning SQL it's definitely been interesting being reintroduced to it after a long time. Relational database tables and spreadsheets look similar with both having rows and

cst363

Week 17: SQL Adventures Begin

Week 17 marks the first week of my third class at CSUMB, CST 363 Database. While this is not my first time learning SQL it's definitely been interesting being reintroduced to it after a long time. Relational database tables and spreadsheets look similar with both having rows and

Week 16

They say hindsight is 20/20, what advice would you give to the next cohort regarding this course? Do not procrastinate. I recommend watching a lot of YouTube videos on Java concepts. Do your best to communicate with your team as possible Slack is a great way to stay in

Week 16

They say hindsight is 20/20, what advice would you give to the next cohort regarding this course? Do not procrastinate. I recommend watching a lot of YouTube videos on Java concepts. Do your best to communicate with your team as possible Slack is a great way to stay in

Week:15 Android App Dev

Have you ever created an app before, either for Android or iPhone?  How did it go? I've never created an app for a mobile device before but I have created desktop applications using visual basic and qtpy. I had created a package tracking app which was definitely fun

Week:15 Android App Dev

Have you ever created an app before, either for Android or iPhone?  How did it go? I've never created an app for a mobile device before but I have created desktop applications using visual basic and qtpy. I had created a package tracking app which was definitely fun

Week 14

What experience do you have with UML diagrams? Most of my UML diagrams experience comes from having to create them for classes. I have found them to be a great way to understand how programs work and what data I am working with. Are they used at your workplace? Unfortunately,

Week 14

What experience do you have with UML diagrams? Most of my UML diagrams experience comes from having to create them for classes. I have found them to be a great way to understand how programs work and what data I am working with. Are they used at your workplace? Unfortunately,

Week 13

GUI is learned late in the game with Java.  Do you think this is helpful or harmful and why? I think this is helpful to some extent. While learning java I feel that it is important to learn the basics and OOP initially. By learning GUI late we're

Week 13

GUI is learned late in the game with Java.  Do you think this is helpful or harmful and why? I think this is helpful to some extent. While learning java I feel that it is important to learn the basics and OOP initially. By learning GUI late we're

Week 12

Give an example of polymorphism: Basically polymorphism is shapeshifting objects where one many different objects can be under one name. Suppose there is a base class called Fruit, and three other derived classes that extend Fruit class called Apple, Orange, and Strawberry. Theses classes have their own constructors and thus

Week 12

Give an example of polymorphism: Basically polymorphism is shapeshifting objects where one many different objects can be under one name. Suppose there is a base class called Fruit, and three other derived classes that extend Fruit class called Apple, Orange, and Strawberry. Theses classes have their own constructors and thus