WinRDBI: A windows-based relational database educational tool

Suzanne Dietrich, Eric Eckert, Kevin Piscator

Research output: Chapter in Book/Report/Conference proceedingChapter

17 Citations (Scopus)

Abstract

RDBI is an educational tool that provides students with the capability to test their understanding of the formal relational query languages (relational algebra, domain relational calculus and tuple relational calculus) and the industry standard query language SQL. Although RDBI is an integral part of the database management courses at a number of universities, it is unavailable to those universities that do not have a license for the software product in which RDBI is implemented. WinRDBI, a version of RDBI for Windows, removes this limitation by increasing the availability of the educational tool to a standard Windows platform. Another advantage of WinRDBI is its graphical user interface, providing the student with a more intuitive interface than the command line interface of RDBI. This paper describes the architecture and user interface of WinRDBI. The features of WinRDBI are also illustrated using nontrivial examples from a popular database text. Although formal relational query languages do not provide inherent support for aggregation, these examples illustrate how to write queries in the formal languages to support (a limited form of) counting and minimum/maximum queries.

Original languageEnglish (US)
Title of host publicationSIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education)
Pages126-130
Number of pages5
Volume29
Edition1
StatePublished - Mar 1997

Fingerprint

user interface
calculi
Query languages
students
Language
Databases
Calculi
Students
Formal languages
Graphical user interfaces
industry
Algebra
User interfaces
Licensure
Agglomeration
Availability
Industry
Software
testing
algebra

ASJC Scopus subject areas

  • Food Science
  • Hardware and Architecture
  • Software

Cite this

Dietrich, S., Eckert, E., & Piscator, K. (1997). WinRDBI: A windows-based relational database educational tool. In SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education) (1 ed., Vol. 29, pp. 126-130)

WinRDBI : A windows-based relational database educational tool. / Dietrich, Suzanne; Eckert, Eric; Piscator, Kevin.

SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education). Vol. 29 1. ed. 1997. p. 126-130.

Research output: Chapter in Book/Report/Conference proceedingChapter

Dietrich, S, Eckert, E & Piscator, K 1997, WinRDBI: A windows-based relational database educational tool. in SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education). 1 edn, vol. 29, pp. 126-130.
Dietrich S, Eckert E, Piscator K. WinRDBI: A windows-based relational database educational tool. In SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education). 1 ed. Vol. 29. 1997. p. 126-130
Dietrich, Suzanne ; Eckert, Eric ; Piscator, Kevin. / WinRDBI : A windows-based relational database educational tool. SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education). Vol. 29 1. ed. 1997. pp. 126-130
@inbook{115494173e1543399cd1e24cbd5ed97b,
title = "WinRDBI: A windows-based relational database educational tool",
abstract = "RDBI is an educational tool that provides students with the capability to test their understanding of the formal relational query languages (relational algebra, domain relational calculus and tuple relational calculus) and the industry standard query language SQL. Although RDBI is an integral part of the database management courses at a number of universities, it is unavailable to those universities that do not have a license for the software product in which RDBI is implemented. WinRDBI, a version of RDBI for Windows, removes this limitation by increasing the availability of the educational tool to a standard Windows platform. Another advantage of WinRDBI is its graphical user interface, providing the student with a more intuitive interface than the command line interface of RDBI. This paper describes the architecture and user interface of WinRDBI. The features of WinRDBI are also illustrated using nontrivial examples from a popular database text. Although formal relational query languages do not provide inherent support for aggregation, these examples illustrate how to write queries in the formal languages to support (a limited form of) counting and minimum/maximum queries.",
author = "Suzanne Dietrich and Eric Eckert and Kevin Piscator",
year = "1997",
month = "3",
language = "English (US)",
volume = "29",
pages = "126--130",
booktitle = "SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education)",
edition = "1",

}

TY - CHAP

T1 - WinRDBI

T2 - A windows-based relational database educational tool

AU - Dietrich, Suzanne

AU - Eckert, Eric

AU - Piscator, Kevin

PY - 1997/3

Y1 - 1997/3

N2 - RDBI is an educational tool that provides students with the capability to test their understanding of the formal relational query languages (relational algebra, domain relational calculus and tuple relational calculus) and the industry standard query language SQL. Although RDBI is an integral part of the database management courses at a number of universities, it is unavailable to those universities that do not have a license for the software product in which RDBI is implemented. WinRDBI, a version of RDBI for Windows, removes this limitation by increasing the availability of the educational tool to a standard Windows platform. Another advantage of WinRDBI is its graphical user interface, providing the student with a more intuitive interface than the command line interface of RDBI. This paper describes the architecture and user interface of WinRDBI. The features of WinRDBI are also illustrated using nontrivial examples from a popular database text. Although formal relational query languages do not provide inherent support for aggregation, these examples illustrate how to write queries in the formal languages to support (a limited form of) counting and minimum/maximum queries.

AB - RDBI is an educational tool that provides students with the capability to test their understanding of the formal relational query languages (relational algebra, domain relational calculus and tuple relational calculus) and the industry standard query language SQL. Although RDBI is an integral part of the database management courses at a number of universities, it is unavailable to those universities that do not have a license for the software product in which RDBI is implemented. WinRDBI, a version of RDBI for Windows, removes this limitation by increasing the availability of the educational tool to a standard Windows platform. Another advantage of WinRDBI is its graphical user interface, providing the student with a more intuitive interface than the command line interface of RDBI. This paper describes the architecture and user interface of WinRDBI. The features of WinRDBI are also illustrated using nontrivial examples from a popular database text. Although formal relational query languages do not provide inherent support for aggregation, these examples illustrate how to write queries in the formal languages to support (a limited form of) counting and minimum/maximum queries.

UR - http://www.scopus.com/inward/record.url?scp=0030646706&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0030646706&partnerID=8YFLogxK

M3 - Chapter

AN - SCOPUS:0030646706

VL - 29

SP - 126

EP - 130

BT - SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education)

ER -