OpenLine can provide a variety of materials which supplement the lecture slides on the Theory, Practice & Methodology of Relational Database Design and Programming
- Visual and Textual Languages for Entity-Relationship Modeling: This manual describes visual and textual languages used for ER (Entity-Relationship) based conceptual modeling. It describes the visual ER modeling language Crow Magnum™ (and its variant Easy Crow Magnum™), a new language based on the Crow's Foot notation, but also influenced by UML and Chen, developed to provide a coherent visual ER language that is comprehensive and consistent, and which has both practical and pedagogical advantages over other languages used for database-oriented conceptual modeling. The manual provides a detailed introduction to conceptual modeling using Crow Magnum™, along with detailed feature-by-feature comparisons with both UML and Chen. The manual also describes ConText, a Conceptual Text-based ER modeling language designed in conjunction with Crow Magnum™ for communicating conceptual designs without requiring drawing. ConText is also used along with Crow Magnum™ for specifying notes and constraints.
- Relational Modeling: This manual describes relational modelling using extended Relational Schema diagrams, SQL, and a more succint textual language, TRex. The usual Relational Schema diagrams, with underlines representing primary keys and arrowed lines representing foreign key constraints, are augmented with symbols for cascading deletes, and for non-null and uniqueness constraints.
- Relational Mapping: This slide set summarizes mappings between Crow Magnum™ models and Relational Schema models.
- REAL: The Relation Expression and Assignment Language: This manual describes the syntax and semantics of REAL, a concise, readable, and complete language for the relational algebra, which can be used to express any order-independent SQL query expression. In addition to support for duplicate tuples, grouping and algebraic computation, REAL also has been extended to support transitionalized relations (with a before and after state) and tuple identity. REAL predicates can be used to express state constraints (i.e. invariants), access constraints (i.e. generalized pre-conditions), and transition constraints (i.e. generalized post-conditions). REAL's expressiveness makes it possible to define both functional and multivalued dependencies clearly and concisely.
- Problem and Solution Sets: Problems and Solutions in SQL and Conceptual and Relational Design.
- Application Design Training Instructions & Environment: A sequence of instructions for students developing their first database application, along with a SQP*Plus/PL-SQL environment that will simplify what they need to do.
Contact us at requests@openlineconsult.com for licensing information.