Posts

Showing posts from January, 2025

CST363 - Week 3

1. A view is a table like structure associated with a select statement; it contains rows and columns, just like a table. 2. I think labels could be considered as variables, and a table could be similar to a structure. Beyond that, I'm not sure what else could be compared if the user input differs from SQL or the loops.

CST363 - Week 2

1. I couldn't think of an example, so I just searched for one. For instance, finding salary ranges that include all employees and their respective salary ranges.  SELECT employees.ID, employees.name, employees.salary FROM employees JOIN salaries ON employees.salary BETWEEN salaries.min_salary AND salaries.max_salary; 2. I find it easy to learn and improve with practice, though I consider some commands, like subqueries and having, to be challenging as I was initially unfamiliar with them.

CST363-Week1

 1. I think the differences are the keys that let you move through data tables, and the learning curve is another one. 2. Probably with larger projects, learning and maintaining a database is important because it makes it easier to find values compared to a spreadsheet with a lot of data. 3. I want to learn how to maintain and read databases better. For HW1, I had to look up references on joins and substring methods on W3Schools, so learning more MySQL methods would definitely be helpful.