Relational Algebra and SQL: Better Together

Relational Algebra and SQL: Better Together

In this paper, we describe how database instructors can teach Relational Algebra and Structured Query Language together through programming. Students write query programs consisting of sequences of Relational Algebra operations vs. Structured Query Language SELECT statements. The query programs can...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Information systems education journal 2013-02, Vol.11 (1), p.4
Hauptverfasser: McMaster, Kirby, Sambasivam, Samuel, Hadfield, Steven, Wolthuis, Stuart
Format: Artikel
Sprache:eng
Schlagworte:
Algebra
Database Design
Educational Practices
Educational Strategies
Information Systems
Programming
Teaching Methods
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:In this paper, we describe how database instructors can teach Relational Algebra and Structured Query Language together through programming. Students write query programs consisting of sequences of Relational Algebra operations vs. Structured Query Language SELECT statements. The query programs can then be run interactively, allowing students to compare the results of Relational Algebra and equivalent Structured Query Language commands. In this way, students better understand both Relational Algebra and Structured Query Language--by writing code and watching it run.
ISSN:1545-679X
1545-679X