News‎ > ‎

Intro to Databases

posted Oct 18, 2011, 1:58 PM by Eddie Woo
A big new topic! Databases. Whether you realise it or not, your life depends on databases. Every day, most of the actions that you take for granted - rely on massive databases doing their job without us noticing. Alarm clock on your phone? Catching a bus or train? Going to roll call (or signing on late)? Working out what classroom to walk to? Buying groceries from the supermarket?

Databases are there at every turn. They're tremendously important to the modern way of life. So let's get started!
  1. Define a database.

  2. Describe the primary elements of a basic database.

  3. Distinguish between flat-file and relational databases.

  4. Consider this example database.
    • Is it a flat-file or a relational database?
    • Populate it with appropriate data.
    • Explain how the database could be made more efficient.

  5. Identify ten examples of other databases that you use or benefit from on a daily basis. For each:
    • Identify whether it is flat-file or relational.
    • Describe its primary elements.
    • Give a concrete example of the data contained it.