“Failure I can live with. Not trying is what I can’t handle.”
Sanya Richards-Ross
Oh man! We’re now in week 17, still in quarantine, and still struggling with time management. This week has been interesting as I feel as though it’s been the best week for me so far in terms of time management.
This week we’ve started our new course, Intro to Database Systems. We have three questions that we need to answer:
- Relational tables and spreadsheets look similar with both having rows and columns. What are some important differences between the two?
An important differences is that you can you can have many to many relationships in a relational table and you cannot in a spreadsheet. You can also use non primary keys in relational tables to uniquely identify rows.
2. What are some important reasons for using a database rather than just using files? (from orientation slides)
Accessing data from a file is much slower than running a query on a database.
3. An SQL select statements has SELECT, FROM, WHERE, ORDER BY, LIMIT parts. Which are optional and which are required?
The only one that is required is SELECT, the rest are optional.
Well that’s all for now. Will write more later this week!
jeanniecodes 