CST 363 Week 2 Learning Journal

-

 Part 1: Joining tables on columns that are not keys

An example of joining two tables using columns that are not keys would be in the example below: 

Query: select I.ID, I.name, C.course_id, C.title from instructor I inner join course C on I.dept_name=C.dept_name;

English sentence: List all instructors and the possible courses they can teach in their subject area. 

In the example above, we are combining an instructor table and a course table, where the primary keys are instructor ID and Course ID. We are connecting the two via dept_name, which is a column they share. The join above will connect each instructor to a possible class they can teach based on their assigned department. 

Part 2: Opinion of SQL as a Language

SQL is a pretty fun language to learn, even though it is a bit stressful at times. I think of it as a puzzle where each part matters in obtaining the right results (just like math!). It is easy to learn and use but one must be careful in each detail of the data that needs to be obtained. It is a bit difficult to translate from an English question with simple directions but requires queries that join two tables and the use of a subquery. There was one specific question on Homework 2 where we had to find the department with the most students majoring in that department. The directions are simple enough, but the query requires a temporary table joining two tables and a separate select statement with a subquery. It took me a while to come up with a solution, but it helped me learn more about how to use temporary tables and subqueries. 



Comments

Post a Comment

Popular posts from this blog

CST 300 - Week 8

-
 Part 1: Review of other team's final video projects Final Video Project Review # 1: Otter This World The video project from Otter This World is about Genomics. They describe how genomics is important and what advances we have made in this area. The topic is well-covered, and the presentation is clear. They cover each section described at the beginning of the video and provide various videos that go along with those sections. The quality of the research and video project is well done. They provide definitions and statistics with references. The video has a lot of visuals and could have used some slides with text at the beginning of each section. The information is being provided via audio, and there should be some text to supplement it. Also, the General Public video cuts off at the end with no conclusion. The video is engaging and interesting. They made a nice choice of visuals for each section. Team work is evident as each person had a section they covered. Overall, the video is ...
Read more

CST 300 - Week 5

-
Image
Part 1: Support and Comments on Teammates' Goals Victoria's Comment Guillermo's Comment Part 2: Possible Capstone Ideas Some ideas for capstone that I have are in the area of education with a focus on classroom management and video game design.  My first idea is to create a seating chart generator app for teachers to use in their classrooms. As a teacher, creating a seating chart can be a challenge. Whether you have a challenging class or are just looking to mix seats up, this app will help create the perfect seating chart. The app will give the teacher a variety of options to create a seating chart: individual, partner, or grouping (3 or more). The teacher can create a seating chart or groupings based on current grade in class, on an assignment, IEP requirements, or behavioral issues.  My second idea is to create a school environment application or website. With technology in the classroom becoming more and more popular, students are having to manage their own apps, homewo...
Read more

CST 300 - Week 6

-
  Part 1: Capstone Ideas Discussion In our team meeting, we discussed our possible capstone ideas and gave feedback on the ones that stood out to use.  Luis presented a 2D platform game, a music app for tuning instruments, and a database management program. His idea for the 2D platform game is to gain experience with game development. The music app would help with tuning an instrument, and his database management would help him gain experience with building a database.   Guillermo presented a pantry storage app, a music translator app, and a weather app. His idea for the pantry storage app would allow the user to create a list of items that they need to buy at a store. It would allow the user to enter items manually if no barcode exists and allow you to share the list with other people in the household. The weather app would focus on air quality.  Victoria presented an all-in-one educational app, a food information app, a fitness app, and a bookworm social media...
Read more