08_SQL.pdf - CS 200 Lecture 08 Relational Databases \u2013 SQL(Structured Query Language CS 200 Spring 2020 1 02 \u2013 Styles Administrivia BEFORE lab please

08_SQL.pdf - CS 200 Lecture 08 Relational Databases u2013...

This preview shows page 1 - 8 out of 55 pages.

CS 200 CS 200 Spring 2020 02 – Styles 1 Lecture 08 Relational Databases – SQL (Structured Query Language)
Image of page 1
CS 200 Spring 2020 02 – Styles BEFORE lab, please read and highlight Assignment 8 Database Design (on learn.uwaterloo.ca) Adapted from Access Database Design & Programming by Steven Roman The SQL tutorial notes (on learn.uwaterloo.ca) Slides for this lecture START the lab this week by doing the SQL tutorial Topics for today relational database design when you need another table, and why SQL (Structured Query Language) a model for relational databases Please ask questions! 2 Administrivia
Image of page 2
CS 200 Spring 2020 02 – Styles You’ve seen a two-table relational database you’ve been exposed to forms, reports, queries & data validation you’re familiar with the terms database table record (aka row) field (aka column) 3 Assumptions for Today’s Lecture
Image of page 3
CS 200 Spring 2020 02 – Styles Things to Think aboutHow does a DBMS differ from a spreadsheet?Why would I choose to use a DBMS?What are the reasons for needing more than one database table? 4
Image of page 4
CS 200 Spring 2020 02 – Styles 5
Image of page 5
CS 200 Spring 2020 02 – Styles Why use a database at all? Obvious questions: What do I mean by “structure” in a database? What’s the payoff? 6 Databases – Structured Data
Image of page 6
CS 200 Spring 2020 02 – Styles The visa worksheet in the Excel assignment is an example of a 1–table database, although we built it in Excel, not with a DBMS each ROW (“record”) holds data for a particular transaction each COLUMN holds a particular piece of data about that transaction (a “field”) we could have used FileMaker though for what we wanted to do, it wouldn’t have been worth the effort of learning FileMaker indeed, we could have placed the data in a Word table or even in a text processor (eg BBEdit)... separate fields by tabs, separate records by ¶ but working with the data would have been MUCH harder — think about implementing the Actual Balance and Statement Balance columns!
Image of page 7
Image of page 8

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture