Week 17 - CST363 week 1

 This week we setup postgres locally. Going over the basics of what is a relation and formal representation of relational algebra such as selection, projection, union.

  • selection: get one or more rows from a table based on criterion
  • projection: get one or more attributes from a table
  • union: add the rows of two tables

something like `select first_name from people where id > 100` is a combination of selection and projection. we are selecting rows where id > 100, and then restricting the result to just the first_name attribute:

projection(selection(people,id > 100), ["first_name"])


Comments

Post a Comment

Popular posts from this blog

Week 2/100

Image
Part 1 Top 3 things I'm good at:  keeping to a schedule  extracting meaning and main ideas when reading writing from an outline Top 3 things that need work: removing distractions from my study space taking notes consistently going back to recite what I've read Part 2 Part 3 Projects are efforts to complete some objective that is aligned with a business strategy in a way that is bound by time, cope, and cost. The project manager is the CEO of a project, responsible for its execution. A work breakdown structure is a hierarchical breakdown of all deliverables in a project. It's organized from the entire project scope to major deliverables, and then recursively any sub-deliverables until there is an exhaustive list. The purpose is to define the full scope of the project and support creating a schedule and budget. Gantt charts are used to plan projects by drawing bars across a horizontal timeline indicating the start and end of each task. Each task lives on its own row in the ch...
Read more

week 8/100

 Team Video: Drone Delivery Technology General Audience:  https://youtu.be/DTrd9qXZAWg Professional Video:  https://www.youtube.com/watch?v=ppd_upisIGI Part 1: Video Reviews Group 8 https://youtu.be/jWQoO-hBeQc https://youtu.be/OdkkDc02Ktk?si=dihJHXxCwBZz8Zbx 1. is the topic well covered?  Good breadth in both videos, but since we did cover ethical frameworks well in CST 300 I would have liked to see some more arguments in that style. 2. is the presentation clear? Both presentations communicated the problem of ethical issues of AI at war clearly. 3. how is the quality of the research? No references cited. No discussion of different ethical frameworks. 4. how is the quality of the video production? Great use of video production tools. 5. is the video engaging and interesting? The GA video was unsettling. The music was upbeat and didn't really align with the topic of AI killing people. 6. is the team work evident? Could not tell who from the team did what since it was ...
Read more

Week 4/100

Part 1 I've been working towards a degree for 28 years. My first educational goal is to complete my BS degree in the timeline of this CSUMB program. I am still driving hard to complete an undergraduate degree so I have the option of pursuing further education. I'm interested in an MBA to refine my business leadership skills. My second educational goal is to be accepted to and start an MBA program in the year after completing my BS. Part 2 I want to return to organizational leadership but with a new set of skills that I learn from reaching my educational goals. I want to build and maintain a level of credibility in leading larger organizations than I have in the past, to end my career on a high note.  Part 3 I feel pretty good about the test. From going over the sample I have an idea of what my current gaps are. I think 18 months is plenty of time to close the gaps to get a good score. I think I will get at least 90%. I'm pretty confident in being able to prepare well, but a...
Read more