Abstract
This paper illustrates the manner in which UML can be used to study mappings to different types of database systems. After introducing UML through a comparison to the EER model, UML diagrams are used to teach different approaches for mapping conceptual designs to the relational model. As we cover object-oriented and object-relational database systems, different features of UML are used over the same enterprise example to help students understand mapping alternatives for each model. Students are required to compare and contrast the mappings in each model as part of the learning process. For object-oriented and object-relational database systems, we address mappings to the ODMG and SQL99 standards in addition to specific commercial implementations.
Original language | English (US) |
---|---|
Title of host publication | SIGCSE Bulletin (Association for Computing Machinery, Special Interest Group on Computer Science Education) |
Pages | 21-25 |
Number of pages | 5 |
State | Published - 2003 |
Event | Proceedings of the 34th SIGCSE Technical Symposium on Computer Science Education - Reno,NV, United States Duration: Feb 19 2003 → Feb 22 2003 |
Other
Other | Proceedings of the 34th SIGCSE Technical Symposium on Computer Science Education |
---|---|
Country/Territory | United States |
City | Reno,NV |
Period | 2/19/03 → 2/22/03 |
Keywords
- Database design
- Entity-relationship model
- Object-oriented data model
- Object-relational data model
- Relational model
- Schema mappings
- Unified modeling language
ASJC Scopus subject areas
- Hardware and Architecture
- Software
- Food Science