Faith Thomas

SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ).    Most of the time the join will use equality between a primary and foreign key.   Think of example where joining on something other than keys would be needed.  Write the query both as an English sentence and in SQL.  If you can't think of your own example, search the textbook or internet for an example. English: Match each student to any course that gives more credits than the number of credits the student has already earned SQL: select student.name, student.tot_cred, course.course_id, course.credits from  student join  course on  course.credits > student.tot_cred; What is your opinion of SQL as a language?  Do you think it is easy to learn and use?  When translating from an English question to SQL, what kinds of questions do you find most challenging? This is the first class where I have really focused on SQL. TO be honest, I do find...

Relational database tables and spreadsheets look similar with both having rows and columns.  What are some important differences between the two? A database is structured and enforces rules, while a spreadsheet lets me put almost anything anywhere. Databases can link tables and handle many people editing safely at the same time. They’re also better for large data, with real security and backups, whereas spreadsheets can get messy and break. Installing and configuration a database and learning how to use it is more complicated that just reading and writing data to a file.  What are some important reasons that makes a database a useful investment of time?  It keeps my data accurate and saves changes safely even if something goes wrong. I can ask complex questions with simple queries instead of fighting with formulas. It also supports multiple users and backups so a project can grow without chaos. What do you want to learn in this course that you think will be useful in your...