Mediascripting on the Web (CSC 195 2014F) : EBoards

CSC 195 2014S, Class 13: SQL


Overview

Preliminaries

Admin

Questions

Key relational operations

Our database design project, continued

CDThing: A collaborative database of information on recorded popular music

Identify use cases

Song may be being used in two different ways

One suggestion

Songs

Person

Composition

Example

Song:

    112356x         Let It Be      5

Person:

    12132   John Lennon
    1263234 Paul McCartney

Composition

    112356x         12132   Composer
    1263235         1263234 Composer
    1263235         1263234 Lyricist

Recording

Tracks

Performer

Artists

Albums

Three kinds of relationships between data

SQL - Structured/Standard Query Language

Copyright (c) 2014 Samuel A. Rebelsky.

Creative Commons License

This work is licensed under a Creative Commons Attribution 3.0 Unported License. To view a copy of this license, visit http://creativecommons.org/licenses/by/3.0/ or send a letter to Creative Commons, 543 Howard Street, 5th Floor, San Francisco, California, 94105, USA.